On May 6, 2:57 am, John <[EMAIL PROTECTED]> wrote:
> I have the same question. I have over 20k rows of data in mysql, and
> the idea is for there to be an update button beside each row. I don't
> see any examples of how to interact with the database here -- in php
> it's $sql = "..."; in ruby/rails it's Thing.new[...], but what's up
> with jquery?
You should first learn how to write a simple php page that interact
whit the database. For example, this is a simple script that delete a
record:
mysql_connect(HOST,USER,PASS);
mysql_select_db(DB);
if ($_GET['id']) {
if (mysql_query("DELETE FROM table WHERE id='" . $_GET['id'] .
"')) {
echo "deleted ok";
}
else {
echo "deleted ko";
}
}
Then you can call this page whit an jQuery Ajax request and if the
returned value is "deleted ok" perform the jQuery effect you want.
Hope it helps you!
