PHP page to run MySQL query

Question

I need a PHP+HTML page which would ask for two values from user i.e. password & id_category.

So far I have coded the PHP as:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "db1";


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "select user_id,mobile from test_user_table where id_category like '912' or id_category like '912%' or id_category like '%912%' or id_category like '%912'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["user_id"]. " - Mobile: " . $row["mobile"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>

I need a HTML page which would ask for those two variables and pass on to this code i.e. value of password to $password & id_category to the select statement (instead of 912)

Pls help

Make form with three input fields and get values by using $_POST or get or request — devpro
– devpro, Commented Jan 3, 2016 at 11:21
@devpro I am a beginner on that. Could you please tell me how to do that? — Sanchit
– Sanchit, Commented Jan 3, 2016 at 11:26
@devpro Still finding. Probably will ask someone to code the page for me. — Sanchit
– Sanchit, Commented Jan 4, 2016 at 7:12

Anto S · Accepted Answer · 2016-01-03 11:28:15Z

You html will be something look like below

<!DOCTYPE html>
<html>
<title>Login Form</title>
<body>
    <form action="form_submit" method="post">
        <table>
            <tr>
                <td>Username</td>
                <td>:</td>
                <td><input type="text" name="username" /></td>
            </tr>
            <tr>
                <td>Password</td>
                <td>:</td>
                <td><input type="password" name="username" /></td>
            </tr>
            <tr>
                <td>Category</td>
                <td>:</td>
                <td><select name="category">
                        <option value="192">Category 1</option>
                        <option value="193">Category 2</option>
                        <option value="194">Category 3</option>
                        <option value="195">Category 4</option>
                    </select></td>
            </tr>
        </table>
    </form>
</body>
</html>

Since I user method as POST you should get the value on form_submit.php as

<?php
     $username = $_POST['username'];
     $password = $_POST['password'];
     $category = $_POST['category'];
?>

devpro · Accepted Answer · 2016-01-03 11:41:56Z

0

This should be help:

HTML:

<form name="login" method="post">
Username<input type="text" name="username"/>
Password<input type="password" name="password"/>
Category<input type="text" name="category"/>
<input type="submit" name="submit"/>
</form>

PHP:

<?
if (isset ($_POST["submit"]){
$username = mysqli_real_escape_string( $_POST["username"]);
$password = mysqli_real_escape_string( $_POST["password"]);
$category = mysqli_real_escape_string( $_POST["category"]);


// YOUR QUERY
$sql = "
SELECT columns FROM table WHERE 
username = '$username' AND
password = '$password' AND (
categoryid LIKE '$category' OR 
categoryid LIKE '%$category' ....
)

 ";

}//if end
    ?>

edited Jan 3, 2016 at 11:41

answered Jan 3, 2016 at 11:35

devpro

16.1k3 gold badges29 silver badges39 bronze badges

3 Comments

Sanchit Over a year ago

do I need to have two different files or it can be in one as well?

devpro Over a year ago

U can use it in same file

devpro Over a year ago

Can downvoters share the suggestion how can I improve this?

Collectives™ on Stack Overflow

PHP page to run MySQL query

2 Answers 2

Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Related