note 117385 deleted from mysqli.query by cmb
| From: | cmb@php.net | Date: | Mon, 01 Jun 2015 20:46:05 +0000 |
| Subject: | note 117385 deleted from mysqli.query by cmb | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-202719@lists.php.net to get a copy of this message | ||
Note Submitter: lamalord80089 at gmail dot com
----
<?php
//this will insert a user posted message into the database table messages
//retrieved from html-page
$name = $_POST["name"];
$email=$_POST["email"];
$title=$_POST["title"];
$message=$_POST["message"];
$mysqli = new mysqli("localhost", "login", "pass",
"dbname");
if ($mysqli->connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " .
$mysqli->connect_error;
}
//echo $mysqli->host_info . "\n";
$con=mysqli_connect("localhost", "dbname", "db-pass",
"dbname");
mysqli_query($con,"INSERT INTO messages(name,email,title,message) VALUES
('".$name."','".$email."','".$title."','".$message."')");
$result = mysqli_query($con, $query);
if ( false===$result ) {
printf("error: %s\n", mysqli_error($con));
}
else {
echo 'done.';
}
?>