PHP GTK Error with Database Command

[javaclopedia]

Hello all, I have serious problems...

this is my code:

<?php
<?php
if (!class_exists('gtk')) {
    die('Please load the php-gtk2 module in your php.ini' . "\r\n");
}

class FrmLogin extends GtkWindow
{    

  .....
  function login() {        		        

            mysql_connect("localhost","root","admin");
            mysql_select_db("db_rental_vcd");
            $query = mysql_query("select * from tbl_setting");
            $result= mysql_fetch_array($query);
  }
  ....
}
?>

I am running my application with this command:

php.exe -q rental_gtk_src/FrmMain.php

But, I get this error while running:
C:\php-gtk2>php.exe -q rental_gtk_src/FrmMain.php

Fatal error: Call to undefined function mysql_connect() in C:\php-gtk2\rental_gt
k_src\FrmLogin.php on line 65

Anyone can help me? Thanks

[TheoGB]

Sounds like you may need to set up your php.ini file to include a MySQL DLL. Someone else will probably have the exact answer but if you google your error and PHP.INI I'm sure you'll get an answer.

[bradgrafelman]

The 'mysql' library is part of an extension just like the php_gtk2 extension, so you'll want to do similar checks for the former as you already do for the latter.

See the manual for more info: [man]mysql.setup[/man].

[javaclopedia]

I already trying but while I am running the application, PHP-GTK Crash and show the error message need mysql.dll, I am adding mysql.dll, show another error message need MySQLLib.dll...

[javaclopedia]

Now I am very very confuse... Setting up PHP-GTK with database like MySQL or SQL Lite. All problems are same. Cannot find library dll, but I am already copy all dll requirements into ext folder. I already set php.ini

But the error still show. 🙁

[javaclopedia]

Then I am set this, in php.ini:

php-gtk.extensions = php_mysql.dll
php-gtk.extensions = php_mysqli.dll
php-gtk.extensions = libmysql.dll

The error not showing again, but this error showing while I am calling mysql_connect() method

C:\php-gtk2>php.exe -q rental_gtk_src/FrmMain.php

Fatal error: Call to undefined function mysql_connect() in C:\php-gtk2\rental_gt
k_src\FrmLogin.php on line 65

[bradgrafelman]

javaclopedia wrote:

php-gtk.extensions = libmysql.dll

libmysql.dll is not a PHP extension - it's a client library required by one of them (namely the 'mysql' extension).

javaclopedia wrote:

Cannot find library dll, but I am already copy all dll requirements into ext folder.

The only DLL files you should have in your 'ext' extension folder are PHP extension files, e.g. ones that begin with "php_". All other libraries are supporting DLLs that must be in a directory found in your system's PATH environment variable (or in the same directory as the application you're executing).

[javaclopedia]

I am placing all dll libraries in /ext folders:
php_mysql.dll
php_mysqli.dll

and libmysql.dll in phpgtk folders:

Then I am changing php-cli.ini to add this row:
extension = php_mysql.dll
extension = php_mysqli.dll

But, If I am running the GTK App, this is show in command prompt:

Error:The procedure entry point _mysqlnd_end_psession could not be located in the dynamic link library php5ts.dll

Error:The procedure entry point zend_std_get_constructor could not be located in the dynamic link library php5ts.dll

PHP Warning:  PHP Startup: Unable to load dynamic library '.\ext\php_mysql.dll'
- The specified procedure could not be found.
 in Unknown on line 0
PHP Warning:  PHP Startup: Unable to load dynamic library '.\ext\php_mysqli.dll'
 - The specified procedure could not be found.
 in Unknown on line 0

Please help me 🙁

Anyone have step by step clearly to setting PHP-GTK with MySQL Database?

[bradgrafelman]

Sounds like you've got a mismatched DLL & PHP version. Where did you get the php_*.dll files?

[javaclopedia]

bradgrafelman;10957368 wrote:

Sounds like you've got a mismatched DLL & PHP version. Where did you get the php_*.dll files?

I am getting dll files from XAMPP Instalation Files, there are php_mysql.dll, php_mysqli.dll and libmysql.dll.

I am copying it into my PHP-GTK folders...

Please help me.. :queasy:

[javaclopedia]

bradgrafelman;10957368 wrote:

Sounds like you've got a mismatched DLL & PHP version. Where did you get the php_*.dll files?

How about mysql connection settings in PHP GTK?