PHP : I need to make a table in database that holds three fields. A unique key, a name, and an email. then I have to...

Question

Question

PHP : I need to make a table in database that holds three fields. A unique key, a name, and an email. then I have to...

PHP :

I need to make a table in database that holds three fields. A unique key, a name, and an email.

then I have to make two PHP files. One of those files has a form with two fields that allow the user to enter their name and email. This file then enters that data into the database table and acknowledges the entry.

The second PHP file does a query on that database and prints out a table with two columns: One with the names and one with the emails.

Use PDO, not mysql functions.

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

//Create database
CREATE DATABASE 'Info';

//Create table
CREATE TABLE 'ContactInfo' (
'id' int(11) NOT NULL AUTO_INCREMENT,
'name' varchar(255) NOT NULL,
'email' varchar(255) NOT NULL
PRIMARY KEY ('id'))

//Create Index.php page

<html>
<head>
<title>Add data in DB via PDO(php data object)</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body>

<label>Name :</label>
<input type="text" name="stu_name" id="name" required="required" placeholder="Please Enter Name"/><br /><br />
<label>Email :</label>
<input type="email" name="stu_email" id="email" required="required" /><br/><br />

</div>
<?php

//Attempt server connection with default settings
if(isset($_POST["submit"]))

{
$hostname='localhost';
$username='root';
$password='';

try {

//conects to the database
$dbh = new PDO("mysql:host=$hostname;dbname=Info",$username,$password);

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// adds info to the database
$sql = "INSERT INTO ContactInfo (name, email)
VALUES ('".$_POST["name"]."','".$_POST["email"]."')";
if ($dbh->query($sql)) {
echo "<script type= 'text/javascript'>alert('New Record has been Inserted Successfully');</script>";
}
else{
echo "<script type= 'text/javascript'>alert('Data not Inserted.');</script>";
}

$dbh = null;
}
catch(PDOException $e)
{
echo $e->getMessage();
}

}
?>
</body>
</html>

This is how we can access DB using php data object PDO.

Add a comment

Answer 2

PHP : I need to make a table in database that holds three fields. A unique key, a name, and an email. then I have to...

Homework Answers

Add Answer to:
PHP : I need to make a table in database that holds three fields. A unique key, a name, and an email. then I have to...

Post as a guest

Earn Coins