[PHP] Inputing data to a relational database
I am a nebie to Mysql/php and am currently working on an urgent project, a on-line catalogue. I have been using phpmyadmin, to create the tables in MySQL. However I now want to add data into the tables. I am reluctant to program a php page to do this, as I do not (yet) have sufficient php knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which is:- The tables reference each other, for example The categories are stored in a categories table The products table includes a field category to ensure referential integrity, when adding a product to the products table, I want to have a combo box that will let me select one of the categories from the categories table. Is there anything like phpmyadmin that will let me do this without me having to write code. Any advice much appreciated Nathan Roberts -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Inputing data to a relational database
www.mysql.com - Documentation - is you know how to insert data using SQL already then just make the PHP script. --Joe On Mon, Apr 09, 2001 at 01:11:57AM +0100, Nathan Roberts wrote: I am a nebie to Mysql/php and am currently working on an urgent project, a on-line catalogue. I have been using phpmyadmin, to create the tables in MySQL. However I now want to add data into the tables. I am reluctant to program a php page to do this, as I do not (yet) have sufficient php knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which is:- The tables reference each other, for example The categories are stored in a categories table The products table includes a field category to ensure referential integrity, when adding a product to the products table, I want to have a combo box that will let me select one of the categories from the categories table. Is there anything like phpmyadmin that will let me do this without me having to write code. Any advice much appreciated Nathan Roberts -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] /**\ *Joe Stump - PHP/SQL/HTML Developer * * http://www.care2.com - http://www.miester.org - http://gtk.php-coder.net * * "Better to double your money on mediocrity than lose it all on a dream." * \**/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Inputing data to a relational database
Not that I am aware of, because all the referential integrity relating to mysql, is in whatever code you write to access it. So you are going to have to use C,Perl,PHP,Python, or something to access your data, and control integrity. Play with mysql queries in php. As long as you only do selects, you can't damage the table. When you understand how to send the query from php - mysql, then you can build your insert queries and such, and not worry too much. Php really is easy in this respect, and every PHP book that I have looked at gets you to the point of using mysql really quickly. There are also plenty of tutorials on the net. See the php links page on php.net On 4/8/01 5:11 PM, "Nathan Roberts" [EMAIL PROTECTED] wrote: I am a nebie to Mysql/php and am currently working on an urgent project, a on-line catalogue. I have been using phpmyadmin, to create the tables in MySQL. However I now want to add data into the tables. I am reluctant to program a php page to do this, as I do not (yet) have sufficient php knowledge. As far as I can see phpMyadmin doesn't do all I need it to, which is:- The tables reference each other, for example The categories are stored in a categories table The products table includes a field category to ensure referential integrity, when adding a product to the products table, I want to have a combo box that will let me select one of the categories from the categories table. Is there anything like phpmyadmin that will let me do this without me having to write code. Any advice much appreciated Nathan Roberts -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]