What am I missing in my PHP code?

See more:

PHP

MySQL

XAMPP

Hi I am a beginner in PHP and MySQl, I am making a website that can view a database, add data to database and delete data from a database. I have written code for a form page which allows the user to add data to the database.

The code doesn't contain any errors, the form appears, you can enter the details and click the submit button with no issues. But it does not actually add the information entered to the database.

Here is the code for my "New.php"

<title>New Record

	

	
		
	<?php
     if(isset($_POST["ID"])){
	
    $ID = $_POST['ID'];
	$ProductName = $_POST['ProductName'];
	$Price = $_POST['Price'];
	$Stock = $_POST['Stock'];
	 }
	
	// if there are any errors, display them
    $error='';
	if ($error != '');
	 
	{

	echo '<div style="padding: 4px; color: red">'.$error.'</div>';
//if assist
	}

	?>

	

	<div>
	   
	ID:  <br>

	ProductName:  <br>

	Price:   <br>
	
	Stock:   <br>

	

	</div>

	

	

	

	<?php
	
	//connect to database
		 $con = mysqli_connect("localhost","root","");
		 if (!$con) 
		 {
			 mysqli_select_db("stationaryonlinecustomers", $con);
		 }

	
	// check if the form has been submitted. If it has, start to process the form and save it to the database

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

	{

	// get form data, making sure it is valid

	$ID = mysqli_real_escape_string($con, htmlspecialchars($_POST['ID']));

	$ProductName = mysqli_real_escape_string($con,htmlspecialchars($_POST['ProductName']));

    $Price = mysqli_real_escape_string($con,htmlspecialchars($_POST['Price']));
       
    $Stock = mysqli_real_escape_string($con,htmlspecialchars($_POST['Stock']));
      
	}

	// check to make sure both fields are entered
    $ID='';
	if ($con == '' || $ID == '' || $ProductName == '' || $Price == '' || $Stock =='')

	{

	// generate error message

	$error = 'ERROR: Please fill in all required fields!';
	
	}

	else{
	// save the data to the database

	$u = mysql_query($con, "INSERT productorders SET ID='".$ID."', ProductName='".$ProductName."', Price='".$Price."', Stock='".$Stock."'");
	

	// once saved, redirect back to the view page

	header("location:View.php");


	// if the form hasn't been submitted, display the form

	renderForm('','','');

	}

	?></

What am I missing ?

What I have tried:

Youtube tutorials, Tutorials from different websites and books on PHP and MySql