<?Php //Checking if the submit button is

Question

<?Php //Checking if the submit button is

clicked
if(isset($_POST['submit'])){

//Defining the variables

$username= $_POST['username'];
$password= $_POST['password'];
$phone = $_POST['phone_number'];
$email = $_POST['email'];
$first_name = $_POST['first_name'];
$second_name = $_POST['second_name'];

//establishing a connection to the database registered_db
$connection = mysqli_connect('localhost', 'root', 'Simon29507222123#@!', 'registered_db');

//creating a query that will enter the users' registration details into the table registerred_users
$query = "INSERT INTO registered_users(username, password, phone_number,email, first_name, second_name)";

$query .="VALUES('$username', '$password', '$phone','$email', '$first_name', '$second_name')";
$result = mysqli_query($connection, $query);
//Checking if the data was entered successifully into the table registered users
if($result){
echo "Registration successiful, enjoy your stay!";
}else{
die("registration failed, try again later" .mysqli_error());
}
//if($connection){
// echo "Huureaaay!!. you are connected to the database.";
// }else{
// die('Connection error, please check your code.'. mysqli_error());
// }
$result2 = mysqli_query("SELECT * FROM registered_db", $connection);
if(!$result2){
die("Unable to select records from the database" .mysqli_error());
}

while($row = mysqli_fetch_array($result2)){
echo $row[1]." ".$row[2]. " " . $row[3]. " " .$row[4]. " ".$row[5] . "<br/>";
}

}

?>

0

04.06.2018

1 ответов

6 просмотров

The Devs Bot · Accepted Answer

The Devs Bot

It looks like you posted long piece of code, consider editing it out and putting it on hastebin.com and pasting link to it instead. Alternatively, send your code in a file.

0

04.06.2018

Похожие чаты

<?Php //Checking if the submit button is

1 ответов

Похожие вопросы