Results from the most recent live auction are here .
20 members in the live chat room. Join Chat !
· #1 NamePros Regular
Location: USA
Join Date: Mar 2006
PHP post to MySQL
How do I make PHP echo the data in a MySQL database? How does PHP post into MySQL?
· #2 DNOA Member
Join Date: Jan 2006
Posts: 1,069
NP$: 181.75 (
Donate )
You have to use more functions from here
http://www.php.net/mysql
mysql_connect - to connect to MySQL server
mysql_select_db - to select required database
mysql_query - to runa query on MySQL server.
· #3 while ($awake){ code(); }
Name: Eric
Location: Kentucky
Join Date: Mar 2005
Posts: 4,268
NP$: 1152.00 (
Donate )
An example.
Database:
messages
Table:
messages
Code:
CREATE TABLE `messages` (
`id` INT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`email` VARCHAR(255) NOT NULL,
`message` LONGTEXT NOT NULL,
PRIMARY KEY (`id`)
) Type = MyISAM;
Example form + inserting data:
PHP Code:
< html >
head >
title > Example </ title >
head >
body >
form method = "post" action = "<?php echo $_SERVER['PHP_SELF']; ?>" >
Your Name :< br />
input type = "text" name = "name" >< br />< br />
Your E - mail :< br />
input type = "text" name = "email" >< br />< br />
Your Message :< br />
textarea rows = "5" cols = "40" name = "message" ></ textarea >< br />< br />
input type = "submit" name = "submit" value = "Submit" >
form >
php
//Connect to mysql
$db = mysql_connect ( 'localhost' , 'dbusername' , 'dbpassword' ) or die( "Couldn't connect:<br />" . mysql_error ());
mysql_select_db ( 'messages' , $db ) or die( "Couldn't select database:<br />" . mysql_error ());
$_POST [ 'submit' ]))
$name = trim ( strip_tags ( mysql_real_escape_string ( $_POST [ 'name' ])));
$email = trim ( strip_tags ( mysql_real_escape_string ( $_POST [ 'email' ])));
$messages = trim ( strip_tags ( mysql_real_escape_string ( $_POST [ 'message' ])));
$name ) && !empty( $email ) && !empty( $message ))
$sql = mysql_query ( "INSERT INTO messages (id, name, email, message) VALUES('', '$name', '$email', '$message')" );
$sql )
//Entered successfully
}
mysql_error ());
?>
</body>
Displaying the data:
PHP Code:
<?php
//Connect
$db = mysql_connect ( 'localhost' , 'dbusername' , 'dbpassword' ) or die( "Couldn't connect:<br />" . mysql_error ());
mysql_select_db ( 'messages' , $db ) or die( "Couldn't select database:<br />" . mysql_error ());
$sql = mysql_query ( "SELECT * FROM messages" ) or die( mysql_error ());
$row = mysql_fetch_array ( $sql ))
'Name: ' . stripslashes ( $row [ 'name' ]). '<br /><br />
. stripslashes ( $row [ 'email' ]). '<br /><br />
. stripslashes ( nl2br ( $row [ 'message' ])). '<hr>' ;
?>
· #4 Steven
Name: Steven Gibbons
Location: United Kindom
Join Date: Aug 2005
Posts: 1,506
NP$: 40.00 (
Donate )
Sv, you always beat me to it, although im not on np 24/7
· #5 Name: Rhett
Location: Coffs H, Australia
Join Date: Jul 2005
Posts: 3,106
NP$: 47.00 (
Donate )
Originally Posted by webmonkey Sv, you always beat me to it, although im not on np 24/7
I'm pretty sure SV is some sort of AI robot, first of its kind
.
__________________
· #6 while ($awake){ code(); }
Name: Eric
Location: Kentucky
Join Date: Mar 2005
Posts: 4,268
NP$: 1152.00 (
Donate )
· #7 Name: Rhett
Location: Coffs H, Australia
Join Date: Jul 2005
Posts: 3,106
NP$: 47.00 (
Donate )
Originally Posted by SecondVersion
lol, I knew it, it's speechless, its been found out
__________________
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
