{"flag":true,"single":true,"pageTitle":"DATABASE MYSQL CONNECTION AND QUERIES with PHP using PDO","post":{"id":155,"user_id":"1","slug":"database-mysql-connection-and-queries-with-php-using-pdo-6pca","title":"DATABASE MYSQL CONNECTION AND QUERIES with PHP using PDO","body":"<pre class=\"language-markup\"><code>$servername = \"localhost\";\r\n$username = \"root\";\r\n$password = \"\";\r\n$db=\"mydatabase\";\r\n\r\ntry {\r\n    $conn = new PDO(\"mysql:host=$servername;dbname=$db\", $username, $password);\r\n    \/\/ set the PDO error mode to exception\r\n    $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\r\n    echo \"Connected successfully\"; \r\n}\r\ncatch(PDOException $e) {\r\n    echo \"Connection failed: \" . $e-&gt;getMessage();\r\n}\r\n\r\n################# queries  create,insert,update#################\r\n\r\n\/\/ create database\r\n$sql = \"CREATE DATABASE myDB\";\r\n$conn-&gt;exec($sql);\r\n\r\n\/\/ insert data\r\n$firstname = $_POST['firstname'];\r\n$sql = \"INSERT INTO MyGuests (firstname, lastname, email) VALUES (?, 'Doe', 'john@example.com')\";\r\n$stmt = $conn-&gt;prepare($sql);\r\n$stmt-&gt;execute([$firstname]);\r\n\r\n\/\/ update data\r\n$sql = \"UPDATE MyGuests SET lastname='Doe' WHERE id=2\";\r\n$conn-&gt;exec($sql);\r\n\r\n################# queries for selecting data#################\r\n$sql = \"SELECT * FROM transections WHERE merchent_order_id = :m_id LIMIT 1\";\r\n$stmt = $conn-&gt;prepare($sql);\r\n$stmt-&gt;bindParam(':m_id', '1');\r\n$stmt-&gt;execute();\r\n$results = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);\r\n\/\/OR\r\n$results = $stmt-&gt;fetch(PDO::FETCH_ASSOC);\r\n$conn = null;  \/\/ close the connection\r\n\r\n################# Delete #################\r\n$query = \"DELETE FROM $table WHERE id = :id\";\r\n$statement = $pdo-&gt;prepare($query);\r\n$statement-&gt;bindParam(':id', $id, PDO::PARAM_INT);\r\n<\/code><\/pre>","category_id":"23","is_private":"0","created_at":"2023-05-26T03:24:54.000000Z","updated_at":"2023-07-11T00:39:38.000000Z","category":{"id":23,"user_id":"1","name":"DATABASE","slug":"database-j4ss","parent_id":null,"created_at":"2023-05-26T03:25:05.000000Z","updated_at":"2023-05-26T03:25:05.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"$servername = \"localhost\"; $username = \"root\"; $password = \"\"; $db=\"mydatabase\";  try {     $conn = new PDO(\"mysql:host=$servername;dbname=$ - DATABASE MYSQL CONNECTION AND QUERIES with PHP using PDO (Updated: July 11, 2023) - Read more about DATABASE MYSQL CONNECTION AND QUERIES with PHP using PDO at my programming site [SITE]","categories":[]}