-
-
๐ Domain search now with sales history! ๐ฅณ
PHP post to MySQL
- Thread starter snike
- Start date
The views expressed on this page by users and staff are their own, not those of NamePros.
- Impact
- 26
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.
mysql_connect - to connect to MySQL server
mysql_select_db - to select required database
mysql_query - to runa query on MySQL server.
An example.
Database:
messages
Table:
messages
Example form + inserting data:
Displaying the data:
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:
<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());
if(isset($_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'])));
if(!empty($name) && !empty($email) && !empty($message))
{
$sql = mysql_query("INSERT INTO messages (id, name, email, message) VALUES('', '$name', '$email', '$message')");
if($sql)
{
//Entered successfully
}
else
{
die(mysql_error());
}
}
}
?>
</body>
</html>Displaying the data:
PHP:
<?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());
while($row = mysql_fetch_array($sql))
{
echo 'Name: '.stripslashes($row['name']).'<br /><br />
E-mail: '.stripslashes($row['email']).'<br /><br />
Message: <br />'.stripslashes(nl2br($row['message'])).'<hr>';
}
?>
Similar threads
New posts โ
-
The USA Political Thread- 436 posters
- Cannuck
Polls of interest โ
-
What are your strengths as an investor?- 178 voters
- 26 replies
-
What's your domain portfolio size?
- 435 voters
- 126 replies
-
How do you think a potential buyer first checks if your domain is for sale?- 432 voters
- 49 replies
Hot this week โ
-
How do you spot domain trends BEFORE they explode? (like claw keyword did)- 36 replies
- 1 point
-
GoDaddy Gave a Domain to a Stranger Without Any Documentation- 21 replies
- 40 points
-
For Sale Is Not the Same as Sellable- 17 comments
- 19 points
-
Sharing My Domain Research Process Feedback Welcome From Experienced Investors
- 20 replies
- 4 points
-
Rupees.com Sold for $110,000; Firma.ch for $19,021...- 12 replies
- 13 points
Hot this month โ
-
Looking for AI/Tech domains, up to $500 per domain.- 81 replies
- 74 posters
-
Looking for short pronouceable names
- 55 replies
- 1 point
-
Buying 1 word .co .io and .xyz domains- 46 replies
- 1 point
-
Why good domains still donโt sell (and itโs not pricing)- 47 replies
- 12 points
-
Most Domains Don't Sell Because...
- 40 comments
- 48 points
