MYSQLI Crud Example

CREATE DATABASE `database_name`;

 

// create table

CREATE TABLE `table_name`.`members` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`fname` varchar(255) NOT NULL,

`lname` varchar(255) NOT NULL,

`contact` varchar(255) NOT NULL,

`age` varchar(255) NOT NULL,

`active` int(11) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;










$localhost = "127.0.0.1";

$username = "root";

$password = "";

$dbname = "database_name";

 

// create connection

$connect = new mysqli($localhost, $username, $password, $dbname);

// check connection

if($connect->connect_error) {

    die("connection failed : " . $connect->connect_error);

} else {

    // echo "Successfully Connected";

}













$sql = "INSERT INTO members (fname, lname, contact, age, active) VALUES ('$fname', '$lname', '$contact', '$age', 1)"; if($connect->query($sql) === TRUE) { } else { } $connect->close();










$sql = "SELECT * FROM members WHERE active = 1"; $result = $connect->query($sql); if($result->num_rows > 0) { while($row = $result->fetch_assoc()) { } } else { }













$sql = "SELECT * FROM members WHERE id = {$id}"; $result = $connect->query($sql); $data = $result->fetch_assoc(); $connect->close();













$sql = "UPDATE members SET fname = '$fname', lname = '$lname', age = '$age', contact = '$contact' WHERE id = {$id}"; if($connect->query($sql) === TRUE) { } else { } $connect->close();