[carmex]

Dormilich, on 06 March 2013 - 06:49 AM, said:

correct, it’s the quotes. field names are not quoted by apostrophes (only by backticks), so if you write firstName = A SQL reads "assign the value of field A to field firstName". then why does it work with numbers? because numbers cannot be field names.

So I guess I need to declare it a variable? or make it recognize its a vchar? How would i go about that?

Quote

PS. another matter that doesn’t exist with prepared statements.

As i fix mine I'm trying to get your PDO example to work. However no luck yet, you mention initializing it ?

wow I'm actually learning ! Thank you so much !

[carmex]

oh just added the ' ' round and it works, thank you !!

This post has been edited by carmex: 06 March 2013 - 07:17 AM

[Dormilich]

carmex, on 06 March 2013 - 02:57 PM, said:

As i fix mine I'm trying to get your PDO example to work. However no luck yet, you mention initializing it ?

you neet a connection to the database. without that, even PDO "does not work". there are some PDO tutorial in the tutorials’ section where you can see that.

carmex, on 06 March 2013 - 02:57 PM, said:

wow I'm actually learning /> !

that is why I don’t hand out the ready code.

[carmex]

What are the advantages over pdo over the way I'm doing it.
Field name collision is obviously one, what are others.. Efficiency?

Once again massive thank you.
One massive thing I'm going to take away is always, always, always use an error report

[Dormilich]

other advantages
- no worries about SQL Injection
- multiple output types (i.e. you can fetch data into a class)
- repetition (if you have multiple data sets (seats), you only need to prepare once and then you only submit each of the data (each seat))
- PDO can use exceptions for error handling
- you can loop over a PDOStatement directly
- PDO supports Transactions

[carmex]

Hi Dormilich,
Need some further advice on another idea.
Basically:
On the home page i would like it to show the available seats in each venue without having to access the seating plan page.
I just need some help on the writing of this code.
My logic in Pseudo code is:

j=0
Select * from school hall 
  for every status == 0:
    j+1

echo j

How would i go about doing this in php?
Thanks in advance

This post has been edited by carmex: 13 March 2013 - 04:40 AM

[Dormilich]

if you just want the amount of available seats, use SQL’s COUNT() function.
SELECT COUNT(*) FROM seat_table WHERE status = 0;

[carmex]

Dormilich, on 13 March 2013 - 05:37 AM, said:

if you just want the amount of available seats, use SQL’s COUNT() function.
SELECT COUNT(*) FROM seat_table WHERE status = 0;

I've tried that, cannot get it to echo or display its results

[Dormilich]

then, how did you try to echo the result (MySQL doesn’t do that automatically)?

[carmex]

Dormilich, on 13 March 2013 - 05:40 AM, said:

then, how did you try to echo the result (MySQL doesn’t do that automatically)?

$sql = "SELECT COUNT(*) AS freeseats FROM dramaStudio WHERE status=0";
mysql_query($sql);
echo $sql;

$sql = "SELECT COUNT(*) AS $freeseats FROM dramaStudio WHERE status=0";
echo $freeseats;

$query = "SELECT COUNT(*) AS freeseats FROM dramaStudio WHERE status=0";
$result = mysql_query($query);
echo $result;

a few ways />

This post has been edited by carmex: 13 March 2013 - 05:47 AM

[Dormilich]

nothing of that is even close.

that’s simply not how you get DB data at all. DB data need to be fetched.

[carmex]

Dormilich, on 13 March 2013 - 05:51 AM, said:

nothing of that is even close.

that’s simply not how you get DB data at all. DB data need to be fetched.

$result = mysql_query("SELECT COUNT(*) AS freeseats FROM schoolHall WHERE status=0");
$row = mysql_fetch_array($result);
echo $row[0];

? how about this?

This post has been edited by Dormilich: 13 March 2013 - 05:57 AM
Reason for edit:: please use [code] [/code] tags when posting code

[Dormilich]

does it do what you want?

[carmex]

Dormilich, on 13 March 2013 - 05:57 AM, said:

does it do what you want?

YES! thank you!

I'm also trying to implement a search function for the user to search whether someone has made a booking. Do you know any tutorials for this that will help?

[Dormilich]

the reason PDO does not always call its fetch() method is that in a foreach loop the fetch() method is called automatically.