Sorting out files

[legokiller666]

ok sorry about making another post practically on the same subject but where do mySQL files go?

i have www.metalorb.f2s.com/lalaalal.php
so where does the SQL file go?

and also can someone please send me a file of which a php page and a mySQL document interact??

Thanks again

[liljim]

At 7/12/01 02:51 PM, legokiller666 wrote: ok sorry about making another post practically on the same subject but where do mySQL files go?

i have www.metalorb.f2s.com/lalaalal.php
so where does the SQL file go?

and also can someone please send me a file of which a php page and a mySQL document interact??

It's easier to think of MySQL as something like a blank Microsoft access database file - it's empty until you insert data into it. And that's what you do when you write scripts for use with MySQL - you're creating ways of inserting, updating, selecting and deleting entries from and into tables in your database. You can use something like phpMyAdmin, which is a web based script, to manage your tables (and being as you're on f2s.com, this is your only option (f2s doesn't provide shell access).

In your little web panel thing in the members section at f2s, there's an option to request a database. Requests are handled on a morning, so if you ask for one tonight, it'll probably be set up tomorrow.

Once it's set up, upload phpMyAdmin or whatever other script you want to use into a directory on the server. Remember to .htaccess the directory off, or anyone who guesses at the location of it will have access to your database.

Once you've done all that, go have a look at php.net, zend.com, phpresourceindex.com and other places that provide basic tutorials. devshed.com has some well written introductory tutorials too. Do some reading, and then come back with specific questions. :)

[RichL]

Once it's set up, upload phpMyAdmin or whatever other script you want to use into a directory on the server. Remember to .htaccess the directory off, or anyone who guesses at the location of it will have access to your database.

- Just a note - but F2S has phpMyAdmin already installed, just login normally and (when DB is setup) goto "database tools", you then go right to the bottom and click the "managing your databse"link..type in your info and away you go, your into phpMyadmin on F2S's server (it also saves you installing it and securing it)

[liljim]

At 7/12/01 06:52 PM, RichL wrote: - Just a note - but F2S has phpMyAdmin already installed, just login normally and (when DB is setup) goto "database tools", you then go right to the bottom and click the "managing your databse"link..type in your info and away you go, your into phpMyadmin on F2S's server (it also saves you installing it and securing it)

True, but doing so forces you to learn basic apache based concepts (which is a must), and with a bit of fiddling, you can set magic quotes runtime to on through an htaccess file (which keeps that script happy). Of course that doesn't apply to the whole of your site (just the directory to which you enforce it), but that's what you get for free hosting ;)

[legokiller666]

ok i made a database on f2s which is actually mySQL or it has been enabled or something so can someone please send me a php script which sends the variables $name and $score to the mySQL file then recieves them and places it in a top 100 table?

[Pecos]

At 7/13/01 12:02 PM, legokiller666 wrote: ok i made a database on f2s which is actually mySQL or it has been enabled or something so can someone please send me a php script which sends the variables $name and $score to the mySQL file then recieves them and places it in a top 100 table?

dude, no one is gonna write scripts for you. and mySQL is not a file.

[legokiller666]

waaa