Thank you so much for your…
Thank you so much for your tutorial it's really a big hwlp for me
-- -------------------------------------------------------- -- -- Table structure for table `tbl_registration` -- CREATE TABLE `tbl_registration` ( `tbl_registration_id` INT(11) NOT NULL, `first_name` VARCHAR(100) NOT NULL, `middle_name` VARCHAR(100) NOT NULL, `last_name` VARCHAR(100) NOT NULL, `email` VARCHAR(100) NOT NULL, `contact_number` VARCHAR(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "add_query_pdo"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { } // sql to create table $sql = "CREATE TABLE `tbl_registration` ( `tbl_registration_id` int(11) NOT NULL, `first_name` varchar(100) NOT NULL, `middle_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `contact_number` varchar(100) NOT NULL )"; if ($conn->query($sql) === TRUE) { echo "Your Table tbl_registration Successfully Created!!!"; } else { echo "Error creating table. Check the Syntax." . $conn->error; } $conn->close(); ?>
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "add_query_pdo"; // Create connection // Check connection if (!$conn) { } // sql to create table $sql = "CREATE TABLE `tbl_registration` ( `tbl_registration_id` int(11) NOT NULL, `first_name` varchar(100) NOT NULL, `middle_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `contact_number` varchar(100) NOT NULL )"; echo "Your Table tbl_registration Successfully Created!!!"; } else { } ?>
<?php $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "add_query_pdo"; try { $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); // set the PDO error mode to exception $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // sql to create table $sql = "CREATE TABLE `tbl_registration` ( `tbl_registration_id` int(11) NOT NULL, `first_name` varchar(100) NOT NULL, `middle_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `email` varchar(100) NOT NULL, `contact_number` varchar(100) NOT NULL )"; // use exec() because no results are returned echo "Your Table tbl_registration Successfully Created!!!"; } catch(PDOException $e) { echo $sql . "<br>" . $e->getMessage(); } $conn = null; ?>