Help - Search - Members - Calendar
Full Version: Pdo Mysql Driver
Zymic Webmaster Forums > Web Design & Development > Server Side Scripting > PHP
ochho
Hello,

I am new to zymic, and everything was fine until now..but I am wondering why is there no support for mySQL PDO?

the phpinfo() shows that sqlite, sqlite2 are available.. how come no mysql? "PDO drivers sqlite2, sqlite "

And this is the error I get on my site:

"ERRNO: 256 TEXT: could not find driver"

Thank you for the help.
Ed
Should be in now, please check smile.gif
ochho
Thank you for the quick reply. I am performing some tweaks on the database, and I will report back here once I know if it's working or not.

Regards,
ochho.
ochho
I am trying to change the database through php script, because phpmyadmin doesnt work.

Everything was fine while creating Tables and populating data, but I can't create any SQL stored procedures, any idea why?

"Access denied for user 'prana_admin'@'localhost' to database 'prana_prana'"

I checked the info, and everything is good.. database="prana_prana", username="prana_admin" domain="prana.uuuq.com"

Here is the script:

CODE
<?php
$con = mysql_connect('localhost', 'prana_admin', '*****');

if(!$con){
echo 'Mysql did not connect: ' . mysql_error();
die();
}

$db_conn = mysql_select_db('prana_prana', $con);

if(!$db_conn){
echo mysql_error();
die();
} else {
echo 'Database selected <br />';
}

$sql = "CREATE PROCEDURE `catalog_get_categories_list`()
BEGIN
SELECT category_id, en_name, fr_name FROM category ORDER BY category_id;
END" ;

$query = mysql_query($sql);

if(!$query){
echo 'Table not created '.mysql_error();
die();
} else {
echo 'Table Created';
}
?>



EDIT: Resolved, Thank you Bread!
suryadharma
QUOTE(ochho @ Jun 15 2009, 02:17 AM) *
Hello,

I am new to zymic, and everything was fine until now..but I am wondering why is there no support for mySQL PDO?

the phpinfo() shows that sqlite, sqlite2 are available.. how come no mysql? "PDO drivers sqlite2, sqlite "

And this is the error I get on my site:

"ERRNO: 256 TEXT: could not find driver"

Thank you for the help.


Hello,
I'm new here, i have same problem with ochho.
The error i've got on my site:

Fatal error: Uncaught exception 'Exception' with message 'could not find driver' in /www/vndv.com/s/u/r/suryadharma/htdocs/config.php

'could not find driver' i think its mean the config file can't find PDO for Mysql

Thank's for the help
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.