Skip to main content

Posts

Showing posts with the label database

Transferring data from a web form to a database

STEP 1: HTML FORM <body> <h2>Data Form</h2> <form action="info.php" method="post" > //Data entered is redirected to 'info.php' page Name:<input type="text" name="name" size="60" /> <br /> <br /> E-mail:<input type="text" name="email" size="60" /> <br /> <br /> <input type="submit" name="submit" value="Submit" /> </form> </body> STEP 2: PHP <body> <?php  //Connecting to a database $servername="localhost"; $username="root"; $password=""; $dbname="info"; $connect=mysqli_connect("$servername","$username","$password","$dbname"); if (mysqli_connect_error()) { die("Database connection failed: ". mysqli_connect_error()); } else  { echo "Created connection successful...
Post a Comment
Read more

Creating a new table in the mySQL database

SOURCE CODE: <?php $servername="localhost"; $username="root"; $password=""; $dbname="newDB; //Create a connection($connect) $connect=new mysqli("$servername"," $username "," $password "," $dbname "); //Check the connection new_tbl="CREATE TABLE info( //columns name VARCHAR(30) NOT NULL, email VARCHAR(30)NOT NULL ); $connect->close; ?>
Post a Comment
Read more

Creating a database using mySQL

SOURCE CODE: <?php $servername="localhost"; $username="root"; $password=""; //Create a connection($connect) //Check the connection $new_db="CREATE DATABASE newDB"; if($connect->query($new_db)==TRUE){    echo "Database created successfully"; } else{    echo "Error: ".$conn->error; } $conn->close(); ?>
Post a Comment
Read more

Opening a mySQL database connection

SOURCE CODE: <?php $servername="localhost"; $username="root"; $password=""; //Create a connection     $connect=mysqli_connect("$servername","$username","$password"); //Check the connection if (mysqli_connect_error()){    die("Database connection failed:ERROR: ".mysqli_connect_error(); } else{   echo "Database connected successfully!"; ?>
Post a Comment
Read more