Select from MySQL

Question

I am populating a List in my application. In a different Activity I'm trying to get every "event" to display in a ListView. Therefore I set up a EditText where I enter a city e.g "Hamburg". After the confirm button is clicked the list is supposed to show all the events in Hamburg.

+---------+----------+----------+------------------+
| user_id |   name   | location |   description    |
+---------+----------+----------+------------------+
|       5 | Dinner   | Hamburg  | With the Family  |
|       6 | Marriage | Bremen   | Alex and Sabrina |
|       7 | Match    | Berlin   | Hamburg - Hertha |
|       8 | Meeting  | Berlin   | Alexanderplatz   |
|       9 | Cinema   | Berlin   | FUG2             |
+---------+----------+----------+------------------+

My question, I cannot figure out how to state the SQL-Statement in the PHP document. All i have is:

$result = mysql_query("SELECT * FROM events WHERE location = ':location'") or die(mysql_error());

Correct me if I'm wrong, but does `mysql_*` even have parameterised query support? — Jonnix, Sep 18 '15 at 08:38
BTW: [Why shouldn't I use mysql_* functions in PHP?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) — Ocaso Protal, Sep 18 '15 at 08:39

score 3 · Answer 1 · answered Sep 18 '15 at 08:40

mysql_ functions are depricated. I don't think that original mysql extension supports named parameters. You really should look into mysqli or even better PDO.

In mysqli that would be something like:

$mysqli = new mysqli("localhost", "root", "password", "database");
$sql = "SELECT * FROM events WHERE location = ?";
$statement = $mysqli->prepare($sql);
$statement->bind_param("s", $location);
$statement->execute();

score 0 · Answer 2 · answered Sep 18 '15 at 08:37

0

If you are submitting data to php file then you can use something like this for location :

$location=$_POST['location'];
$result = mysql_query("SELECT * FROM events WHERE location = $location") or die(mysql_error());

answered Sep 18 '15 at 08:37

pspatel

508
2
7
18

score 0 · Answer 3 · edited Sep 18 '15 at 08:42

0

$result = mysql_query("SELECT * FROM events WHERE location = $location")

edited Sep 18 '15 at 08:42

Saty

22,443
7
33
51

answered Sep 18 '15 at 08:39

Pallavi Kulkarni

1
2

Select from MySQL

3 Answers3