can php-gtk connect to mysql?

[Toadums]

Hey...finally figured out how to make desktop apps using php 😃 (excuse any misused terms, i dont really know what to call 'php-gtk' stuff)

but anyways...So is it possible to connect to a mysql db using php-gtk? Right now, I just have a button that calls a function..right now for testing all the function says is:

function login(GtkWindow $wnd, GtkEntry $txtUsername, GtkEntry $txtPassword)
{



$db_user = ""; // Username
$db_pass = ""; // Password
$db_host = ""; // Server Hostname
mysql_connect($db_host, $db_user, $db_pass) or die("cannot connect to db"); // Connects to the database.



//	$query="SELECT * FROM `pdem_timesheets`.`tblTimesheet`";
//	$result=mysql_query($query)or die("query 8 error");		
//	$num=mysql_numrows($result);//gets the number of rows of results

//$Phase=mysql_result($result,"1","Date");


//fetch the values from the widgets into variables
$strUsername = $txtUsername->get_text();
$strPassword = $txtPassword->get_text();

//Do some error checking
$errors = null;
if (strlen($strUsername) == 0) {
    $errors .= "Username is missing.\r\n";
}
if (strlen($strPassword) == 0) {
    $errors .= "No password given.\r\n";
}




if ($errors !== null) {
    //There was at least one error.
    //We show a message box with the errors
    $dialog = new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,
        Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, $errors);
    $dialog->set_markup(
        "The following errors occured:\r\n"
        . "<span foreground='red'>" . $errors . "</span>"
    );
    $dialog->run();
    $dialog->destroy();
} else {
    //No error. You would need to hide the dialog now
    //instead of destroying it (because when you destroy it,
    //Gtk::main_quit() gets called) and show the main window
    $wnd->destroy();
}
}
 

like I said, just for testing. It is an example off the php-gtk documentation page...

I commented out everything that has to do with the mysql_connect, just to test, and un commented one line at a time. It works perfect when everything is commented..and it works when uncommenting until the line with the mysql_connect call....so i figure that is where the error is.

what happens normally: the button is pressed and a msg box will pop up..
what is happening: i ht the button and the program shuts down...i think this is what it does when there is an error in the code...not sure tho

anyone know whats going on? 🙂

thanks!

[bpat1434]

Instead of dying when you can't connect, display GTK error message like you do just a few lines below. Then you might get to see something without the program crashing.

Secondly, display the results of mysql_error() as that will give you the exact MySQL error you're having. I get the feeling that it's login credentials or a hostname issue. Could also be that MySQL isn't accepting external connections, which you will have to enable external connections in the MySQL configuration.

[Toadums]

already did the external connection thing. but I will try your other suggestions 🙂

thanks!

edit: Im not quite sure where I am checking for errors in my code...? (i just copy and pasted it 🙁 )

[Weedpacket]

See, the point about example code is that you're supposed to read it.

You could at least look for the word "error" in it.

[Toadums]

.> i can see the word error lol. i read thru each step of the code, I am just not understanding how this replaces the or die() part..

    $errors = null;
    if (strlen($strUsername) == 0) {
        $errors .= "Username is missing.\r\n";
    }
    if (strlen($strPassword) == 0) {
        $errors .= "No password given.\r\n";
    }




if ($errors !== null) {
    //There was at least one error.
    //We show a message box with the errors
    $dialog = new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,
        Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, $errors);
    $dialog->set_markup(
        "The following errors occured:\r\n"
        . "<span foreground='red'>" . $errors . "</span>"
    );
    $dialog->run();
    $dialog->destroy();
} else {
    //No error. You would need to hide the dialog now
    //instead of destroying it (because when you destroy it,
    //Gtk::main_quit() gets called) and show the main window
    $wnd->destroy();
}

the error report there (assuming that it is the one that bpat referred to) is just a home made error that...isnt rly an error message, but rather a string that is displayed in a dialog box if the person forgets to enter either the username and or password

i was trying to play with: $dialog = new GtkMessageDialog($wnd, Gtk:😃IALOG_MODAL, Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, $errors); (the part in bold) ...thinking that it may be what he was talking about...but couldnt get that to work either...kinda hard to find many examples on this gtk stuff 🙁

[Weedpacket]

