{"flag":true,"single":true,"pageTitle":"MYSQL all queries and connection using php oop approach","post":{"id":159,"user_id":"1","slug":"mysql-all-queries-and-connection-using-php-oop-approach-hyjb","title":"MYSQL all queries and connection using php oop approach","body":"<pre class=\"language-markup\"><code>$servername = \"localhost\";\r\n$username = \"root\";\r\n$password = \"\";\r\n$db=\"mydatabase\";\r\n$conn = new mysqli($servername, $username, $password,$db);\/\/ Create connection\r\nif ($conn-&gt;connect_error) { \/\/ Check connection\r\n    die(\"Connection failed: \" . $conn-&gt;connect_error);\r\n}\r\necho \"Connected successfully\";\r\n################# queries  create,insert,update#################\r\n$sql = \"CREATE DATABASE myDB\"; \/\/create databsase\r\n\r\n$firstname = $mysqli -&gt; real_escape_string($_POST['firstname']);\r\n$sql = \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ($firstname , 'Doe', 'john@example.com')\"; \/\/insert data\r\n\r\n$sql = \"UPDATE MyGuests SET lastname='Doe' WHERE id=2\"; \/\/\r\nif ($conn-&gt;query($sql) === TRUE) {\r\n    echo \"New record created successfully\";\r\n} else {\r\n    echo \"Error: \" . $sql . \"&lt;br&gt;\" . $conn-&gt;error;\r\n}\r\n################# queries for selecting data#################\r\n$sql = \"SELECT id, firstname, lastname FROM MyGuests\";\r\n$result = $conn-&gt;query($sql);\r\nif ($result-&gt;num_rows &gt; 0) {\r\n    while($row = $result-&gt;fetch_assoc()) {\r\n        echo \"id: \" . $row[\"id\"]. \" - Name: \" . $row[\"firstname\"]. \" \" . $row[\"lastname\"]. \"&lt;br&gt;\";\r\n    }\r\n} else {\r\n    echo \"0 results\";\r\n}\r\n$conn-&gt;close(); \/\/release resources<\/code><\/pre>","category_id":"23","is_private":"0","created_at":"2023-06-13T03:36:41.000000Z","updated_at":"2023-06-13T03:36:41.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\"; $conn = new mysqli($servername, $username, $password,$db);\/ - MYSQL all queries and connection using php oop approach (Updated: June 13, 2023) - Read more about MYSQL all queries and connection using php oop approach at my programming site [SITE]","categories":[]}