PDO Connection MYSQLI // Create Connection with Pdo\ $dsn = "mysql:host=localhost; dbname=test;"; $db_user = "root"; $db_password = ""; try{ $conn = new PDO("$dsn", "$db_user","$db_password"); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); echo "Connected"; }catch(PDOException $a){ echo "Connection Failed". $a->getMessage(); }
<?php $server="localhost"; $user="root"; $pass="iq123"; $db="test"; $conn= mysqli_connect($server,$user,$pass,$db); if (!$conn){ echo "mysqli_error().'Database not connected'"; } ?> <?php include("conn.php"); $data=json_decode(file_get_contents("php://input")); $name=$data->name; $price=$data->price; $quantity=$data->quantity; $sql="Insert into product(name,price,quantity)values('$name','$price','$quantity')"; $query=mysqli_query($conn,$sql); ?> <!DOCTYPE> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>InsertData</title> <script src="js/angular.js" language="javascript" type="text/javascript"></script> <script src="js/angular.min.js" language="javascript" type="text