PHP - Moved: Php/mysql Projects For A Newbie, Intermediate, And Advanced

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=342707.0

I created a shell script in OS X which forces my Macbook to connect to a MySQL database to see if my laptop was stolen.  I can mark the Macbook as stolen in the database, which would provide me with a series of fuctions; one of these functions allows you to take pictures through the iSight camera and upload to an FTP server.  The script and database work well, but now I'm trying to make it more user friendly by making it web-based.

Here is an example of the code I'm having trouble with:

$picture = mysql_query("SELECT picture FROM laptops");
$picrow = mysql_fetch_array($picture);

if ( $picrow[0] == 0){
echo "<td>" . "<center><a href='start.php?cmd=start&id=$row[UID]'><img
src='images/stopped.gif'></center></a>" . "</td>";

} else {

echo "<td>" . "<center><a href='stop.php?cmd=stop&id=$row[UID]'><img
src='images/started.gif'></center></a>" . "</td>";

}

In the database there is a "1" for active and a "0" for inactive.  What it's looking to do is ask to see if it's active or inactive.  If it's active, it will have a green button, and inactive with have a red button.  Eventually I'd like to be able to activate and deactivate functions by pressing the button, but I need to complete step 1 first.

Currently this code does work (except for the links of course); however, I need to specify the number in the array ($picrow[0], $picrow[1], etc.)  How do I have this populate automatically from 0 to infinity?  I made a field in the database called UID (starting at 1) that automatically increments.  I'm not sure if this
would help or not.

Thanks in advance.

So, I've just recently gotten into the more advanced web scripting after writing static HTML pages for years and I must say it's pretty exciting.  I've finally got my home LAMP up and running and I'm really excited about learning PHP and getting into dynamic web content.  One of the areas that I'm really interested in is writing applications for my work and that's one of the first things I've been getting into first.  I have some PHP code below that is giving me fits though, I'm afraid.

MySQL server version: 5.1.49-1ubuntu8.1 (Ubuntu)

My goal:
I have an HTML page that has a text input, a drop down box and a submit button.  The user inputs a username into the text field, and chooses an option from the drop down box and hits the submit button.  I would like for a table holding member information to be updated to reflect the new status based on the user input from the forms.  My table, named 'members', has the following fields:


id (int) (primary)
name (varchar)
username (varchar)
department (varchar)
type (varchar)
status (int)


The status is a 0 or a 1.  Effectively a True/False field.

Here's the code in question:


<?php
// Set variables to get the username and the away/here status
// also trim the username variable to ensure there are no inadvertent extra whitespace characters at the 
// beginning or end
$username=$_POST["username"];
$username=trim($username);
$status=$_POST["statuschange"];

// Check to ensure the username had a value input
// This should be ran before the connection to the database is made to lessen impact on the web server
// This is a temporary method, the production version should have a JavaScript function to check form input before
// being passed on to the web server
if (!$username)
{
echo "No username was submitted, please try again.  Redirecting to main page.";
echo "<meta http-equiv='refresh' content='3;url=/ns_index.php' />";
exit;
}

// Set variables to connect to the mysql server and to access the database
// root user is for development purposes only.  The production version should have a user setup
// specifically for accessing the database with restricted privileges
$ns_dev_conn=mysql_pconnect("localhost","mysql","mysqlpwd") or die("Could not connect: ".mysql_error());
$dbvar=mysql_select_db("dbname",$ns_dev_conn) or die("Could not select database: ".mysql_error());

// Set variables for the SQL statement and results
$statusaway="0";
$statushere="1";

// Create the SQL statements based on the status being either away or here
// This method of generating the SQL statement was used based on recommendation by: http://www.php.net/
if ($status=="away")
{
$status_query=sprintf("UPDATE `members` SET `status`='%s' WHERE `username`='%s'",mysql_real_escape_string($statusaway),mysql_real_escape_string($username));
}
else
{
$status_query=sprintf("UPDATE `members` SET `status`='%s' WHERE `username`='%s'",mysql_real_escape_string($statushere),mysql_real_escape_string($username));
}

