RE: Create dynamic sites with PHP and MySQL

Codewalkers Forums Sponsor:

You eat, breathe and sleep innovation. Build your mobile intelligence with BlackBerry® experts this July. Register Today!

January 5th, 2007, 01:31 AM

drjake

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: Create dynamic sites with PHP and MySQL

Hey guys,

As you can see I'm new here, and very new to PHP and MySQL.

In this tutorial it talks about new versions of php may have difficulty with the code provided. Specifically the instructions on pages 8-10 of the Create Dynamic sites with PHP and MySQL tutorial, in the Putting it all together section. How would I complete that sections with newer php (without register_globals) or is it even possible?

Jake

January 5th, 2007, 01:43 AM

IAmALlama

Join Date: Apr 2007

Location: Seattle, WA

Posts: 963

Time spent in forums: 2 Days 7 h 9 m 43 sec
Reputation Power: 2

RE: RE: Create dynamic sites with PHP and MySQL

what register globals does is turns all the variables from user input like $_POST and $_GET into standard variables. for example on page 10, putting it all together, in the code they use if($submit){//whatever}. the proper way to call that is really if($_POST['submit']){//whatever}. if you use the $_POST part, then there is no problem.

January 5th, 2007, 02:49 AM

drjake

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: RE: Create dynamic sites with PHP and MySQL

Thanks, that worked. I appreciate it.

January 6th, 2007, 06:52 AM

drjake

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: RE: Create dynamic sites with PHP and MySQL

I ran into another problem in the same tutorial which I am unable to troubleshoot. Under the section, Editing data, I am running into trouble with the variable $PHP_SELF.
I using PHP 5.2, and Apache 2.2.3.

Here's the code (some changes that I made, due to the newer version of php. Some of them are guesses):

php Code:

Original - php Code

<HTML>
<?php
if($_GET['submit'])
{
	$db = mysql_connect("localhost", "root", "mypassword");
	mysql_select_db("learndb",$db);
	//for new PHP
	$first=$_GET[first];
	$last=$_GET[last];
	$nickname=$_GET[nickname];
	$email=$_GET[email];
	$salary=$_GET[salary];
	//
	$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary) VALUES ('$first','$last', '$nickname','$email', '$salary')";
	$result = mysql_query($sql);
	echo "Thank you! Information Entered.n";
}
else if($_GET['update'])
{
	$db = mysql_connect("localhost", "root", "mypassword");
	mysql_select_db("learndb",$db);
	//for new PHP
	$first=$_GET[first];
	$last=$_GET[last];
	$nickname=$_GET[nickname];
	$email=$_GET[email];
	$salary=$_GET[salary];
	//
	$id = $_GET['id'];
	$sql = "UPDATE personnel SET firstname='$first', lastname='$last', nick='$nickname', email='$email', salary='$salary' WHERE id=$id";
	$result = mysql_query($sql);
	echo "Thank you! Information updated.n";
}
else if($id)
{
	$db = mysql_connect("localhost", "root", "mypassword");
	mysql_select_db("learndb",$db);
	$result = mysql_query("SELECT * FROM personnel WHERE id=$id",$db);
	$myrow = mysql_fetch_array($result);
?>
<form method="get" action="<?php echo "$PHP_SELF"?>">
<input type="hidden" name="id" value="<?php echo $myrow["id"]?>">
First Name:<input type="Text" name="first" value="<?php echo $myrow["firstname"]?>"><br>
Last name:<input type="Text" name="last" value="<?php echo
$myrow["lastname"]?>"><br>
Nick Name:<input type="Text" name="nickname" value="<?php echo
$myrow["nick"]?>"><br>
E-mail:<input type="Text" name="email" value="<?php echo $myrow["email"]?>"><br>
Salary:<input type="Text" name="salary" value="<?php echo $myrow["salary"]?>"><br>
<input type="Submit" name="update" value="Update information"></form>
<?php
}
else
{
?>
<form method="get" action="<?php echo $PHP_SELF?>">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Nick Name:<input type="Text" name="nickname"><br>
E-mail:<input type="Text" name="email"><br>
Salary:<input type="Text" name="salary"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
</HTML>

 
<HTML>
<?php
if($_GET['submit'])
{
    $db = mysql_connect("localhost", "root", "mypassword");
    mysql_select_db("learndb",$db);
    //for new PHP
    $first=$_GET[first];
    $last=$_GET[last];
    $nickname=$_GET[nickname];
    $email=$_GET[email];
    $salary=$_GET[salary];
    //
    $sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary) VALUES ('$first','$last', '$nickname','$email', '$salary')";
    $result = mysql_query($sql);
    echo "Thank you! Information Entered.n";
}
else if($_GET['update'])
{
    $db = mysql_connect("localhost", "root", "mypassword");
    mysql_select_db("learndb",$db);
    //for new PHP
    $first=$_GET[first];
    $last=$_GET[last];
    $nickname=$_GET[nickname];
    $email=$_GET[email];
    $salary=$_GET[salary];
    //
    $id = $_GET['id'];
    $sql = "UPDATE personnel SET firstname='$first', lastname='$last', nick='$nickname', email='$email', salary='$salary' WHERE id=$id";
    $result = mysql_query($sql);
    echo "Thank you! Information updated.n";
}
else if($id)
{
    $db = mysql_connect("localhost", "root", "mypassword");
    mysql_select_db("learndb",$db);
    $result = mysql_query("SELECT * FROM personnel WHERE id=$id",$db);
    $myrow = mysql_fetch_array($result);
?>
<form method="get" action="<?php echo "$PHP_SELF"?>">
<input type="hidden" name="id" value="<?php echo $myrow["id"]?>">
First Name:<input type="Text" name="first" value="<?php echo $myrow["firstname"]?>"><br>
Last name:<input type="Text" name="last" value="<?php echo
$myrow["lastname"]?>"><br>
Nick Name:<input type="Text" name="nickname" value="<?php echo
$myrow["nick"]?>"><br>
E-mail:<input type="Text" name="email" value="<?php echo $myrow["email"]?>"><br>
Salary:<input type="Text" name="salary" value="<?php echo $myrow["salary"]?>"><br>
<input type="Submit" name="update" value="Update information"></form>
<?php
}
else
{
?>
<form method="get" action="<?php echo $PHP_SELF?>">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Nick Name:<input type="Text" name="nickname"><br>
E-mail:<input type="Text" name="email"><br>
Salary:<input type="Text" name="salary"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
</HTML>

This is following the tutorial referenced in the title of this thread.

January 6th, 2007, 09:45 AM

DimX

Join Date: Apr 2007

Posts: 26

Time spent in forums: 11 m 32 sec
Reputation Power: 0

RE: RE: Create dynamic sites with PHP and MySQL

Use $_SERVER['PHP_SELF'], also

php Code:

Original - php Code
$first=$_GET[first];

$first=$_GET[first];

is actually wrong (although it may work and throw an E_NOTICE). It must be

php Code:

Original - php Code
$first=$_GET['first'];

$first=$_GET['first'];

January 7th, 2007, 07:45 PM

drjake

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: RE: Create dynamic sites with PHP and MySQL

Thanks for pointing out those missing single quotes, and I don't understand why I need the $_SERVER['PHP_SELF'] could you elaborate on that?

I made those changes, but I get the following error:

php Code:

Original - php Code
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in (location) on line 41

 
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in (location) on line 41

What does T_ENCAPSED_AND_WHITESPACE mean?

January 7th, 2007, 08:39 PM

IAmALlama

Join Date: Apr 2007

Location: Seattle, WA

Posts: 963

Time spent in forums: 2 Days 7 h 9 m 43 sec
Reputation Power: 2

RE: RE: Create dynamic sites with PHP and MySQL

the variable is really $_SERVER['PHP_SELF']. the $PHP_SELF variable is the result of having register globals on, everything in the $_SERVER array is made into its own variable just like with $_POST, $_GET, $_REQUEST, $_COOKIE, $_SESSION, $_ENV, $_SERVER...those are all super-global arrays which means they are created by php and can be used anywhere without having to declare them as global. turning on register globals makes anything in those arrays be extract() from the array and turned into non array variables.

January 8th, 2007, 04:47 AM

drjake

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: RE: Create dynamic sites with PHP and MySQL

Thanks for the explanation it makes sense now. Any idea why this wouldn't work?

January 8th, 2007, 05:14 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: RE: Create dynamic sites with PHP and MySQL

I believe line 41 is this: <form method="get" action="<?php echo "$PHP_SELF"?>">

Could you post what you changed this to?

#10

January 8th, 2007, 05:20 AM

drjake

Join Date: Apr 2007

Posts: 10

Time spent in forums: < 1 sec
Reputation Power: 0

RE: RE: Create dynamic sites with PHP and MySQL

Certainly

php Code:

Original - php Code
<form method="get" action="<?php echo "$_SERVER['PHP_SELF']?>">

 
<form method="get" action="<?php echo "$_SERVER['PHP_SELF']?>">

#11

January 8th, 2007, 05:23 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: RE: Create dynamic sites with PHP and MySQL

To get the most help from PHP to find minor syntax errors, put the following line in after your first opening <?php tag -

error_reporting(E_ALL);

This will cause a number of Notice messages to be output. You should fix as many of these as possible in the name of syntacticly correct code. Each of these Notices are logged to the server log file and cause a minor speed penalty.

#12

January 8th, 2007, 05:28 AM