#18733 - 07/10/03 12:39 AM
PHP/MySQL calls?
|
Joined: Feb 2002
Posts: 7,198
Gremelin
Community Owner
|
Community Owner
Joined: Feb 2002
Posts: 7,198
Likes: 11
Portland, OR; USA
|
Ok, I'm playing with MySQL (I don't know it for my life), I believe I have this down right (it's my first time doin this so feel free to tear it apart) but it won't work, anyone have any ideas? DB: CREATE TABLE applications (
name varchar(20),
nick varchar(20),
telephone varchar(50),
cellular varchar(50),
date varchar(20),
chance varchar(4),
complete varchar(4),
address varchar(50),
citystzip varchar(75),
age varchar(4),
email varchar(75),
aim varchar(20),
irc varchar(20),
ubb varchar(20),
username varchar(20),
password varchar(20),
sections varchar(100),
yob varchar(4),
admin varchar(4),
staff varchar(4),
wantadmin varchar(4),
wantmod varchar(4),
wantnews varchar(4),
wasadmin varchar(4),
wasmod varchar(4),
wasnews varchar(4),
notes varchar(255),
id int(4) NOT NULL auto_increment,
PRIMARY KEY (id),
UNIQUE id (id)
)TYPE=MyISAM;PHP Page: <?php
$db = mysql_connect("localhost", "[user]", "[pass]");
mysql_select_db("undergroundc",$db);
$result = mysql_query("SELECT * FROM applications",$db);
printf("Name %s
\n", mysql_result($result,0,"name"));
printf("Nick %s
\n", mysql_result($result,0,"nick"));
printf("Telephone %s
\n", mysql_result($result,0,"telephone"));
printf("Cellular %s
\n", mysql_result($result,0,"cellular"));
printf("Date %s
\n", mysql_result($result,0,"date"));
printf("Chance %s
\n", mysql_result($result,0,"chance"));
printf("Complete %s
\n", mysql_result($result,0,"complete"));
printf("Address %s
\n", mysql_result($result,0,"address"));
printf("City, ST, Zip %s
\n", mysql_result($result,0,"citystzip"));
printf("Age %s
\n", mysql_result($result,0,"age"));
printf("E-Mail %s
\n", mysql_result($result,0,"email"));
printf("AIM %s
\n", mysql_result($result,0,"aim"));
printf("IRC %s
\n", mysql_result($result,0,"irc"));
printf("UBB %s
\n", mysql_result($result,0,"ubb"));
printf("Username %s
\n", mysql_result($result,0,"username"));
printf("Password %s
\n", mysql_result($result,0,"password"));
printf("Sections %s
\n", mysql_result($result,0,"sections"));
printf("Birth Year %s
\n", mysql_result($result,0,"yob"));
printf("Admin %s
\n", mysql_result($result,0,"admin"));
printf("Staff %s
\n", mysql_result($result,0,"staff"));
printf("Wants Admin %s
\n", mysql_result($result,0,"wantadmin"));
printf("Wants Mod %s
\n", mysql_result($result,0,"wantmod"));
printf("Wants News %s
\n", mysql_result($result,0,"wantnews"));
printf("Was Admin %s
\n", mysql_result($result,0,"wasadmin"));
printf("Was Mod %s
\n", mysql_result($result,0,"wasmod"));
printf("Was News %s
\n", mysql_result($result,0,"wasnews"));
printf("Notes %s
\n", mysql_result($result,0,"notes"));
?>I just want it to load the data in the db so that i can play around, but it keeps 500 erroring on me  ... FYI, yes, this is for the application system, eventually anyway lol... *sorry Having to scroll was bugging me. §in_tax *
|
|
|
|
#18734 - 07/10/03 06:03 AM
Re: PHP/MySQL calls?
|
Joined: Mar 2002
Posts: 256
ninjaneo
UGN Security Staff
|
UGN Security Staff
Joined: Mar 2002
Posts: 256
Likes: 1
CA, USA
|
Well, theres a few things... I have noticed I get a 500 error when Apache can't find my php. $result = mysql_query("SELECT * FROM applications",$db);could more properly be $result = mysql_query("SELECT * FROM `applications`",$db);And I have no [censored] clue if this is valid PHP but it looks like you went C style. So here is how I would do it. printf("Name %s
\n", mysql_result($result,0,"name"));= echo("Name " . mysql_result($result,0,"name") . "
\n",);But even then that doesn't look like it would work but I am unaware of a mysql_result function so I don't know.. heres the final way it would look for me. [code] foreach($r as mysql_fetch_array($result)) { echo "all your stuff: " . $r["name"]; }
|
|
|
|
#18736 - 08/02/03 03:35 AM
Re: PHP/MySQL calls?
|
Joined: Jul 2003
Posts: 14
superpozition
Junior Member
|
Junior Member
Joined: Jul 2003
Posts: 14
Canada
|
Here is how i would retreive rows from a mysql database using php. I like OO programming so i will retreive the rows as objects. // db parameters
define ('MYSQL_HOST', 'localhost');
define ('MYSQL_USER','db_username');
define ('MYSQL_PASS','db_password');
define ('MYSQL_DB','db_name');
mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_PASS); // connect to mysql server
mysql_select_db(MYSQL_DB); // select database
$query = "select * from table_name";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_object($result))
{
// loop through all the rows returned int he $row object assuming you know the column names
echo "Name : ".$row->name;
echo "
Username : ".$row->username;
echo "Password : ".$row->password;
echo "Email : ".$row->email;
// ......... more ..........
}This is how i would do it. Hope this helped you out a little.
Keep It Real!
|
|
|
|
#18737 - 08/05/03 06:44 PM
Re: PHP/MySQL calls?
|
Joined: Dec 2002
Posts: 3,255
§intå×
|
Joined: Dec 2002
Posts: 3,255
Likes: 3
Maryland
|
Gizzy... I think this is what you want. I am not familar with %s and and \n are the same thing. But here is what I came up with CREATE TABLE applications (
name varchar(20),
nick varchar(20),
telephone varchar(50),
cellular varchar(50),
date varchar(20),
chance varchar(4),
complete varchar(4),
address varchar(50),
citystzip varchar(75),
age varchar(4),
email varchar(75),
aim varchar(20),
irc varchar(20),
ubb varchar(20),
username varchar(20),
psswd varchar(20),
sections varchar(100),
yob varchar(4),
admin varchar(4),
staff varchar(4),
wantadmin varchar(4),
wantmod varchar(4),
wantnews varchar(4),
wasadmin varchar(4),
wasmod varchar(4),
wasnews varchar(4),
notes varchar(255),
id int(4) NOT NULL auto_increment,
PRIMARY KEY (id),
UNIQUE id (id)
)TYPE=MyISAM; notice I re-named your password field. I ran into issues with the word "password" in my code. I think it is reserved for HTML or PHP or some crap like that. Trust me, re-name it now saves big head aches later. $db = mysql_connect("localhost", "[user]", "[pass]");
mysql_select_db("undergroundc",$db);
$result = mysql_query("SELECT * FROM applications");
//
//
/*all you needed to do was pull the results out
in a loop. It took all data from the table and
put it in an array.*/
//
//
while($result2 = mysql_fetch_array($result)){
echo "Name
\n, ".$result2['name'].";
echo "Nick
\n, ".$result2['nick'].";
echo "Telephone
\n, ".$result2['telephone'].";
echo "Cellular
\n, ".$result2['cellular'].";
echo "Date
\n, ".$result2['date'].";
echo "Chance
\n, ".$result2['chance'].";
echo "Complete
\n, ".$result2['complete'].";
echo "Address
\n, ".$result2['address'].";
echo "City, ST, Zip
\n, ".$result2['citystzip'].";
echo "Age
\n, ".$result2['age'].";
echo "E-Mail
\n, ".$result2['email'].";
echo "AIM
\n, ".$result2['aim'].";
echo "IRC
\n, ".$result2['irc'].";
echo "UBB
\n, ".$result2['ubb'].";
echo "Username
\n, ".$result2['username'].";
echo "Password
\n, ".$result2['password'].";
echo "Sections
\n, ".$result2['sections'].";
echo "Birth Year
\n, ".$result2['yob'].";
echo "Admin
\n, ".$result2['admin'].";
echo "Staff
\n, ".$result2['staff'].";
echo "Wants Admin
\n, ".$result2['wantadmin'].";
echo "Wants Mod
\n, ".$result2['wantmod'].";
echo "Wants News
\n, ".$result2['wantnews'].";
echo "Was Admin
\n, ".$result2['wasadmin'].";
echo "Was Mod
\n, ".$result2['wasmod'].";
echo "Was News
\n, ".$result2['wasnews'].";
echo "Notes
\n, ".$result2['notes'].";
}
?>if this dosen't work take the commas out. echo "Notes
\n, ".$result2['notes'].";
^
Those commasnotice how I called the while loop while($result2 = mysql_fetch_array($result)){it takes the data from $result = mysql_query("SELECT * FROM applications");and throws it into an array called $result2 The While loop is going through the table line by line(by that I mean row by row). So we call our variable like so $array_name['colum_name'] Hope this helps
|
|
|
|
#18738 - 08/24/03 08:14 AM
Re: PHP/MySQL calls?
|
Joined: Feb 2002
Posts: 7,198
Gremelin
Community Owner
|
Community Owner
Joined: Feb 2002
Posts: 7,198
Likes: 11
Portland, OR; USA
|
Learner, now I'm getting: Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in c:\program files\easyphp\www\test.php on line 9 The code i'm using is: <?php
$db = mysql_connect("localhost", "[user]", "[pass]");
mysql_select_db("applications",$db);
$result = mysql_query("SELECT * FROM applications");
while($result2 = mysql_fetch_array($result)){
echo "Name
\n ".$result2['name'].";
echo "Nick
\n ".$result2['nick'].";
echo "Telephone
\n ".$result2['telephone'].";
echo "Cellular
\n ".$result2['cellular'].";
echo "Date
\n ".$result2['date'].";
echo "Chance
\n ".$result2['chance'].";
echo "Complete
\n ".$result2['complete'].";
echo "Address
\n ".$result2['address'].";
echo "City, ST, Zip
\n ".$result2['citystzip'].";
echo "Age
\n ".$result2['age'].";
echo "E-Mail
\n ".$result2['email'].";
echo "AIM
\n ".$result2['aim'].";
echo "IRC
\n ".$result2['irc'].";
echo "UBB
\n ".$result2['ubb'].";
echo "Username
\n ".$result2['username'].";
echo "Password
\n ".$result2['password'].";
echo "Sections
\n ".$result2['sections'].";
echo "Birth Year
\n ".$result2['yob'].";
echo "Admin
\n ".$result2['admin'].";
echo "Staff
\n ".$result2['staff'].";
echo "Wants Admin
\n ".$result2['wantadmin'].";
echo "Wants Mod
\n ".$result2['wantmod'].";
echo "Wants News
\n ".$result2['wantnews'].";
echo "Was Admin
\n ".$result2['wasadmin'].";
echo "Was Mod
\n ".$result2['wasmod'].";
echo "Was News
\n ".$result2['wasnews'].";
echo "Notes
\n ".$result2['notes'].";
}
?>
|
|
|
|
#18741 - 08/25/03 11:27 AM
Re: PHP/MySQL calls?
|
Joined: Jul 2003
Posts: 14
superpozition
Junior Member
|
Junior Member
Joined: Jul 2003
Posts: 14
Canada
|
Gizmo,
Instead of ending all your echo lines with
.";
end them with just
;
And why are you using
and \n ?
If my fist suggestion doesn't work erase the \n from all your echo lines
Keep It Real!
|
|
|
|
#18742 - 08/25/03 02:32 PM
Re: PHP/MySQL calls?
|
Joined: Aug 2003
Posts: 9
Brett
Aptenodytes Forsteri
|
Aptenodytes Forsteri
Joined: Aug 2003
Posts: 9
Salina, KS
|
Along with the suggestions, to return an assoc array, mysql_fetch_array does not do this. It returns a 1 dimensional array, not a hash. This either needs to be changed to mysql_fetch_array($result, MYSQL_ASSOC) or use the mysql_fetch_assoc() function. Doesn't matter really. (Small millisecond diff) <?php
$db = mysql_connect("localhost", "[user]", "[pass]");
mysql_select_db("applications",$db);
$result = mysql_query("SELECT * FROM `applications`");
while($result2 = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "Name
\n ".$result2['name'];
echo "Nick
\n ".$result2['nick'];
echo "Telephone
\n ".$result2['telephone'];
echo "Cellular
\n ".$result2['cellular'];
echo "Date
\n ".$result2['date'];
echo "Chance
\n ".$result2['chance'];
echo "Complete
\n ".$result2['complete'];
echo "Address
\n ".$result2['address'];
echo "City, ST, Zip
\n ".$result2['citystzip'];
echo "Age
\n ".$result2['age'];
echo "E-Mail
\n ".$result2['email'];
echo "AIM
\n ".$result2['aim'];
echo "IRC
\n ".$result2['irc'];
echo "UBB
\n ".$result2['ubb'];
echo "Username
\n ".$result2['username'];
echo "Password
\n ".$result2['password'];
echo "Sections
\n ".$result2['sections'];
echo "Birth Year
\n ".$result2['yob'];
echo "Admin
\n ".$result2['admin'];
echo "Staff
\n ".$result2['staff'];
echo "Wants Admin
\n ".$result2['wantadmin'];
echo "Wants Mod
\n ".$result2['wantmod'];
echo "Wants News
\n ".$result2['wantnews'];
echo "Was Admin
\n ".$result2['wasadmin'];
echo "Was Mod
\n ".$result2['wasmod'];
echo "Was News
\n ".$result2['wasnews'];
echo "Notes
\n ".$result2['notes'];
}
mysql_free_result($result);
mysql_close($db);
?>
|
|
|
|
#18743 - 08/25/03 04:36 PM
Re: PHP/MySQL calls?
|
Joined: Feb 2002
Posts: 7,198
Gremelin
Community Owner
|
Community Owner
Joined: Feb 2002
Posts: 7,198
Likes: 11
Portland, OR; USA
|
|
|
|
|
#18746 - 10/04/03 10:57 PM
Re: PHP/MySQL calls?
|
Joined: Oct 2003
Posts: 7
Learner2
Junior Member
|
Junior Member
Joined: Oct 2003
Posts: 7
|
|
|
|
|
|
Forums45
Topics34,109
Posts69,256
Members2,167
Average Daily Posts3
| |
Members2,167
Most Online1,567
Apr 25th, 2010
|
|
|
