PHP向mysql中插入資料的方法

標籤：

 1 require "database.php"; 2  3 $po_code = "YMWF2015-6-25-1"; 4 $customer = "youmei"; 5 $confirm_date = "2015-6-25"; 6 $delivery_date = "2015-7-25"; 7  8 $create_order_sql =  "INSERT INTO `ld_crm`.`order` (`id`, `po_code`, `customer`, `confirm_date`, `delivery_date`) VALUES (NULL, ‘$po_code‘, ‘$customer‘, ‘$confirm_date‘, ‘$delivery_date‘)";
//注意此處前面的`ld_crm`中並不是單引號而是esc下面那個按鍵的符號。後面的VALUES中的變數不能用雙引號代替單引號，單引號前面不能有\逸出字元

 9 10 11 if ($db_conn->query($create_order_sql) === TRUE) { 12 echo "New record created successfully"; 13 } else { 14 echo "Error: " . $create_order_sql . "<br>" . $db_conn->error; 15 }

 

PHP向mysql中插入資料的方法