Does anyone know of a site that has a page that allow people to test MySQL with php. I want to be able to learn how to use MySQL with php and with my current server I can’t test MySQL.
@SheldonFeb 27.2006 — #Do you have php and mysql installed then test it on your own server, set up a dummy sql database and your away with less fuss than trying to find some one else that will let you mess around and destroy there server.
@NogDogFeb 27.2006 — #I'd recommend installing PHP, MySQL, and Apache on your PC. Then you can experiment and test locally instead of on the web. I'd recommend XAMPP as a simple and convenient way to do this: http://www.apachefriends.org/en/xampp.html
@bokehFeb 28.2006 — #can someone tell me what print_r($result); would look like with$result = mysql_query(<various queries>);[/QUOTE]It would print something like: [CODE]Resource id #1[/CODE]
@NogDogMar 01.2006 — #The return value of a mysql_query() function is a resource ID, which means nothing to anyone except to PHP (it's sort of like a pointer). You must use a function like mysql_fetch_assoc() to retrieve actual data from the specified resource ID.
@NogDogMar 01.2006 — #it will print either "0" (false) if it fails, or something like "Resource ID #n" where "n" in some integer. As I said, it's just a pointer to the mysql result set and is otherwise meaningless. You must use one of the mysql_fetch functions to actually get meaningful data.
@NogDogMar 02.2006 — #...Is there any built in function that needs only to be used once to get an array...?[/QUOTE] If I knew of one, I wouldn't have written my own function to do it.