PHP PDO CRUD

\n\n\n\n\nPDO Database Connection:\n\n\n\n<pre class=\"wp-block-code\"><code><?php\ntry {\n $pdo = new PDO(\"mysql:host=localhost;dbname=your_database_name\", \"your_username\", \"your_password\");\n $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n $pdo->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);\n} catch (PDOException $e) {\n die(\"Connection failed: \" . $e->getMessage());\n}\n?></code></pre>\n\n\n\nCRUD Operations with PDO:\n\n\n\nCreate (INSERT):\n\n\n\n<pre class=\"wp-block-code\"><code>try {\n $sql = \"INSERT INTO your_table (column1, column2, column3) VALUES (:value1, :value2, :value3)\";\n $stmt = $pdo->prepare($sql);\n $stmt->bindParam(':value1', $value1);\n $stmt->bindParam(':value2', $value2);\n $stmt->bindParam(':value3', $value3);\n\n $value1 = \"Some Value\";\n $value2 = \"Another Value\";\n $value3 = 123;\n\n $stmt->execute();\n echo \"Record inserted successfully.\";\n} catch (PDOException $e) {\n echo \"Error: \" . $e->getMessage();\n}</code></pre>\n\n\n\nRead (SELECT) WIthout Loop:\n\n\n\n<pre class=\"wp-block-code\"><code> try {\n $sql = \"SELECT * FROM users WHERE user_email = :email AND user_password = :password\";\n $stmt = $pdo->prepare($sql);\n$stmt->bindParam(':email', $l_email);\n $stmt->bindParam(':password', $encrypted_password);\n $stmt->execute();\n\n $row = $stmt->fetch(PDO::FETCH_ASSOC);\n\n if ($row) {\n $user_id = $row['id'];\n\n if ($user_id != '') {\n $message = 'Logged in Successfully';\n } else {\n $message = 'Invalid email or password';\n }\n } else {\n $message = 'Invalid email or password';\n }\n \n echo $message;\n } catch (PDOException $e) {\n echo \"Error: \" . $e->getMessage();\n }</code></pre>\n\n\n\nUpdate (UPDATE):\n\n\n\n<pre class=\"wp-block-code\"><code>try {\n $sql = \"UPDATE your_table SET column1 = :value1, column2 = :value2 WHERE id = :id\";\n $stmt = $pdo->prepare($sql);\n $stmt->bindParam(':value1', $value1);\n $stmt->bindParam(':value2', $value2);\n $stmt->bindParam(':id', $id);\n\n $value1 = \"Updated Value\";\n $value2 = \"New Value\";\n $id = 1; // Example record ID\n\n $stmt->execute();\n echo \"Record updated successfully.\";\n} catch (PDOException $e) {\n echo \"Error: \" . $e->getMessage();\n}</code></pre>\n\n\n\nDelete (DELETE):\n\n\n\n<pre class=\"wp-block-code\"><code>try {\n $sql = \"DELETE FROM your_table WHERE id = :id\";\n $stmt = $pdo->prepare($sql);\n $stmt->bindParam(':id', $id);\n\n $id = 1; // Example record ID to delete\n\n $stmt->execute();\n echo \"Record deleted successfully.\";\n} catch (PDOException $e) {\n echo \"Error: \" . $e->getMessage();\n}</code></pre>\n\n\n\n\n\n\n\nRead (Select) With Loop\n\n\n\n<pre class=\"wp-block-code\"><code>try {\n $sql = \"SELECT * FROM users WHERE user_email = '$l_email' AND user_password = '$encrypted_password'\";\n $stmt = $pdo->query($sql);\n $stmt->execute();\n\n while ($row = $stmt->fetch()) {\n // Process the retrieved data\n $value = $row['id'];\n \n echo \"$new_value\";\n }\n } catch (PDOException $e) {\n echo \"Error: \" . $e->getMessage();\n }\n}</code></pre>\n\n\n\nExplanation:\n\n\n\n<ol>\n<li>The PDO database connection code establishes a connection to your MySQL database, and it sets the error mode and fetch mode to provide useful error messages and fetch data as associative arrays.</li>\n\n\n\n<li>The CRUD examples demonstrate how to perform basic database operations with PDO: Create (INSERT), Read (SELECT), Update (UPDATE), and Delete (DELETE).</li>\n\n\n\n<li>Prepared statements are used to prevent SQL injection by binding values to placeholders.</li>\n</ol>\n\n\n\nMake sure to replace placeholders like <code>your_database_name</code>, <code>your_username</code>, <code>your_password</code>, and <code>your_table</code> with your actual database details and table name. Also, modify the column names and values accordingly for your specific use case.\n