The text below is selected, press Ctrl+C to copy to your clipboard. (⌘+C on Mac) No line numbers will be copied.
Guest
Ta
By Guest on 18th March 2024 08:23:39 AM | Syntax: PYTHON | Views: 81


New Paste New paste | Download Paste Download | Toggle Line Numbers Show/Hide line no. | Copy Paste Copy text to clipboard
  1. <?php
  2.             $dbhost='localhost';  
  3.             $dbuser='root';
  4.             $dbpass='user@123';
  5.             $dbname='AMERICA';
  6.            
  7.            
  8.             $conn=mysqli_connect($dbhost,$dbuser,$dbpass,$dbname);
  9.             if($conn->connect_error)
  10.             {
  11.                     die("connection failed:".$conn->connect_error);
  12.             }
  13.             else
  14.             {
  15.                     echo"connected successfully";
  16.             }
  17.     echo"<br>";
  18.    
  19.  
  20.         $sql="CREATE TABLE BOOK(title VARCHAR(20) NOT NULL,author VARCHAR(20), edition INT,  no_of_copy INT)";
  21.                     if(mysqli_query($conn,$sql))
  22.                     {
  23.                             echo "Table Created Successfully";
  24.                     }
  25.                     else
  26.                     {
  27.                             echo "Error Creating table:",mysqli_error($conn);
  28.                     }
  29.      $mysqli_close($conn);
  30.     ?>