How to check database with php variables like this?

Question

How to check database with php variables like this ?

I have

$check = "1234567890";

This is table : check_data

 _________ ______________________________________________________________
|   id    |                         key_pass                             |
|_________|______________________________________________________________|
|____1____|_______________1234567890abcdefghij___________________________|
|____2____|_______________6545ryu76543werfdt54___________________________|
|____3____|_______________345jfuryt75yrhtufkgo___________________________|
|____4____|_______________weoiufoiweu9ew8ew8w8___________________________|
|____5____|_______________oi34ioruiofuefiusdfo___________________________|
|____6____|_______________iuyiuysdifuysfiuyfds___________________________|

i want to check like this.

$sql = "SELECT * FROM check_data WHERE key_pass(first char to ten char) = '$check'";
$query = mysql_query($sql);
$result = mysql_fetch_array($query);
if($result)
  {echo "found";}
else
  {echo "not found";}

How can i do that ?

Note that PHP's mysql_ API is deprecated.

Strawberry
– Strawberry

2014-07-21 09:48:59 +00:00
Commented Jul 21, 2014 at 9:48 — Strawberry
– Strawberry, Commented Jul 21, 2014 at 9:48

pavel · Accepted Answer · 2014-07-21 09:49:34Z

5

Check MySQL manual, you're looking for SUBSTRING function.

$sql = "SELECT * FROM check_data WHERE SUBSTRING(key_pass, 1, 10) = '" . mysql_real_escape_string($check) . "';

answered Jul 21, 2014 at 9:49

pavel

27.3k11 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

GautamD31 · Accepted Answer · 2014-07-21 09:48:34Z

4

Try with LEFT

LEFT(key_pass , 10);

Like

$sql = "SELECT * FROM check_data WHERE LEFT(key_pass , 10) = '$check'";

Also you can use SUBSTRING like

$sql = "SELECT * FROM check_data WHERE SUBSTRING(key_pass ,1, 10) = '$check'";

answered Jul 21, 2014 at 9:48

GautamD31

28.8k10 gold badges66 silver badges86 bronze badges

1 Comment

Tibor B. Over a year ago

Substring starts from 1. Source: w3resource.com/mysql/string-functions/…

Jacky Cheng · Accepted Answer · 2014-07-21 11:11:17Z

2

the function you need is LIKE,

$sql =  "SELECT * FROM check_data WHERE key_pass like ('$check%')";

you could also do

$sql =  "SELECT * FROM check_data WHERE SUBSTR(key_pass,1,10) = '$check%'";

edited Jul 21, 2014 at 11:11

answered Jul 21, 2014 at 9:52

Jacky Cheng

1,5561 gold badge10 silver badges23 bronze badges

Comments

user1864610 · Accepted Answer · 2014-07-21 09:50:01Z

1

You can use a LEFT() function like this:

ql = "SELECT * FROM check_data WHERE left(key_pass,10) = '$check'";

There are a whole family of string functions that can be useful. Check the MySQL reference

answered Jul 21, 2014 at 9:50

user1864610

Comments

Sadikhasan · Accepted Answer · 2014-07-21 09:49:51Z

0

$sql = "SELECT * FROM check_data WHERE SUBSTRING(key_pass, 1, 10)= '$check'";

answered Jul 21, 2014 at 9:49

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

Comments

karan · Accepted Answer · 2014-07-21 09:52:47Z

0

$sql = "SELECT * FROM check_data WHERE key_pass LIKE  % $check %";
$query = mysql_query($sql);
$result = mysql_fetch_array($query);
if($result)
  {echo "found";}
else
  {echo "not found";}

answered Jul 21, 2014 at 9:52

karan

16410 bronze badges

1 Comment

Mad Dog Tannen Over a year ago

Change % $check %"; to $check %";

grandcan · Accepted Answer · 2014-07-21 09:54:09Z

0

Try this

    "SELECT * FROM check_data WHERE SUBSTR(key_pass,1,10) = ".$check

or

    "SELECT * FROM check_data WHERE key_pass LIKE '".$check."%'"

answered Jul 21, 2014 at 9:54

grandcan

11 bronze badge

Collectives™ on Stack Overflow

How to check database with php variables like this?

7 Answers 7

Comments

1 Comment

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

Comments

1 Comment

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related