Month: July 2021

Connection Close in Php mysql

When the script ends then automatically connection will be closed. To close the connection before, use the following: MySQLi Object-Oriented: $conn->close(); MySQLi Procedural: mysqli_close($conn); PDO: $conn =...
READ MORE   >>

PHP connect to DB

Example (MySQLi procedural) mysqli_connect function is used for connection string which has 3 parameters and mysqli_connect_error function is used to display particular MySQL error. <?php$servername = "localhost";$username =...
READ MORE   >>

PHP connect to DB

PHP work with a MySQL database using MySQLi (procedural), MySQLi (object-oriented) and PDO (PHP Data Objects) Difference between MySQLi and PDO PDO will work on 12 different database systems, whereas MySQLi will only work with MySQL...
READ MORE   >>

MySQL data type

Data type specifies the particular type of data used with their possible value and the way of that values to be stored. Different datatype with their size and value are listed below: Data Type Maximum SizeExplanationCHAR(size)Maximum size of 255...
READ MORE   >>

Recent Comments

    • Copyright © 2020 (Er. Shairy Kalra). All Rights Reserved