save , edit , validation page sample

[jkkenzie]

Hi! Friends,

Am looking for a sample project on PHPMySql , on validating , saving and editing data to MySql database on a page.

 

regards,

JKM

[Daniel0]

Could you elaborate a bit more? What exactly do you mean?

[mellowmuppet]

I think you mean somthing like this.

 

Using the CRUD (Create Read Update Delete) and a little bit of sql query (that may or may not work this is off the top of my head)

To create NEW values in the SQL

<?php

$thislink = mysql_connect("yoursqldatabase");

mysql_query("CREATE TABLE Rotten (Rotten_id int(6) NULL auto_increment primary key,name varchar(15) NULL,description varchar(15) NULL) ");

mysql_close($thislink);

?>

 

 

 

To READ values

 

<?php

 

Class READ {

private $link;

function __construct() {

$this->link = mysql_connect("yoursqldatabase");

mysql_select_db("database name");

}

function product_id($id) {

$result = mysql_query("SELECT * FROM products WHERE Product_id = " . $id);

return mysql_fetch_object($result);

}

function __destruct() {

mysql_close($this->link);

}

}

?>

 

 

I repet again i dont know if this works so well but i think its what your after

[richardw]

Are you looking for a tutorial or a ready to go sample application?

[revraz]

http://www.freewebmasterhelp.com/tutorials/phpmysql