08 PHP Server Connection and Create DataBase Program PHP- record

 

Create DataBase in XAMPP local Server MySql

start server

Open Chrome Browser  type- localhost/phpmyadmin/

 Note:- click IBM DataBase follow 1,2,3 &4 options

3.option Querys

CREATE TABLE `user` (
  `userid` INT(11) NOT NULL AUTO_INCREMENT,
  `firstname` VARCHAR(30) NOT NULL,
  `lastname` VARCHAR(30) NOT NULL,
  `E_mail` VARCHAR(30),
PRIMARY KEY (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

save--.PHP

 program:-01

 <?php
$host = 'localhost';
$dbname = 'ibm_database';
$username = 'root';
$password = '';

try
{
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo 'Connected to the IBM database successfully!';
} catch (PDOException $e)
{
    echo 'Error connecting to the database: ' . $e->getMessage();
}
?>

output:- 01