Whether you write the gui interface or someone else does doens't make a difference.
Robbert van Andel -----Original Message----- From: Phil King [mailto:[EMAIL PROTECTED] Sent: Thursday, August 21, 2003 11:49 AM To: [EMAIL PROTECTED] Subject: Re: [PHP] Newbie Question Hi Robbert, I beleive my ISP does not allow any GUI interface into mysql databases on the server. They have advised me that ALL functions, table creation, modification, loading data etc has to be done from PHP. It appears I have to use SQL statements within a PHP page to load the data. Phil. "Van Andel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] m... > Sorry, I did mean phpMyAdmin (no such thing as phpMySQL). Brain fart. > Won't happen again. > > Robbert van Andel > > > > -----Original Message----- > From: Dan Van Derveer [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 9:25 AM > To: '[EMAIL PROTECTED]' > Subject: RE: [PHP] Newbie Question > > > On the same note I recommend phpMyAdmin(www.phpmyadmin.net). Its interface > is quite useful especially when you have multiple DB's to manage on the same > server. > > Dan > > -----Original Message----- > From: Van Andel, Robbert [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 12:24 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP] Newbie Question > > You can download PHPMySQL and locate it in a secure portion of your site. > It's an excellent gui interface into mySQL. This tool will allow you to > upload the script file and insert the data. I'm sorry, but I don't know the > URL where to get it. Check sourceforge. > > Robbert van Andel > > > -----Original Message----- > From: Phil King [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2003 7:40 AM > To: [EMAIL PROTECTED] > Subject: [PHP] Newbie Question > > > Hi, > > I 'm in the process of modify one of my sites to use PHP/mysql instead of > ASP/Ms Access. > > The Access database has 200 records in it. > > I have PWS, mysql and PHP running on my local PC. > > I have used Navicat from mysqlstudio.com to import the access database into > mysql and then exported the data back out as an sql script. > The script consists of multiple sql statements like : > > INSERT INTO mydatabase > (id, Description, Department, RetailPrice, PrefSupPartNo, PrefSupplier) > VALUES > (1, "Bunting Plastic Union Jack 4m", "Flags & Bunting", "2.5", "JFB", > "Smiths"); > > Is there a way of "including" the sql script file into a PHP page or do I > have to copy and paste the statements into a PHP page with a "mysql_query" > statement after each sql statement, to load these records to my ISP's remote > server. > > p.s My ISP has no GUI interface into mysql so all manipulation is done via > PHP. > > Thanks very much for any guidence. > > Phil. > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
