Help Needed ...

[ballaj2001]

I'm not sure if XAMPP is the issue or not.

Background:I'm using Zend Framework 1.9 and basically I am still learning. I try to use its query() function and it just keeps running until it eventually times out. No error code.

Already Checked:

Apache is running -> does not crash
MySQL is running-> does not crash
PHP.ini extension=php_pdo_mysql.dll un-commented.
Database name matches Database name in code.
Database connection information is correct.
Table name matches Table name in code.

Example Code:

Code: Select all

$statement = "INSERT INTO <table_name>(<list of comma separated field names>)VALUES(<corresponding values>)";
$connParams = array("host" => "localhost",
                "port"=>"80",
                "username"=>"root",
                "password"=>"password",
                "dbname"=>"loudbite"   
                );
   
$db = new Zend_Db_Adapter_Pdo_Mysql($connParams);

$db->query($statement);


Thanks in advance for any help provided. I'm thinking I don't have something configured correctly because I don't get an error message.

As much as I hate error codes this is much worst because I have no starting point.

[mdrisser]

Your example code isn't outputting anything, so if there is no error, you won't see anything. I'm not very familiar with Zend, so the code below is just an idea.

Code: Select all

// This is where you are executing your query, most of the time you want to assign the query results to a variable
$results = $db->query($statement);

// Now check to see if there's an error, or if everything is OK
if($ZEND_IS_ERROR($result)) { // Of course use Zend's actual error checking method
    echo "There was an error.";
} else {
    echo "The query did not produce an error.";
}


Doing something like this will help you determine if the error is with your code, or if there actually is a problem with your XAMPP installation.