Change my where query depend on input text

Question

I want my input text to go in my where query, I can make it work with numbers, but when i try to search with letters in the input field. It doesn't work. Any suggestion? Do i need to convert something ?

<form name="form" method="get">
  <input type="text" name="test">
  <input type="submit" name="button1"  value="Search">
</form>

$nickval = $_GET["test"];

This one is working.

//Establish connection to database
$host = "****";
$conn = ******
$query = " Select * 
from p900
where p900key = $nickval
ORDER BY P900KEY";

This one doesnt work, In input i write AB which is signature.

//Establish connection to database
$host = "****";
$conn = ******
$query = " Select * 
from p900
where p900SIG= $nickval
ORDER BY P900key";

Sorry if im unclear, i tried my best

Rahul Patel · Accepted Answer · 2016-09-19T11:43:22.940

2

For letters in where condition you have to wrapped textbox value in quotes like below.

//Establish connection to database
$host = "****";
$conn = ******
$query = " Select * 
from p900
where p900SIG= '$nickval'
ORDER BY P900key";

edited Sep 19 '16 at 11:43

answered Sep 19 '16 at 11:42

Rahul Patel

5,248
2
14
26

the data coming from textbox is already in string format – Alive to die - Anant Sep 19 '16 at 11:43
Yes, so to match string value in DB value should be quoted. For numeric value comparison no need of quotes. – Rahul Patel Sep 19 '16 at 11:45
thanks man, much appreciated – Mato Sep 19 '16 at 12:02

Change my where query depend on input text

1 Answers1