if statement - Codewalkers

Codewalkers Forums Sponsor:

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

August 4th, 2004, 05:42 PM

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

if statement

I tried to use this and get these errors --
Notice: Undefined variable: submit in c:inetpubwwwrootaddedit.php on line 3

Notice: Undefined variable: update in c:inetpubwwwrootaddedit.php on line 12

this is what I am typing in - actually I am copying it from your tutorials
http://codewalkers.com/tutorials/9/14.html

why do I have this issue with if statements and else statements and else if?

Is there a problem with the script?
Is there a setting I dont have setup on my php.ini file correctly?
I am new to this whole thing and would like some info on what I am doing wrong.
BTW
On this tutorial page http://codewalkers.com/tutorials/9/12.html there is more errors of script that needs to be fixed.
On the script you have :
$result = mysql_ query("SELECT * FROM personnel",$db);

Should be
$result = mysql_query("SELECT * FROM personnel",$db);

I mean I know you all may be pros at this and spot it quickly but some of us like me - who has never used PHP before and is learning this took me like 2 hours to figure out that there was a typo on your part. Is this else and if statements typos????

August 4th, 2004, 07:51 PM

Ashkhan

Contributing User

Join Date: Apr 2007

Posts: 372

Time spent in forums: 1 h 24 m 57 sec
Reputation Power: 2

RE: if statement

There is nothing wrong with the code. Author only assumes you have register_globals=on in your php.ini:

Quote:

If you don't have the register_globals=on option enabled, be sure to initialize the variables with $_GET like $first=$_GET[first];

That's why you variables are not defined. Newbie can easily skip this little notice. That option was set to off by default in versions above 4.1 or so.

In other words, instead of $variable use $_GET['variable'].

Or you can add following loop at the beginning of your script. The loop will neccessary assingments for you.

php Code:

Original - php Code
foreach($_GET as $key => $value) { $$key = $value; }

 
foreach($_GET as $key => $value) { $$key = $value; }

August 4th, 2004, 07:55 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

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

RE: if statement

Ok, how do you initialize the variables with $_GET like $first=$_GET[first];

register_globals is set to on , I had changed this way earlier. I dont know how to initialize variables. Do I put this into a php webpage? help

August 4th, 2004, 08:01 PM

Ashkhan

Contributing User

Join Date: Apr 2007

Posts: 372

Time spent in forums: 1 h 24 m 57 sec
Reputation Power: 2

RE: if statement

It should work if you set the register_globals to on.

By initialization he means simply this assignment:

$submit = $_GET['submit'];

August 4th, 2004, 08:07 PM

Ashkhan

Contributing User

Join Date: Apr 2007

Posts: 372

Time spent in forums: 1 h 24 m 57 sec
Reputation Power: 2

RE: if statement

To test it, create a new file.

Then copy this text:

<?php
if (isset($_GET['name'])) { echo "used GET".$_GET['name']; }
else { echo "without GET $name"; }
?>

Save it as test.php.

In your browser call it like this: http://yourserver/test.php?name=Joe

See which method works.

August 4th, 2004, 08:26 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

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

RE: if statement

I did it and it came up with "used GETJoe" on a webpage without the quotes.

If its all working then why am I getting this error then when I run a php with an if statement in there or else statement? This is strange. Im running a php VB bullentin BB on the server too and am writing this to you from the server and the bb runs great and I know there is if statements all within it. But I was doing the tutorial and I get errors when I run the page that has if statements and else statements. The tutorial is helpful but I cant run that one page.

http://codewalkers.com/tutorials/9/14.html

here is the code thats on the page

<HTML>
<?php
if($submit)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$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($update)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$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", "");
mysql_select_db("learndb",$db);
$result = mysql_query("SELECT * FROM personnel WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
?>
<form method="post"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>
<?
}
else
{
?>
<form method="post" 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>
<?
}
?>
</HTML>

August 5th, 2004, 11:44 AM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

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

RE: if statement

any ideas??

August 5th, 2004, 08:02 PM

Ashkhan

Contributing User

Join Date: Apr 2007

Posts: 372

Time spent in forums: 1 h 24 m 57 sec
Reputation Power: 2

RE: if statement

I made a few changes.

php Code:

Original - php Code

<HTML>
<?php
foreach($_POST as $key => $value) { $$key = $value; }
$update = $_GET['update'];
$id = $_GET['id'];

if($submit)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
VALUES ('$first','$last','$nickname','$email','$salary')";
$result = mysql_query($sql);
echo $sql;
echo "<p>Thank you! Information entered.</p>n";
echo "Do you want to <a href='$PHP_SELF?id=y'> UPDATE</a> your info?<br />";
}
else if($update)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "UPDATE personnel SET firstname='$first',
lastname='$last', nick='$nickname', email='$email', salary='$salary' WHERE id=$id";
$result = mysql_query($sql);
echo $sql;
echo "Thank you! Information updated.n";
}
else if($id)
{
$myrow["firstname"] = "nuff";
$db = mysql_connect("localhost", "root", "");
mysql_select_db("learndb",$db);
$result = mysql_query("SELECT * FROM personnel WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
?>
Update
<form method="post"action="<?php echo $PHP_SELF?>?update=y">
<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>
<?
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
First name:<input type="Text" name="first" value="nuff"><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>
<?
}
?>
</HTML>

 
<HTML>
<?php
foreach($_POST as $key => $value) { $$key = $value; }
$update = $_GET['update'];
$id = $_GET['id'];
 
if($submit)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary)
VALUES ('$first','$last','$nickname','$email','$salary')";
$result = mysql_query($sql);
echo $sql;
echo "<p>Thank you! Information entered.</p>n";
echo "Do you want to <a href='$PHP_SELF?id=y'> UPDATE</a> your info?<br />";
}
else if($update)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("learndb",$db);
$sql = "UPDATE personnel SET firstname='$first',
lastname='$last', nick='$nickname', email='$email', salary='$salary' WHERE id=$id";
$result = mysql_query($sql);
echo $sql;
echo "Thank you! Information updated.n";
}
else if($id)
{
$myrow["firstname"] = "nuff";
$db = mysql_connect("localhost", "root", "");
mysql_select_db("learndb",$db);
$result = mysql_query("SELECT * FROM personnel WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
?>
Update
<form method="post"action="<?php echo $PHP_SELF?>?update=y">
<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>
<?
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
First name:<input type="Text" name="first" value="nuff"><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>
<?
}
?>
</HTML>

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: