I am trying to get data from mysql database which is already created. I am trying to get the person to input the information and then have have the PHP code go out and get the correct data back from the database and display it on the screen in a table.
This is my connection string to my database.
$con=mysqli_connect ("localhost", "root", "", "abc") ;
$result = mysqli_query($con,"SELECT * FROM Customer");
This is what I have for my form so far.
<form id="Form1" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
Customer First Name: <input name="Username" type="text"><br>
Customer Last Name: <input name="LastName" type="text"><br>
OR<br>
Device Name: <input name="DevName" type="text"><br>
<input type="submit" value="Submit">
What is the total number of devices that were checked out during a certain timeframe? This is the information that I am trying to pull from my database.
I know this isn't much but I am a complete noob at PHP and need help!
Thank you very much!