// Set the variable to determine the result of the query
$result=mysql_query($status_query,$ns_dev_conn) or die("Query failed: ".mysql_error());

// Determine if any rows were affected
$num_rows=mysql_affected_rows($result, $ns_dev_conn) or die("Hrrmm. . .<b>".$username."</b>'s status could not be changed to <b>".$status."</b>.  Please go back and try again.  MySQL Error: ".mysql_error());

// This is a development only block of code
// Echo all the variables to ensure the proper values are being passed
// If these variables aren't being echoed one of the die() functions was passed.  
// Compare the error message received to the other die() functions to determine what is invalid
// To get the variable values comment out the bad expression
echo "Username: ".$username;
echo "<br />Status (char): ".$status;
echo "<br />Status away (int): ".$statusaway;
echo "<br />Status here (int): ".$statushere;
echo "<br />Server Connection Link ID: ".$ns_dev_conn;
echo "<br />Database Selection ID: ".$dbvar;
echo "<br />SQL Statement: ".$status_query;
echo "<br />Result: ".$result;
echo "<br />Number of Affected rows: ".mysql_affected_rows($result);

/* This should be uncommented for production version
// If $num_rows didn't die than the database was updated
// Update the user that the query was successful and then redirect them back to the main page
echo $username."'s status was updated to ".$status.".  You will be redirected to the main page now.";
echo "<meta http-equiv="refresh" content="4;url='/ns_index.php'" />";
*/
?>


So, I've tried a bunch of different things, including echoing back all the variables to ensure the connection and SQL statements are correct, in addition I've taken the echoed SQL statement and copied it into phpmyadmin and the statement works with no errors!  I've also looked at the mysql_info() return values and the row is being matched, it's just not being changed or affected.  Right now when I activate this script it's returning the error associated with die() on mysql_affected_rows().  This is telling me that everything is working, except for the table actually being updated.  Also, just for development and testing purposes I've been using the root MySQL user so I'm pretty sure it's not a privilege issue.

If anybody could provide some insight into this problem I'd be most appreciative.

Thanks.

Code: [Select]
<?php
$verificate = $_GET["ver"];
$username = $_GET["user"];
$password = $_GET["pass"];

$dbh = mysql_connect("localhost","XXXXXX_dtbusre","my database password here")
                            or die(mysql_error());
mysql_select_db("databasename_zxq_dtb")     or die(mysql_error());
$sql = "SELECT loggedin FROM entityTable WHERE username=$username";
$result = mysql_query($sql) or die(mysql_error());
while ($line = mysql_fetch_array($result)){
  echo $line[0]."\t".$line[1]."\n";
}
mysql_close($dbh);

if($verificate === "144356455343"){
echo "SURE";
}
else{
echo "NOPE";
}
?>
I get this:
Code: [Select]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Hi so i've been learning php for 3 mouth now by reading php 6 Bible and watching lynda and so on... i was looking for a job in few past weeks and i found out i don't have that kind of self confidence to go for it ! you know when they say : PHP Project Manager , it scar's me... the thing is , i know all about basic to medium php , array...MySQL....all those essentials but i don't know what do they want from a php web developer . so i began to search for intern job somewhere and i told myself i should bust my ass 24/7 for few mouth and after that i ll be real php guy and it seems like there is no place to reach not  php but almost all programming languages a year ago i was searching for the same thing but in networking section and there was 100's of intern ship jobs but in programming there is none ! so i want some one to give me (us) simple to pro real life projects . what do they want php junior or senior developer's for ? what do they do? what is the most common needs ? what is the most essential things to know? what is a hired php developer should do in the office? some people doesn't need you in the office and want you to work from home , they give you project's , what's that? is there any source in the web to offer what is need ? i know its too much , but this was my last option , so if anyone can help i would practically owe him/her my whole future salaries...

Is it okay to post projects for hire in here?

I have about a dozen small tasks I need done.

Jared

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=308937.0

Hi there   I am just finalising my first ever PHP/MYSQL project and I am worried about where to safely keep my connection credentials for the SQL DB.   Currently, I am storing them in ../php/config.php and this works fine, but I am worried as to the security of this   Can anyone advise please   Thanks

