Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Open a new connection to the MySQL server
- $mysqli = new mysqli('localhost','createyo_james','password','createyo_TestDatabase');
- //Output any connection error
- if ($mysqli->connect_error) {
- die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
- }
- //values to be inserted in database table
- $NewsStory = $_POST["NewsStory"];
- $query = "INSERT INTO products (NewsStory) VALUES(?)";
- $statement = $mysqli->prepare($query);
- //bind parameters for markers, where (s = string, i = integer, d = double, b = blob)
- $statement->bind_param('s', $NewsStory);
- if($statement->execute()){
- print 'Success! ID of last inserted record is : ' .$statement->insert_id .'<br />';
- }else{
- die('Error : ('. $mysqli->errno .') '. $mysqli->error);
- }
- $statement->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment