jkkenzie Posted February 14, 2008 Share Posted February 14, 2008 Hi! Friends, Am looking for a sample project on PHPMySql , on validating , saving and editing data to MySql database on a page. regards, JKM Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted February 14, 2008 Share Posted February 14, 2008 Could you elaborate a bit more? What exactly do you mean? Quote Link to comment Share on other sites More sharing options...
mellowmuppet Posted February 14, 2008 Share Posted February 14, 2008 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 Quote Link to comment Share on other sites More sharing options...
richardw Posted February 14, 2008 Share Posted February 14, 2008 Are you looking for a tutorial or a ready to go sample application? Quote Link to comment Share on other sites More sharing options...
revraz Posted February 14, 2008 Share Posted February 14, 2008 http://www.freewebmasterhelp.com/tutorials/phpmysql Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.