Hi, everyone.   I'm having some trouble finding tutorial projects for PHP Functions. Can anyone point me in the right direction if you know of any? I apologize if this is the wrong category to post in for my particular question.

Hey folks,   I'm looking for an open-source php project to contribute to. I'm not looking for a really well-known project (ex: Wordpress, Zencart) Something small would be greatly appreciated!

My website is http://www.infotechnologist.biz.   We handle Web Site Development, web app development, and mobile development. No project is too big, or too small.   Contact me today with details.   My number is 4049390637.

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=321319.0

Hello all brilliant minds,

I'm a new in all this world of DB and coding and always i tried to avoid it because I think it is very hard (I'm trying to change now).

problem: I have a text file (log.txt) have data like below
========================================
> rtrv-ls

Command Accepted - Processing

    OXX 12-02-21 08:44:41 EST  EAGLE5 42.0.1-63.38.31
    rtrv-ls
    Command entered at terminal #7.
;

    OXX 12-02-21 08:44:41 EST  EAGLE5 42.0.1-63.38.31

                                                   L3T  SLT              GWS GWS GWS
    LSN           APCI   (SS7)  SCRN SET SET BEI LST LNKS ACT MES  DIS SLSCI NIS
    gtcen1pls     7-010-4       none 1    2    no   D    2        off   off   off    no    off
    gtgdv1pls     7-010-5       none 1    2    no   D    2        off   off   off    no    off

> rtrv-sid

Command Accepted - Processing

    OXX 12-02-21 08:43:43 EST  EAGLE5 42.0.1-63.38.31
    rtrv-sid
    Command entered at terminal #7.
;

    OXX 12-02-21 08:43:43 EST  EAGLE5 42.0.1-63.38.31
       PCA                       PCI          PCN                CLLI              PCTYPE
       010-010-010     7-055-1      01830              crher1p           OTHER
;
.
.
may output like this starting always with >

===================================================
Then I have SQL DB that have column with "rtrv-ls" and "rtrv-sid"

Requirement :

