PHP MySQLi Procedural Cheat Sheet
by Ajay Kumar B via cheatography.com/30523/cs/9105/
mysqli_num_rows() Creating a Databasse (cont)
Return the number of rows in a result set } else {
Syntax: echo "Error creating database: " .
mysqli_num_rows(result); mysqli_error($conn);
Example: }
$rowcount=mysqli_num_rows($result); mysqli_close($conn);
mysqli_fetch_assoc() Selecting Data
Fetch a result row as an associative array. // Create connection
$conn = mysqli_connect($servername, $username,
Opening a connection to MySQL $password, $dbname);
// Check connection
Syntax:
if (!$conn) {
mysqli_connect(host,username,password,dbname,port,sock
die("Connection failed: " .
et);
mysqli_connect_error());
Returns an object representing the connection to the
}
MySQL server.
$sql = "SELECT id, firstname, lastname FROM
Example:
MyGuests";
$conn =
$result = mysqli_query($conn, $sql);
mysqli_connect("localhost","my_user","my_password","my
if (mysqli_num_rows($result) > 0) {
_db");
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
mysqli_error()
echo "id: " . $row["id"]. " - Name: " .
Return the last error description for the most recent
$row["firstname"]. " " . $row["lastname"]. "<br>";
function call, if any.
}
Syntax:
} else {
mysqli_error(connection);
echo "0 results";
Example;
}
echo("Error description: " . mysqli_error($conn));
mysqli_close($conn);
Creating a Databasse
Closing a connection of MySQL
// Create connection
Syntax:
$conn = mysqli_connect($servername, $username,
mysqli_close(connection);
$password);
Example:
// Check connection
mysqli_close($conn);
if (!$conn) {
die("Connection failed: " .
mysqli_connect_error());
}
// Create database
$sql = "CREATE DATABASE myDB";
if (mysqli_query($conn, $sql)) {
echo "Database created successfully";
By Ajay Kumar B Not published yet. Sponsored by Readability-Score.com
cheatography.com/ajay-kumar-b/ Last updated 14th September, 2016. Measure your website readability!
Page 1 of 2. https://readability-score.com
PHP MySQLi Procedural Cheat Sheet
by Ajay Kumar B via cheatography.com/30523/cs/9105/
mysqli_connect_error() mysqli_query()
Return an error description from the last connection Perform queries against the database.
error, if any. For successful SELECT, SHOW, DESCRIBE, or EXPLAIN
Syntax: queries it will return a mysqli_result object. For
mysqli_connect_error(); other successful queries it will return TRUE. FALSE on
Example: failure.
die("Connection error: " . mysqli_connect_error()); Syntax:
mysqli_query(connection,query,resultmode);
Create a Table Examples:
mysqli_query($con,"SELECT * FROM Persons");
// Create connection
mysqli_query($con,"INSERT INTO Persons
$conn = mysqli_connect($servername, $username,
(FirstName,LastName,Age) VALUES
$password, $dbname);
('Glenn','Quagmire',33)");
// Check connection
if (!$conn) {
Inserting into Table
die("Connection failed: " .
mysqli_connect_error()); // Create connection
} $conn = mysqli_connect($servername, $username,
// sql to create table $password, $dbname);
$sql = "CREATE TABLE MyGuests ( // Check connection
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, if (!$conn) {
firstname VARCHAR(30) NOT NULL, die("Connection failed: " .
lastname VARCHAR(30) NOT NULL, mysqli_connect_error());
email VARCHAR(50), }
reg_date TIMESTAMP $sql = "INSERT INTO MyGuests (firstname, lastname,
)"; email)
if (mysqli_query($conn, $sql)) { VALUES ('John', 'Doe', 'john@example.com')";
echo "Table MyGuests created successfully"; if (mysqli_query($conn, $sql)) {
} else { echo "New record created successfully";
echo "Error creating table: " . } else {
mysqli_error($conn); echo "Error: " . $sql . "<br>" .
} mysqli_error($conn);
mysqli_close($conn); }
mysqli_close($conn);
Selecting a Database
Syntax:
mysqli_select_db(connection,dbname);
Example:
mysqli_select_db($conn,"test");
By Ajay Kumar B Not published yet. Sponsored by Readability-Score.com
cheatography.com/ajay-kumar-b/ Last updated 14th September, 2016. Measure your website readability!
Page 2 of 2. https://readability-score.com
