PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
Moderator: General Moderators
calvinmicklefinger
Forum Newbie
Posts: 10 Joined: Thu May 03, 2007 2:50 pm
Post
by calvinmicklefinger » Sat May 05, 2007 11:07 am
Hello,
I am practicing with the following code. It crashes when I insert the SELECT statement. I am thinking I am not connecting to the database, but am not sure. Can someone please advise?
Many thanks.
Kirk
**********************
Code: Select all
<?php
$usr = $_SERVER['PHP_AUTH_USER'];
$link = mysql_connect('mysql_host', 'mysql_dbusername', 'mysql_dbpassword');
$fields = mysql_list_fields("my_database", "my_table", $link);
$columns = mysql_num_fields($fields);
for ($i = 0; $i < $columns; $i++) {
$var1 = mysql_field_name($fields, $i);
// Page crashes when I introduce this line
$var2 = SELECT $var1 FROM my_table WHERE my_fieldname = "'" . $usr . "'";
echo "<input type='hidden' name=" . "'" . $var1 . "'" . " value=" . "'" . $var2 . "'" . "><br />" . "/n";
}
?>
John Cartwright
Site Admin
Posts: 11470 Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:
Post
by John Cartwright » Sat May 05, 2007 11:11 am
Code: Select all
$var2 = SELECT $var1 FROM my_table WHERE my_fieldname = "'" . $usr . "'";
should be
Code: Select all
$var2 = "SELECT $var1 FROM my_table WHERE my_fieldname = '$usr'";
Might want to brush up on
strings
calvinmicklefinger
Forum Newbie
Posts: 10 Joined: Thu May 03, 2007 2:50 pm
Post
by calvinmicklefinger » Sat May 05, 2007 12:04 pm
Thanks Jcart,
I am actually trying to perform the query and have the result assigned to $var2
The page no longer crashes, but $var2 is receiving the query as a string rather than the results of the query.
Code: Select all
$var2 = "SELECT $var1 FROM my_table WHERE my_fieldname = '$usr'";
echo "<input type='hidden' name=" . "'" . $var1 . "'" . " value=" . "'" . $var2 . "'" . "><br />" . "/n";yields something like ...
Code: Select all
<input type='hidden' name='my_fieldname1' value='SELECT my_fieldname1 FROM my_table WHERE my_fieldname2 = 'auth_user_name''>where I am actually expecting ...
Code: Select all
<input type='hidden' name='my_fieldname1' value='my_filedname1_value'>
What else am I missing?
Kirk
Weirdan
Moderator
Posts: 5978 Joined: Mon Nov 03, 2003 6:13 pm
Location: Odessa, Ukraine
Post
by Weirdan » Sat May 05, 2007 4:29 pm