Member Avatar for derick_3 
<?php
$pdo = new PDO('mysql:host=localhost;port=3306;dbname=crud', 'root', '');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$title = $_POST=['title'];
$description = $_POST = ['description'];
$price = $_POST = ['price'];
$date = date('Y-m-d H:i:s');
$products = $statement = $pdo->prepare("INSERT  INTO products (title, image, description, price, Create_date)
VALUES (:title, :image, :description, :price, :date)");
$statement->bindValue(':title', $title);
$statement->bindValue(':image', '');
$statement->bindValue(':description', $description);
$statement->bindValue(':price', $price);
$statement->bindValue(':date', $date);
$statement->execute();

?>
Edited by Dani because: Formatting fixed
  • 2 Contributors
  • 1 Reply
  • 37 Views
  • 20 Minutes Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Dani

Hi,

You had posted your code just as plain text, so I converted it to a code snippet. However, I'm confused by the reason for your post. Do you have a question about your code? The topic title is inserting into a MySQL database with PHP, and that looks just like what you're attempting to do here. Are you intending to just post example code?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.