-----------------------------------

agnivohneb

Tue Mar 20, 2007 6:21 pm


Simple MySQL Help

-----------------------------------

I have looked a lot and would like to know how to create a page that uses a MySQL database.

The following is just an example of php. I don't really know php syntax other than echo and $_GET('test').

I would like to:
$_GET('ID')

if ID = "create" {
  if the table "userinfo" not exists {
    create the table "userinfo"
  }
  $_GET('USER')
  $_GET('PASS')
  create a new item in the table "userinfo"
  put USER and PASS into the table "userinfo"
}
elsif ID = "login"{
  if the table "userinfo" not exists {
    echo "Invalid"
    stop the program
  }
  $_GET('USER')
  $_GET('PASS')
  validate USER and PASS
  if valid {
    echo "VALID"
  }
  else {
    echo "Invalid"
  }
}
else {
  echo "Invalid"
}
You get the point.

Don't use $_POST(''). the program that i want to use with it doesn't support POST only GET.

DON'T just give me the code but give me the code. break it up so i can learn it.
You can pretty much say I'm a NOOB when it comes to PHP

I would look up how to do this but it is very hard to find how to do it with examples and this simple.
I learn best with examples. Thats how I learned HTML


-----------------------------------

rdrake

Tue Mar 20, 2007 8:17 pm


RE:Simple MySQL Help

-----------------------------------

Examples eh?  You have inspired me to repost my (very basic) PHP & MySQL tutorial.  You can find it [url=http://www.compsci.ca/v3/viewtopic.php?p=140178]here.


-----------------------------------

agnivohneb

Wed Mar 21, 2007 3:29 pm


Re: Simple MySQL Help

-----------------------------------

Yes that helped for the connecting part. I want to know how to add/remove/edit/read information in the database.


-----------------------------------

Dragan

Wed Apr 09, 2008 3:31 pm


RE:Simple MySQL Help

-----------------------------------

To add some values in mysql base use query

$query = "INSERT INTO some_table (username, password) VALUES ('agnivohneb', 'entered_password')";

to remove
$query = "DELETE FROM some_table WHERE username='agnivohneb' ";

to edit
$query = "UPDATE some_table SET password = 'newpass' WHERE username = 'agnivohneb'";

to read
$query = "SELECT username FROM some_table WHERE id = 1;

that are simple examples