check if text match php mysql (beginner)

Question

Sorry for this very beginner question... I have a table like

| id | block_1 | block_2|
-------------------------
| 1  | Mark    | John   |
| 2  | Antony  |        |
-------------------------

i want check if text in a cell match my variable for example $name:

...
$sql = "SELECT * FROM my_table WHERE id='1'";
$res = mysql_query($sql, $connection);
$row = mysql_fetch_array($res);


$block1 = $row['block_1'];
$name = 'Mark';

if ($block1 == $name)
{
echo 'yes';
}
else
{
echo 'no';
}

but i think my reasoning is wrong, im beginner... all solutions are welcome

You should avoid using mysql_* functions. They are no longer safe to use and will soon be removed from the language as a whole. — César, Apr 18 '16 at 15:27
Side note: if you're learning, don't waste your time studying the legacy mysql extension, which has been deprecated for years and is no longer part of latest PHP version. It's like learning Latin before a holiday in Rome. — Álvaro González, Apr 18 '16 at 15:28

score 0 · Answer 1 · edited Sep 13 '16 at 10:37

0

When you use mysql_fetch_array you can't use $row[COLUMN_NAME].

You must use $row[COLUMN_INDEX] or use mysql_fetch_assoc method for fetch by column name.

  $row = mysql_fetch_assoc($res);
  $block1 = $row['block_1'];

Read more in http://www.w3resource.com/php/function-reference/mysql_fetch_assoc.php

edited Sep 13 '16 at 10:37

marc_s

732,580
175
1,330
1,459

answered Apr 18 '16 at 15:38

Hamid Abbasi

346
2
14

score 0 · Answer 2 · edited May 23 '17 at 12:08

0

try this:

$sql = 'SELECT * FROM my_table WHERE id="1"';

It may be helpful to stick using double quotes only on the in-side of single quotes. It's not necessary...but it has always helped me in practice in trying to keep track of them. If you pick one, remember to stick with it....you've used single quotes in the rest of your code below:

$name = 'Mark';
echo 'yes';

The above comments are correct....
This is a depreciated way of doing MYSQL calls, please consider this: Are there any security benefits to using PDO::query vs. mysql_query? switching mysql_query() to PDO::query() and learning how it functions will keep you upto date.

Best of luck.

edited May 23 '17 at 12:08

Community

1
1

answered Apr 18 '16 at 15:41

n8thanael

330
3
10

Single-quote vs. double-quote is not just a matter of preference: http://stackoverflow.com/questions/3446216/what-is-the-difference-between-single-quoted-and-double-quoted-strings-in-php – WillardSolutions Apr 18 '16 at 15:50
@EatPeanutButter...very true - I think your link is very helpful. – n8thanael Apr 18 '16 at 16:07

score -1 · Answer 3 · answered Apr 18 '16 at 15:28

-1

You're just missing a quote there

$sql = "SELECT * FROM my_table WHERE id='1'";

answered Apr 18 '16 at 15:28

César

370
1
9

Levan Abashidze · Accepted Answer · 2016-04-18T15:39:56.103

-1

You can count results with requested variables.

$sql = "SELECT COUNT(*) as total FROM my_table WHERE id='1' AND block_1='Mark'";
$res = mysql_query($sql, $connection);
$row = mysql_fetch_assoc($res);
echo $row['total'] > 0 ? 'yes' : 'no';

edited Apr 18 '16 at 15:39

answered Apr 18 '16 at 15:29

Levan Abashidze

100
5

You should *explain* your answer – ʰᵈˑ Apr 18 '16 at 15:31
Why not do `block_1='Mark'` instead of `block_1='{$name}'`? – Amous Apr 18 '16 at 15:33
If he wants to use variable ;) – Levan Abashidze Apr 18 '16 at 15:34
don't work for me but open other way to think, thank you – gege Apr 18 '16 at 15:43
yes this work, but not for me, maybe i have same error when insert my records, maybe a unicode problem and those things. Thank you again – gege Apr 18 '16 at 16:35

check if text match php mysql (beginner)

4 Answers4