Composer Installer:
Project Structure:
<?php require 'vendor/autoload.php'; ?>
<!DOCTYPE html>
<html>
<head>
<title>Database Apps</title>
</head>
<body>
<?php
$database = new medoo([
'database_type' => 'mysql',
'database_name' => 'db_utility',
'server' => 'localhost',
'username' => 'root',
'password' => '',
'charset' => 'utf8'
]);
$database->insert('mi_installer', [
'username' => 'rampukar',
'userpass' => 'developer',
]);
?>
</body>
</html>
SQL
CREATE TABLE `mi_installer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(50) DEFAULT NULL,
`userpass` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
Demo:
0 comments:
Post a Comment