UGN Security Forums
My ProfileMember DirectoryLogin
Search our ForumsView our FAQView our Site Rules
View our CalendarView our Active TopicsGo to our Main Page

 UGN Security Store
 

Network Sites UGN Security, The GoNix Initiative, Elite Web Gamers, Back of the Web, EveryDay Helper, VNC Web Design & Development
You are not logged in. [Log In] UGN Security Forums » Forums » UGN Security: Knowledge Base » Programming
      » Web Design, Protocols & Other Languages » PHP/MySQL calls?
Register User    Portal Page     Forum List        Calendar     Active Topics     FAQ
Our Sponsors
Sponsor Advertisements help keep UGN Security Online.



Sponsor Advertisements help keep UGN Security Online.

Want to earn prizes for clicking online advertisements? Join Rewards1.com.
Latest Postings
Latest Reviews
Topic Options
Rate This Topic
#18733 - 07/10/03 01:39 AM PHP/MySQL calls?
Gremelin Offline

Community Owner
*****

Registered: 02/28/02
Posts: 7192
Loc: 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:
Code:
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:


Code:
<?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 *
_________________________
Donate to UGN Security here.
UGN Security, Back of the Web, Elite Web Gamers & VNC Web Design Owner

Top
Our Sponsors
Sponsor Advertisements help keep UGN Security Online.



Sponsor Advertisements help keep UGN Security Online.
#18734 - 07/10/03 07:03 AM Re: PHP/MySQL calls?
ninjaneo Offline
UGN Security Staff

Registered: 03/06/02
Posts: 256
Loc: CA, USA
Well, theres a few things...
I have noticed I get a 500 error when Apache can't find my php.

Code:
$result = mysql_query("SELECT * FROM applications",$db);
could more properly be

Code:
$result = mysql_query("SELECT * FROM `applications`",$db);
And I have no fucking clue if this is valid PHP but it looks like you went C style. So here is how I would do it.

Code:
printf("Name %s
\n", mysql_result($result,0,"name"));
=

Code:
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"];
}

Top
#18735 - 07/10/03 07:04 AM Re: PHP/MySQL calls?
ninjaneo Offline
UGN Security Staff

Registered: 03/06/02
Posts: 256
Loc: CA, USA
oh yes. ph33r the spacing because of gay ubb

Top
#18736 - 08/02/03 04:35 AM Re: PHP/MySQL calls?
superpozition Offline
Junior Member

Registered: 07/31/03
Posts: 14
Loc: 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.

Code:
// 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!

Top
#18737 - 08/05/03 07:44 PM Re: PHP/MySQL calls?
§intå× Offline

UGN Elite
*****

Registered: 12/03/02
Posts: 3255
Loc: 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

Code:
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.


Code:
$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.

Code:
echo "Notes 
\n, ".$result2['notes'].";
                  ^
              Those commas
notice how I called the while loop

Code:
while($result2 = mysql_fetch_array($result)){
it takes the data from

Code:
$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

Code:
$array_name['colum_name']
Hope this helps
_________________________
My New site OpenEyes

Top
#18738 - 08/24/03 09:14 AM Re: PHP/MySQL calls?
Gremelin Offline

Community Owner
*****

Registered: 02/28/02
Posts: 7192
Loc: Portland, OR; USA
Learner, now I'm getting:
Quote:
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:
Code:
<?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'].";
		}
?>
_________________________
Donate to UGN Security here.
UGN Security, Back of the Web, Elite Web Gamers & VNC Web Design Owner

Top
#18739 - 08/24/03 09:16 AM Re: PHP/MySQL calls?
Gremelin Offline

Community Owner
*****

Registered: 02/28/02
Posts: 7192
Loc: Portland, OR; USA
Note that line 9 would be:
Code:
echo "Nick 
\n ".$result2['nick'].";
_________________________
Donate to UGN Security here.
UGN Security, Back of the Web, Elite Web Gamers & VNC Web Design Owner

Top
#18740 - 08/24/03 09:37 AM Re: PHP/MySQL calls?
SephiroX Offline
Member

Registered: 03/02/02
Posts: 122
Loc: England
you have one too many quotes on each line it looks like...

Top
#18741 - 08/25/03 12:27 PM Re: PHP/MySQL calls?
superpozition Offline
Junior Member

Registered: 07/31/03
Posts: 14
Loc: 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!

Top
#18742 - 08/25/03 03:32 PM Re: PHP/MySQL calls?
Brett Offline
Aptenodytes Forsteri

Registered: 08/25/03
Posts: 9
Loc: 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)
Code:
<?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);
?>

Top
#18743 - 08/25/03 05:36 PM Re: PHP/MySQL calls?
Gremelin Offline

Community Owner
*****

Registered: 02/28/02
Posts: 7192
Loc: Portland, OR; USA
mmmm, works...
_________________________
Donate to UGN Security here.
UGN Security, Back of the Web, Elite Web Gamers & VNC Web Design Owner

Top
#18744 - 10/03/03 11:41 AM Re: PHP/MySQL calls?
Learner2 Offline
Junior Member

Registered: 10/03/03
Posts: 7
Sorry for leaving you hanging. how is it going?

Top
#18745 - 10/03/03 11:54 AM Re: PHP/MySQL calls?
Gremelin Offline

Community Owner
*****

Registered: 02/28/02
Posts: 7192
Loc: Portland, OR; USA
gave up for a bit lol, i'd have to find my documentation wherever I left it lol... Been busy with other things... god I need to hire some PHP/MySQL guys here
_________________________
Donate to UGN Security here.
UGN Security, Back of the Web, Elite Web Gamers & VNC Web Design Owner

Top
#18746 - 10/04/03 11:57 PM Re: PHP/MySQL calls?
Learner2 Offline
Junior Member

Registered: 10/03/03
Posts: 7
What you paying? :*

Top



Moderator:  Â§intå×, Gremelin 
Featured Member
Registered: 03/02/02
Posts: 134
Forum Stats
2198 Members
46 Forums
24894 Topics
60064 Posts

Max Online: 1567 @ 04/25/10 10:20 AM
Top Posters
UGN Security 18055
Gremelin 7192
§intå× 3255
SilentRage 1273
Ice 1146
pergesu 1136
Infinite 1041
jonconley 955
Girlie 908
unreal 860
Newest Members
Selex, baird, colin, mwilliams1586, kuriousity
2198 Registered Users
Who's Online
0 registered (), 311 Guests and 233 Spiders online.
Key: Admin, Global Mod, Mod
Latest News
Privacy statement · Board Rules · Mark all read
Contact Us · UGN Security · Top


Donate
   Get Firefox!
Get FireFox!