php preview with webuilder 8.0.2.77

daredare · Post by **daredare** » Sun Sep 09, 2007 1:49 pm

hello,

i am trying to use the php function mysql_connect

everytime i try to connect i got in the preview window of webuilder an error message:

Fatal error: Call to undefined function mysql_connect()

i already have installed php in my computer so i can preview php in webuilder , what is causing this error ? do i need to install something else locally to have mysql_connect() working?

thanks

daredare · Post by **daredare** » Mon Sep 10, 2007 10:14 am

is it possible to use the mysql functions that php has within webuilder preview?

Post by **Karlis** » Mon Sep 10, 2007 10:46 pm

This looks to have nothing to do with WeBuilder, most likely there is an error in PHP configuration. Make sure you have enabled mysql support in PHP.

Post by **chrisjlocke** » Mon Sep 10, 2007 10:46 pm

mysql_connect obviously needs MySQL installed to run, as its part of that library.
php.exe is just for the 'core' of php - ie, just the basics.

I recommend Xampp (http://www.apachefriends.org/en/xampp.html). It installs php, mySQL, phpMyAdmin, etc all in one package. It honestly couldn't get any simpler.

Download the main package, and switch it to use whatever php version you're using, eg, php4. php5 is installed by default.

daredare · Post by **daredare** » Tue Sep 11, 2007 2:23 pm

i downloaded xampp and installed it , but i still cant connect to my db even in root mode

i wrote in webuilder:

mysql_connect("localhost", "root", "");

but the preview window shows a blank page?

Post by **chrisjlocke** » Tue Sep 11, 2007 3:10 pm

Thats OK then isn't it? No error.
You now have to write the code to extract the records and display them.

daredare · Post by **daredare** » Tue Sep 11, 2007 9:14 pm

thank you, now i can connect locally, it works.

Post by **chrisjlocke** » Tue Sep 11, 2007 9:17 pm

Glad you got it working. \o/