Toaddums wrote:

the error report there (assuming that it is the one that bpat referred to) is just a home made error that...isnt rly an error message, but rather a string that is displayed in a dialog box if the person forgets to enter either the username and or password

And what stops you from using a message dialogue for something else? Why do so many people think that the appropriate way to respond to an error is to use "or die()"? Sheer panic? It may be the appropriate thing to do in a shell script being run from the command line, but anywhere with a more sophisticated UI it's the programming equivalent of throwing yourself off a bridge. It's a stupid way to handle error conditions. That is what bpat1434 was pointing out in the first paragraph of the post.

[Toadums]

ok i see..die is bad.

Im still not getting how to do it with just a message box...

ive tried:

mysql_connect($db_host, $db_user, $db_pass) or new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, "error");

if(!mysql_connect($db_host, $db_user, $db_pass)){

$error new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, "error");

and a few other ways...but cant make it work... it still just crashes right away

[bpat1434]

Maybe this will help.

function login(GtkWindow $wnd, GtkEntry $txtUsername, GtkEntry $txtPassword)
{ 
	$db_user = ""; // Username
	$db_pass = ""; // Password
	$db_host = ""; // Server Hostname

/** NEW **/
$db_name = ""; // Database to use
$conn = mysql_connect($db_host, $db_user, $db_pass); // Connect to database

if(!$conn)
{
	$dialog = new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,
        Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, 'MySQL Connection Failed');
    $dialog->set_markup(
        "Unable to connect to MySQL Server:\r\n"
        . "<span foreground='red'>" . mysql_error() . "</span>"
    );
    $dialog->run();
    $dialog->destroy();
	return;
}

if(!mysql_select_db($db_name, $conn))
{
	$dialog = new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,
        Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, $errors);
    $dialog->set_markup(
        "Failed to select database: ".$db_name."\r\n"
        . "<span foreground='red'>" . mysql_error() . "</span>"
    );
    $dialog->run();
    $dialog->destroy();
	return;
}
/********/

//$query="SELECT * FROM `pdem_timesheets`.`tblTimesheet`";
//$result=mysql_query($query)or die("query 8 error");        
//$num=mysql_numrows($result);//gets the number of rows of results

//$Phase=mysql_result($result,"1","Date");


//fetch the values from the widgets into variables
$strUsername = $txtUsername->get_text();
$strPassword = $txtPassword->get_text();

//Do some error checking
$errors = null;
if (strlen($strUsername) == 0) {
    $errors .= "Username is missing.\r\n";
}
if (strlen($strPassword) == 0) {
    $errors .= "No password given.\r\n";
}

if ($errors !== null) {
    //There was at least one error.
    //We show a message box with the errors
    $dialog = new GtkMessageDialog($wnd, Gtk::DIALOG_MODAL,
        Gtk::MESSAGE_ERROR, Gtk::BUTTONS_OK, $errors);
    $dialog->set_markup(
        "The following errors occured:\r\n"
        . "<span foreground='red'>" . $errors . "</span>"
    );
    $dialog->run();
    $dialog->destroy();
} else {
    //No error. You would need to hide the dialog now
    //instead of destroying it (because when you destroy it,
    //Gtk::main_quit() gets called) and show the main window
    $wnd->destroy();
}
}

While looking through the code, I also noticed you have no "mysql_select_db()" call which would be a good reason why your queries fail....

[Toadums]

bpat1434;10925114 wrote:

Maybe this will help.

While looking through the code, I also noticed you have no "mysql_select_db()" call which would be a good reason why your queries fail....

oo, I see what you mean now! (about displaying the error)...that being said, it still does the same thing >.<...it just closes the program when the code gets to the line:

$conn = mysql_connect($db_host, $db_user, $db_pass); // Connect to database

...not sure why its happening...just pisses me off cause I cant know what is happening >.> and I dont think I can debug it...because (i use phpdesigner) as my IDE, and I dont think that it recognizes GTK methods...can I install them into the library? is that possible??

finally, I never use the select_db because I usually use more than one db in each program, so i just call them when I do a query:

$query = "SELECT * FROM `pdem_specifications`.`tblSpecs` ORDER BY `tblSpecs`.`TreeViewID` ASC";

...not sure if thats bad 😛 hehe