{"id":263,"date":"2024-03-11T15:05:49","date_gmt":"2024-03-11T15:05:49","guid":{"rendered":"https:\/\/www.xopsschool.com\/tutorials\/?p=263"},"modified":"2024-03-11T15:06:54","modified_gmt":"2024-03-11T15:06:54","slug":"php-and-databases","status":"publish","type":"post","link":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/","title":{"rendered":"PHP and Databases"},"content":{"rendered":"\n<p>PHP is a server-side scripting language commonly used for web development, and it often interacts with databases to store and retrieve data. The most popular type of database used with PHP is MySQL, but PHP can also work with other databases like PostgreSQL, SQLite, and more.<br><br><\/p>\n\n\n\n<p><strong>What is database in PHP?<\/strong><br>MySQL is an open-source relational database management system (RDBMS). It is the most popular database system used with PHP. MySQL is developed, distributed, and supported by Oracle Corporation. The data in a MySQL database are stored in tables which consists of columns and rows.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"621\" height=\"368\" src=\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg\" alt=\"\" class=\"wp-image-264\" srcset=\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg 621w, https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro-300x178.jpg 300w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/figure>\n\n\n\n<p><strong>Database Connection:<\/strong><\/p>\n\n\n\n<p>Use the mysqli or PDO extension to connect to a database.<\/p>\n\n\n\n<p>Example using mysqli:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$servername = \"localhost\";\r\n$username = \"root\";\r\n$password = \"\";\r\n$database = \"mydatabase\";\r\n\r\n\/\/ Create connection\r\n$conn = new mysqli($servername, $username, $password, $database);\r\n\r\n\/\/ Check connection\r\nif ($conn->connect_error) {\r\n    die(\"Connection failed: \" . $conn->connect_error);\r\n}\r\n<\/code><\/pre>\n\n\n\n<p><strong>Executing SQL Queries<\/strong><\/p>\n\n\n\n<p>Use the mysqli_query function to execute SQL queries.<br><strong>Example : <\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$sql = \"SELECT * FROM users\";\r\n$result = mysqli_query($conn, $sql);\n\r<strong>\nFetching Data:<\/strong>\nUse functions like mysqli_fetch_assoc, mysqli_fetch_array, or mysqli_fetch_object to retrieve data from query results.\r\n\r\nExample:  \n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>while ($row = mysqli_fetch_assoc($result)) {\r\n    echo \"Name: \" . $row&#91;\"name\"] . \"&lt;br>\";\r\n}\r<\/code><\/pre>\n\n\n\n<p><strong>Inserting Data:<\/strong><\/p>\n\n\n\n<p>Use the INSERT INTO SQL statement to add data to a database.<\/p>\n\n\n\n<p>Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$sql = \"INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com')\";\r\nmysqli_query($conn, $sql);\r<\/code><\/pre>\n\n\n\n<p><strong>Updating Data:<\/strong><\/p>\n\n\n\n<p>Use the UPDATE SQL statement to modify existing data.<br>Example:<\/p>\n\n\n\n<p><strong>Deleting Data:<\/strong><\/p>\n\n\n\n<p>Use the DELETE FROM SQL statement to remove data from a database.<\/p>\n\n\n\n<p>Example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$sql = \"DELETE FROM users WHERE id=1\";\r\nmysqli_query($conn, $sql);\r\n<\/code><\/pre>\n\n\n\n<p><strong>Prepared Statements:<\/strong><\/p>\n\n\n\n<p>Use prepared statements to prevent SQL injection.<br>Example with mysqli:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$stmt = $conn->prepare(\"INSERT INTO users (name, email) VALUES (?, ?)\");\r\n$stmt->bind_param(\"ss\", $name, $email);\r\n\r\n$name = \"John Doe\";\r\n$email = \"john@example.com\";\r\n\r\n$stmt->execute();\r\n<\/code><\/pre>\n\n\n\n<p><strong>Closing Connection:<\/strong><\/p>\n\n\n\n<p>Always close the database connection when done to free up resources.<\/p>\n\n\n\n<p>Example:<\/p>\n\n\n\n<p>mysqli_close($conn);<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PHP is a server-side scripting language commonly used for web development, and it often interacts with databases to store and retrieve data. The most popular type of database used with PHP is MySQL, but PHP can also work with other databases like PostgreSQL, SQLite, and more. What is database in PHP?MySQL is an open-source relational &#8230; <a title=\"PHP and Databases\" class=\"read-more\" href=\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\" aria-label=\"Read more about PHP and Databases\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-263","post","type-post","status-publish","format-standard","hentry","category-php-databases"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>PHP and Databases - XOps Tutorials!!!<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PHP and Databases - XOps Tutorials!!!\" \/>\n<meta property=\"og:description\" content=\"PHP is a server-side scripting language commonly used for web development, and it often interacts with databases to store and retrieve data. The most popular type of database used with PHP is MySQL, but PHP can also work with other databases like PostgreSQL, SQLite, and more. What is database in PHP?MySQL is an open-source relational ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"XOps Tutorials!!!\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-11T15:05:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-11T15:06:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg\" \/>\n<meta name=\"author\" content=\"ritik hansda\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"ritik hansda\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\"},\"author\":{\"name\":\"ritik hansda\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/c0119ddd2d27ea9cd476e809c8294ba7\"},\"headline\":\"PHP and Databases\",\"datePublished\":\"2024-03-11T15:05:49+00:00\",\"dateModified\":\"2024-03-11T15:06:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\"},\"wordCount\":198,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg\",\"articleSection\":[\"PHP Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\",\"url\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\",\"name\":\"PHP and Databases - XOps Tutorials!!!\",\"isPartOf\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg\",\"datePublished\":\"2024-03-11T15:05:49+00:00\",\"dateModified\":\"2024-03-11T15:06:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/c0119ddd2d27ea9cd476e809c8294ba7\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage\",\"url\":\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg\",\"contentUrl\":\"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg\",\"width\":621,\"height\":368},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.xopsschool.com\/tutorials\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PHP and Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/#website\",\"url\":\"https:\/\/www.xopsschool.com\/tutorials\/\",\"name\":\"XOps Tutorials!!!\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.xopsschool.com\/tutorials\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/c0119ddd2d27ea9cd476e809c8294ba7\",\"name\":\"ritik hansda\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6fe0bc437410899c524975272622377e50e726108b1ad03f7b4488f734304fce?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6fe0bc437410899c524975272622377e50e726108b1ad03f7b4488f734304fce?s=96&d=mm&r=g\",\"caption\":\"ritik hansda\"},\"url\":\"https:\/\/www.xopsschool.com\/tutorials\/author\/ritikhansda\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PHP and Databases - XOps Tutorials!!!","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/","og_locale":"en_US","og_type":"article","og_title":"PHP and Databases - XOps Tutorials!!!","og_description":"PHP is a server-side scripting language commonly used for web development, and it often interacts with databases to store and retrieve data. The most popular type of database used with PHP is MySQL, but PHP can also work with other databases like PostgreSQL, SQLite, and more. What is database in PHP?MySQL is an open-source relational ... Read more","og_url":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/","og_site_name":"XOps Tutorials!!!","article_published_time":"2024-03-11T15:05:49+00:00","article_modified_time":"2024-03-11T15:06:54+00:00","og_image":[{"url":"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg","type":"","width":"","height":""}],"author":"ritik hansda","twitter_card":"summary_large_image","twitter_misc":{"Written by":"ritik hansda","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#article","isPartOf":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/"},"author":{"name":"ritik hansda","@id":"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/c0119ddd2d27ea9cd476e809c8294ba7"},"headline":"PHP and Databases","datePublished":"2024-03-11T15:05:49+00:00","dateModified":"2024-03-11T15:06:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/"},"wordCount":198,"commentCount":0,"image":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg","articleSection":["PHP Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/","url":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/","name":"PHP and Databases - XOps Tutorials!!!","isPartOf":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage"},"image":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg","datePublished":"2024-03-11T15:05:49+00:00","dateModified":"2024-03-11T15:06:54+00:00","author":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/c0119ddd2d27ea9cd476e809c8294ba7"},"breadcrumb":{"@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#primaryimage","url":"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg","contentUrl":"https:\/\/www.xopsschool.com\/tutorials\/wp-content\/uploads\/2024\/03\/php-intro.jpg","width":621,"height":368},{"@type":"BreadcrumbList","@id":"https:\/\/www.xopsschool.com\/tutorials\/php-and-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.xopsschool.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"PHP and Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.xopsschool.com\/tutorials\/#website","url":"https:\/\/www.xopsschool.com\/tutorials\/","name":"XOps Tutorials!!!","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.xopsschool.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/c0119ddd2d27ea9cd476e809c8294ba7","name":"ritik hansda","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.xopsschool.com\/tutorials\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6fe0bc437410899c524975272622377e50e726108b1ad03f7b4488f734304fce?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fe0bc437410899c524975272622377e50e726108b1ad03f7b4488f734304fce?s=96&d=mm&r=g","caption":"ritik hansda"},"url":"https:\/\/www.xopsschool.com\/tutorials\/author\/ritikhansda\/"}]}},"_links":{"self":[{"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/comments?post=263"}],"version-history":[{"count":1,"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/263\/revisions"}],"predecessor-version":[{"id":265,"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/posts\/263\/revisions\/265"}],"wp:attachment":[{"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/media?parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/categories?post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xopsschool.com\/tutorials\/wp-json\/wp\/v2\/tags?post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}