<?php // This guide demonstrates the five fundamental steps // of database interaction using PHP. // Credentials $dbhost = ''; $dbuser = ''; $dbpass = ''; $dbname = ''; // 1. Create a database connection $connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname); // 2. Perform database query $result_set = mysqli_query($connection, $query) //example of a function for selecting all function select_all() { global $db; $sql = "SELECT * FROM subjects "; $sql .= "ORDER BY position ASC"; $result = mysqli_query($db, $sql); return $result; } // 3. Use returned data (if any) // 4. Release returned data // 5. Close database connection mysqli_close($connection); ?>
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter