{"flag":true,"single":true,"pageTitle":"MYSQL all queries and connection using php mysqli approach","post":{"id":160,"user_id":"1","slug":"mysql-all-queries-and-connection-using-php-mysqli-approach-yoaz","title":"MYSQL all queries and connection using php mysqli approach","body":"<pre class=\"language-markup\"><code>$servername = \"localhost\";\r\n$username = \"username\";\r\n$password = \"password\";\r\n$db=\"mydatabase\";\r\n$conn = mysqli_connect($servername, $username, $password);\/\/ Create connection\r\nif (!$conn) {\r\n    die(\"Connection failed: \" . mysqli_connect_error());\r\n}\r\necho \"Connected successfully\";\r\n################# queries #################\r\n$sql = \"CREATE DATABASE myDB\"; \/\/create databsase\r\n$sql = \"INSERT INTO MyGuests (firstname, lastname, email)\r\nVALUES ('John', 'Doe', 'john@example.com')\"; \/\/insert data\r\n$sql = \"UPDATE MyGuests SET lastname='Doe' WHERE id=2\"; \/\/\r\nif (mysqli_query($conn, $sql)) {\r\n    echo \"successfully EXECUTED\";\r\n} else {\r\n    echo \"Error: \" . mysqli_error($conn);\r\n}\r\n################# queries #################\r\n$sql = \"SELECT id, firstname, lastname FROM MyGuests\";\r\n$result = mysqli_query($conn, $sql);\r\nif (mysqli_num_rows($result) &gt; 0) {\r\n    \/\/ output data of each row\r\n    while($row = mysqli_fetch_assoc($result)) {\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\nmysqli_close($conn); \/\/release resources<\/code><\/pre>","category_id":"23","is_private":"0","created_at":"2023-06-13T05:10:24.000000Z","updated_at":"2023-06-13T05:10:24.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 = \"username\"; $password = \"password\"; $db=\"mydatabase\"; $conn = mysqli_connect($servername, $username,  - MYSQL all queries and connection using php mysqli approach (Updated: June 13, 2023) - Read more about MYSQL all queries and connection using php mysqli approach at my programming site [SITE]","categories":[]}