|
Here is a stripped down version of what I use to authenticate users, it works fine on my php v5.0.2/mysql 4.0.21 server, but fails on my php v5.1.6/mysql v5.0.45 server.
In the code below, should I be aware of anything that might not be supported by the...
Started by Brad on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Look into using PHP MySQL escaping ..
Doesn't work, try putting the following snippet right after <?php :
// Enable displaying errors like that.
|
|
Okay, I've looked all over the internet for a good solution to get PHP and MySQL working on IIS7.0. It's nearly impossible, I've tried it so many times and given up in vain. Please please help by linking some great step-by-step tutorial to adding PHP ...
Started by z3r0p4r4d0x on
, 8 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
I can get PHP-to-host-php-applications....
But I haven't had great success (using Vista).
Roadblock: How do I get PHP to work with ADOdb and MySQL?
It's supposed to work via FastCGI.
A page of information about PHP.
|
|
Hi all, I have a script which calls mysql_connect() to connect to a MySQL DB. When I run the script in a browser, it works as expected. However, when I run it from a command line I recieve the error
Call to undefined function mysql_connect()
This seems...
Started by CoolGravatar on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
If that doesn't work, try playing with mysqli and see if it's globally for the entire MySQL portion of PHP if you php cmd version actually has mysql support:
<? php echo php_info() ?>
If not, then....
|
Ask your Facebook Friends
|
I'm trying to get a PHP site working in IIS on Windows Server with MySQL.
I'm getting this error…
Fatal error: Call to undefined function mysql_connect() in C:\inetpub...\adodb\drivers\adodb-mysql.inc.php on line 363
Update…
This link outlines the steps...
Started by Zack Peterson on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I found....
Looks like you haven't got the MySQL PHP...
Check out phpinfo to see if the mysql functions are compiled with your PHP
<?php phpinfo(); ?> with MySQL support, or has not been enabled in the php.ini.
|
|
I have an extremely simple script with PHP exec , calling mysql command:
$dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'mypass'; $db = 'job'; $file ='job_create.sql'; $mySQLDir='"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql"'; if ($dbpass !=...
Started by Ngu Soon Hui on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
If php executes the command directly using something like the exec*() family of api calls rather....
The problem here is probably that
mysql < file.sql
depends on a pipe operation that is facilitated by the shell.
A commandline tool gives.
|
|
I tried to use WordPress, and it would never work. I have apache and mysql running, the accounts and database are all set up, there are no typos. So I tried to make a simple connection:
<?php $conn = mysql_connect('localhost', 'USER', 'PASSWORD'); ...
Started by Mk12 on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
First....
Not that it helps you much, but in the recent versions (and even less recent ) of MySQL, error code 2002 means “Can't connect to local MySQL server through socket [name-of-socket]”, so that might tell you a bit more.
Mysql.sock".
|
|
This works great in PHP
date_default_timezone_set('my/timezone'); $actualDate = date('Y-m-d');
Now when doing queries, I like to do
INSERT INTO articles (title, insert_date) VALUES ('My Title', now())
The problem with this is the now() in the MySQL is...
Started by alex on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Keeps everything in GM Time so if you move.
I usually set the MySQL server to Greenwich Mean Time, and then use gmdate instead of date in PHP.
To the timezone of the user before displaying it.
|
|
I am using a MySQL Nested Set approach to store the classification of the various products that are sold on the website. I am looking for a nice javascript library to help out with rendering the tree from the nested set approach. I also need a good javascript...
Started by Pasta on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
I know.
It is the php script task to prepare tree for jstree purposes.
Not know how to manage NestedSet.
|
|
I was using XAMP for windows but there were forming a lot of problems with MySql so uninstalled it and installed Apache Web Server . I connected Apache to PHP and it worked fine. I installed MySql again and it worked fine.
Now I can not get MySql to work...
Started by Eric on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Your output from phpinfo should have a MySQL section, hereCreate a .php file that only contains
<?php phpinfo(); ?>
access that from a browser and see is an example one....
If php is configured with mysql support.
|
|
I have this sql query:
SELECT DISTINCT r.uri uri FROM resource r INNER JOIN object o ON o.idResource = r.idResource WHERE r.type = 2 AND r.idResource IN ( SELECT DISTINCT r1.idResource FROM object o1 INNER JOIN resource r1 ON r1.idResource = o1.idResource...
Started by Javier on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You should use
$result = mysql_query($gquery) or die(mysql.
You shouldn't have $gquery in quotes.
|
