PHP MySQL query with variables

Question

I am trying to do a mysql fetch using a variable in my sql query.. Unfortunately I have no idea why the query is not working.

After the $_GET I have the echo to make sure that that was actually working, which it is, but the error seems to be occurring where the actually query is going

<?php
$con=mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$scout_id = $_GET['scout_id'];
echo "scout_id: ".$scout_id;

/*This is where the error is */
$result = mysqli_query($con,"SELECT * FROM scouts WHERE scout_id='$scout_id' ");
$row = mysql_fetch_row($result);

var_dump($row);
?>

If anyone would be able to help I would be most appreciative!

Your query is subject to SQL injections and is a security hazard. Never use user input (GET, POST, COOKIE) directly in a query. — Devon Bessemer
– Devon Bessemer, Commented Apr 3, 2015 at 4:05

Sadikhasan · Accepted Answer · 2015-04-03 04:03:35Z

2

You are mixing mysqli with mysql

Change

$row = mysql_fetch_row($result);

To

$row = mysqli_fetch_row($result);

answered Apr 3, 2015 at 4:03

Sadikhasan

18.6k23 gold badges84 silver badges126 bronze badges

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

1 Comment

nom_nutella Over a year ago

Oh my goodness you are a genius! Thank you so much! I completely overlooked that part.

Collectives™ on Stack Overflow

PHP MySQL query with variables

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related