A) Use Php to open the .txt file, I used HTML form so the user can upload the file on the browser then
B) Search for the column name as pattern
C)Send query to MYSQL to update DB with Data for each column
D) Query the Mysql for several possible outputs (I've done this part using HTML form and simple php code as below.

<?php

// If we got a GET request on the page from HTML part of the code, we will want to store the data in a variable e.g $my_country
// So country will be passed via GET and will be stored in $my_country variable.

$host="localhost";
$con_usr="aomar";
$con_pass="nokia";

if ($_POST)   {
            $user_input = $_POST['my_log'] ;

// We use the request to search in Database and return the result, First step we need to connect to the database //

                $connect = mysql_connect ($host,$con_usr,$con_pass);
   
// Then we need to select database to run the query and return the result the connection stored in the $connect ressource //
   
if ($connect) {
              mysql_select_db("eagle",$connect);

// We store the query in variable $query becuase is it quite long text; we actually attach our varaiable $my_log passed from HTML //
         
              $query = "SELECT `".$user_input."` FROM `ss7`";

         //$update="INSERT INTO ss7 ('".$user_input."') VLAUES (';


// SO if user selected Egypt it will be stored in (name=my_country) variable from HTML and will be send via GET
// Then we store the query results in a variable called $result      
       
          $result = mysql_query ($query) ;
   

 $arr= mysql_fetch_array($result);
 
       
         echo nl2br ($arr["$user_input"]);
 
 
//Finally we return what we want from the array.
// Print the output as we wish. in case of row data like STP output, use the nl2br to preserve the output as it was written to MYSQL DB
// We need to check if the Query return no value (!$arr) , and print corresponding action

     
 
 
   
}
//================SECONED PART WHEN I LOAD THE LOG FILE TO BE STORED IN MYSQL================//


   
//close the db
mysql_close ($connect);
}
?>



<html>
<body>
<form action = "eagle.php?pmode=my_file" method = "POST"   enctype="multipart/form-data>
<fieldset>
<legend> Enter you log file here and click Save: </br> </legend>
<label for="my_file"> This Is My Capture File </label>
<input type = "file" name ="my_file" style=margin:auto > </input><br/><br/>
<input type="submit" value="Upload file">
</fieldset>
</form>
</body>
</html>   




<html>
<body>

<title>Eagle Data Base Store</title>
<form action = "eagle.php?pmode=my_log" method = "POST">
<fieldset>
<legend> Please Select the DB you would like to retrive </legend>
<br/><br/>
   <input type = "radio" name ="my_log" value = "rtrv-serial-num">Serial-Num</input>
    <input type = "radio" name ="my_log" value = "rtrv-stp">rtrv-stp</input>
   <input type = "radio" name ="my_log" value = "rtrv-feat">rtrv-feat</input>
   <input type = "radio" name ="my_log" value = "rtrv-dstn">rtrv-dstn</input>
   <input type = "radio" name ="my_log" value = "rtrv-rte">rtrv-rte</input>
   <input type = "radio" name ="my_log" value = "rtrv-trm">rtrv-trm</input>
   <input type = "radio" name ="my_log" value = "rtrv-slk">rtrv-slk</input><br/> <br/>
   <input type = "radio" name ="my_log" value = "rtrv-ls">rtrv-ls</input>
   <input type = "radio" name ="my_log" value = "rtrv-sccpopts">rtrv-sccpopts</input>
   <input type = "radio" name ="my_log" value = "rtrv-stpopts">rtrv-stpopts</input>
   <input type = "radio" name ="my_log" value = "rtrv-gsmopts">rtrv-gsmopts</input>
   <input type = "radio" name ="my_log" value = "rtrv-cmd">rtrv-cmd</input>
   <input type = "radio" name ="my_log" value = "rtrv-assoc">rtrv-assoc</input><br/> <br/>
   <input type = "radio" name ="my_log" value = "rtrv-gpl">rtrv-gpl</input>
   <input type = "radio" name ="my_log" value = "rtrv-ip-host">rtrv-ip-host</input>
   <input type = "radio" name ="my_log" value = "rtrv-ip-lnk">rtrv-ip-lnk</input>
   <input type = "radio" name ="my_log" value = "rtrv-secu-trm">rtrv-secu-trm</input>
   <input type = "radio" name ="my_log" value = "rtrv-secu-user">rtrc-secu-user</input>
   <input type = "radio" name ="my_log" value = "rept-stat-sys">rept-stat-sys</input><br/><br/>
   <input type = "radio" name ="my_log" value = "rept-stat-clk">rept-stat-clk</input>
   <input type = "radio" name ="my_log" value = "rtrv-ctrl-feat">rtrv-ctrl-feat</input>
   <input type = "radio" name ="my_log" value = "rtrv-tabl-capacity">rtrv-tabl-capacity</input><br/><br/>

   <input type = "submit" value = "Show Selected Table"/>
   
</fieldset>
</form>
</body>
</html>   

==========================================END OF CODE===========================

*** Sorry for the many comments but I want to be sure I remember why I do that .

You help is much appreciated
(Please note that need to understand more than I need the Code itself)

I must confess, I've not really done much unit testing at all in the last 3 years. Can anyone give me an idea of what they would test and why that would be faster or more efficient than running the code as a user?

One area I can see it having huge benefits is when I'm testing methods which interact with a database, like user registration, which I would probably test by registering several times - fixing any bugs, making amendments and repeating. Ok, so I kinda sold the idea to myself there

But, what about for small applications? I've seen people testing whether a variable is countable...why would I not just check the output immediately?

Appreciate any advice.

Hello all. I'm looking to build a website in php that will be large in scope and I'm looking for some direction as to how to go about coding it. What I'm referring to exactly is the programming model. I'm new to the language, but not to programming, and I've read up on it and familiarized myself with the syntax over the past few days. Normally when I go about building a project I like to plan ahead how I'm going to build It so I don't run into tedious issues later on and this is what I need help with.   My concerns:  I am looking to use the alternative syntax for control structures as to make the php code inside my html readable and easier to manage but in terms of OOP when is it best for me to use classes vs functions?  I am leaning towards using both classes and functions. Classes to handle polling data, sanitizing it and storing it while the functions will be used , with the alternative syntax, to display the data. How should I go about properly setting my project assuming I will have many concurrent users using the website at once? Is using xml / INI files as a directory to look up information a good practice? Is it better to declare constant variables instead? When working with multiple includes is there an easier way to include a file than having to explicity write "dirname( dirname(__FILE__) )" everytime?   I'm essentially looking for guidance / tips as to good programming practices with this language Advanced practices are welcomed as well.     Development Tools: XAMPP ( Windows 7 Pro ) PHPStorm    Current directory structure plan:   Here is what I currently have:     The API class is a collection of functions that returns an object to be used at a later data.

<?php

/*
 * Development API Key
 * @since 1.0
 *
 * Rate Limit(s):
 * 10 request(s) every 10 second(s)
 * 500 request(s) every 10 minute(s)
 */
define( "__API_KEY__" , "---------------------------------" );

require_once dirname( dirname(__FILE__) ) . "\\settings.php";

class API
{

    // If successfull it returns an object from the url that's passed to this function.	
    private function api_call($url)
    {
	$result = null; // end result

        // Create a new curl handle.
        $ch = curl_init();

        curl_setopt($ch , CURLOPT_URL, "https://" . $url . "?api_key=" . __RIOT_API_KEY__); // set the URL
        curl_setopt($ch , CURLOPT_RETURNTRANSFER , true  ); // return the transfer as a string of the return value
        curl_setopt($ch , CURLOPT_SSL_VERIFYPEER , false ); // turn off ssl certificate verification

        // Execute the api call
        $response = curl_exec($ch);
        // Get info to analyze the result
        $ci = curl_getinfo($ch);

        $httpcode = $ci["http_code"];

        // If a curl error occured
        if(curl_errno($ch) || ($httpcode != "200"))
        {
            $die  = "Curl Error Code: "    . $httpcode       . "<br/>";
            $die .= "Curl Error Message: " . curl_errno($ch) . "<br/>";
            $die .= "Curl URL: "           . $ci["url"]      . "<br/>";
            die($die);
        } else {

            // Check if the api call we made was valid

            $response = json_decode($response, true);

            // If our response is an array check if it's an error response
            if(is_array($response))
            {
                $error_key = "status";
                if(array_key_exists($error_key, $response))
                {
                    $er = $response[$error_key];
                    $die  = "API Error Message: " . $er["message"]     . "<br/>";
                    $die .= "API Error Code: "    . $er["status_code"] . "<br/>";
                    die($die);
                }
            }

            // Our response is a valid object
            $result = $response;
    }

    private function sanitize_url($url)
    {
        // removes all whitespaces
        return trim(preg_replace( '/\s+/','',$url));
    }

    private function regional_endpoints()
    {
        static $regionini;

        if(is_null($regionini))
            $regionini = parse_ini_file(INI_REGIONAL_ENDPOINTS, true);

        return $regionini;
    }

    private function region_host($shortcode)
    {
        /*
         * regionalendpoints.ini
         * @since 1.0
         *
         * [SHORTCODE]
         * Description=<region_description>
         * Host=<host_url>
         */
        return $this->regional_endpoints()[strtoupper($shortcode)]["Host"];
    }

    public  function region_description($shortcode)
    {
        /*
        * regionalendpoints.ini
        * @since 1.0
        *
        * [SHORTCODE]
        * Description=<region_description>
        * Host=<host_url>
        */
        return $this->regional_endpoints()[strtoupper($shortcode)]["Description"];
    }

    public function api_object_by_name($name, $region)
    {
        /*
         * @Description: Get summoner objects mapped by standardized summoner name for a given list of summoner names.
         *
         *
         * @Returns: Map[string, SummonerDto]
         *
         * Object
         * ------------------------------------------------------------------------------------------------------
         * Name             Data Type          Description
         * ------------------------------------------------------------------------------------------------------
         * id	            long	           ID.
         * name	            string	           Name.
         * profileIconId    int                    ID of the summoner icon associated with the summoner.
         * revisionDate	    long	           Date summoner was last modified specified as epoch milliseconds.
         * Level            long	           Level associated with the summoner.
         */

         $api_url = "%s/api/col/%s/v1.4/obj/by-name/%s";

        return $this->api_call(sprintf($api_url,
            $this->region_host($region),
            strtolower($region),
            $this->sanitize_url($name)));
    }

}

Class that acts as the middle man between the api and the front end. Currently how it is set up it handles an internal queue.

<?php

include dirname(__FILE__) . "\\class-riotapi.php";

define( "SUMMONER_NAME" , 0 );
define( "SUMMONER_ID"   , 1 );

class Summoner
{

    private $riotapi        = null;

    private $summoner       = null;
    private $arr_summoners  = null;
    private $region         = null;


    public function __construct()
    {
        // Create our riot api object
        $this->riotapi = new RiotAPI();
    }


    public function summoner_exists($summoners, $region, $type = SUMMONER_NAME)
    {
        static $eoa; // end of array

        // If our array of summoners is empty or we have reached the end of the array.
        if( empty($this->arr_summoners) || $eoa )
        {
            // Get an array of summoner information from the riot api based on the type of information
            // supplied.
            switch($type)
            {
                case SUMMONER_NAME :
                    $this->arr_summoners = $this->riotapi->api_summoner_by_name($summoners, $this->region = $region);
                    break;

                case SUMMONER_ID :
                    $this->arr_summoners = $this->riotapi->api_summoner_by_id($summoners, $this->region = $region);
                    break;
            }

            // If our array of summoners isn't empty.
            if( !empty($this->arr_summoners) )
            {
                // Set our current summoner the first element in the array.
                $this->summoner = reset($this->arr_summoners);
            } else {
                // We failed to acquire any summoner information so return false.
                return false;
            }

            $eoa = false;

        } else {

            // If we have not reached the end of the summoners array set our current
            // summoner to the next element.
            $next = next($this->arr_summoners);

            // Have we reached the end of the array?
            if( $next ) {
                // No. Set our current summoner to the next element.
                $this->summoner = $next;
            } else {
                // Yes. Set our end of array variable to true.
                $eoa = true;
                // End the loop
                return false;
            }

        }

        return true;
    }


    public function summoner_id()
    {
        return $this->summoner["id"];
    }


    public function summoner_name()
    {
        return $this->summoner["name"];
    }


    public function summoner_profile_icon_id()
    {
        return $this->summoner["profileIconId"];
    }


    public function summoner_last_updated()
    {
        return $this->summoner["revisionDate"];
    }


    public function summoner_level()
    {
        return $this->summoner["summonerLevel"];
    }


    public function summoner_mastery_pages()
    {
        return $this->riotapi->api_summoner_masteries($this->summoner_id(),
            $this->region)[$this->summoner_id()]["pages"];
    }

}

Functions.php file that is a collection of functions that echo out information. 

<?php

require_once "settings.php";
include DIR_INCLUDE . "class-summoner.php";

function summoner_exists($summoners, $region = "NA", $type = SUMMONER_NAME)
{
    global $cs;
    if(!isset($cs)){
        $cs = new Summoner();
    }
    return $cs->summoner_exists($summoners, $region, $type);
}

function summoner_name()
{
    global $cs;
    if(isset($cs)){
        echo $cs->summoner_name();
    }
}

?>

index.php - Example of how I'm currently using the functions.php file.

<?php include "functions.php"; ?>
<html xmlns="http://www.w3.org/1999/xhtml">
<body>

<?php while(summoner_exists("cyllo")) : ?>

    <div>Summoner Name: <?php summoner_name(); ?></div>
    <div>Summoner ID: <?php summoner_id(); ?></div>
    <div>Summoner Profile icon ID: <?php summoner_profile_icon_id(); ?></div>
    <div>Last Updated: <?php summoner_last_updated(); ?></div>
    <div>Summoner Level: <?php summoner_level(); ?></div>

    <div>
        <?php mastery_pages(); ?>
    </div>

<?php endwhile; ?>
</body>
</html>