Re: [PHP-DB] PHP cannot access mySQL
OK, now I have the errormessage: Fatal error: Call to undefined function mysql_connect() Why? Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nhan wrote: Hi, I have IIS 5.1 with PHP 5 and MySQL 4.1 With a client tool (such as MySQL Front) I can access MySQL. But my PHP page cannot, with the same username and passord. Why? What can I do? What is the error message? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP cannot access mySQL
which cmmand tell PHP, that the script may ignore error and run further.? Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nhan wrote: Hi, I have IIS 5.1 with PHP 5 and MySQL 4.1 With a client tool (such as MySQL Front) I can access MySQL. But my PHP page cannot, with the same username and passord. Why? What can I do? What is the error message? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP cannot access mySQL
Is Mysql configured in PHP to be usable? Just having both installed isn't enough, there is configuration to 'enable' mysql. Try this link: http://www.php.net/manual/en/ref.mysql.php Based on the fact that it is saying mysql_connect() is undefined, I'd say that mysql functions aren't enabled/configured. Aaron - Original Message From: Nhan [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Friday, November 2, 2007 5:04:03 AM Subject: Re: [PHP-DB] PHP cannot access mySQL OK, now I have the errormessage: Fatal error: Call to undefined function mysql_connect() Why? Chris [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Nhan wrote: Hi, I have IIS 5.1 with PHP 5 and MySQL 4.1 With a client tool (such as MySQL Front) I can access MySQL. But my PHP page cannot, with the same username and passord. Why? What can I do? What is the error message? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP cannot access mySQL
Nhan wrote: Hi, I have IIS 5.1 with PHP 5 and MySQL 4.1 With a client tool (such as MySQL Front) I can access MySQL. But my PHP page cannot, with the same username and passord. Why? What can I do? What is the error message? -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP/MySQL Access Denied
Everybody's favorite problem but this one is strange. I can connect to my mysql
4.1.7 database fine from the command line, but php won't connect no matter what
I try, I always get the same error.
Here is the script
?php
$link = mysql_connect(localhost:3306, xoops, notmypassword );
/* check connection */
if (!$link) {
printf(Connect failed: %s\n, mysql_error());
exit();
}
/* close connection */
$mysql-close();
?
This is what I get, doesn't matter what username/password I use, or whether I
use a socket or TCP/IP to connect.
Access denied for user 'root'@'localhost' (using password: NO)
I find it annoying that it insists I am trying to connect as root with no
password, when that is not the case. I know about the 4.1 password issues and
that should not have anything to do with this error. It also does this if I set
the passwords to NULL in the script and database.
Anyone have any help for me?
Tod Schmidt
System Administrator
The Nature Conservancy
[EMAIL PROTECTED]
(703) 841-2028 (Phone)
(703) 276-0713 (Fax)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP with Access DB without ODBC
Hello, how can i connect php with an access db. I need to do it without use ODBC. Thanks, Juan Torres. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php- odbc- access
Many of the people who will be using my php site, will also be using an app that runs an access db. I would like to create a page on my webpage that allows the users to click a button, and data is moved from their access db on their machines, to my mysql db. Is this possible? I will know where the access db file lives. Can php make an odbc connection and do the transfer? Can I upload the db file to my webserver and then transfer? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php- odbc- access
don't think it's possible @ once... what I suggest... those people have to make a comma delimited export file, then you make an upload page, where people can upload this file. and you make a script so it will be imported get the point? kind regards ___ Mark Snijders, Developer Atos Origin Groenewoudeseweg 1, Room VN-515 5621 BA Eindhoven, The Netherlands * : [EMAIL PROTECTED] *:+31 (0)40 - 2785992 (tel) * : +31 (0)40 - 2788729 (fax) The information in this mail is intended only for use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. Access to this mail by anyone else than the addressee is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken omitted to be taken in reliance of it, is prohibited and may be unlawful. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] php- odbc- access
There are programs that can import access db files into mysql, but none that I know of that are automated. If you have access to the access app they are running, you can install an odbc connection from their machines to your mysql database and modify your access app to connect to mysql and copy the records over. You can also have them export their data to a CSV file, upload that file and mysql can import it. Other than that I am not sure what you can do. Cheers Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 7:41 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] php- odbc- access Many of the people who will be using my php site, will also be using an app that runs an access db. I would like to create a page on my webpage that allows the users to click a button, and data is moved from their access db on their machines, to my mysql db. Is this possible? I will know where the access db file lives. Can php make an odbc connection and do the transfer? Can I upload the db file to my webserver and then transfer? Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP and Access
Hi, I normally work PHP/MySQL but now I have a customer that is adamant about keeping their data in an Access DB. you could work around it by using an odbc connection from Access to MySQL. So the administration is still done via Access but actually it is a MySQL DB. If you're interested see here: http://www.devshed.com/Server_Side/MySQL/ODBC/ cheers johannes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP and Access
I normally work PHP/MySQL but now I have a customer that is adamant about keeping their data in an Access DB. I tried to use ADODB to do generic access scripts, but that doesn't seem to work out for me. I get an unsupported function just trying to make a connection. One problem is that my server is running PHP3. I have the db file; but where does it go on the server? Or does it matter? Is there any simple wrapper type script that I can use to access their db? Tips would be helpful or links to other solutions... Thanks Terry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and Access to DB2.
Nicolas, Take a look of the following link: Hope this help. AS/400 Connection from a Linux Box to AS/400 DB2 Connection from a Linux Box to IBM DB2 Mainframes http://www.faqts.com/knowledge_base/view.phtml/aid/5613/fid/12 Can I use PHP to interface with an AS/400 database? http://www.faqts.com/knowledge_base/view.phtml/aid/257/fid/14 Can you connect to an AS/400 DB2 database from a Linux web server? http://www.faqts.com/knowledge_base/view.phtml/aid/3536/fid/10 Regards, Chris Lee On 30 Apr 2001 08:40:42 -0700, [EMAIL PROTECTED] (Nicolas Machado) wrote: Hy, somebody knows if exist a driver for database access to DB2/400, running on AS/400. Something like a module. Thanks. --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.250 / Virus Database: 123 - Release Date: 18/04/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP and Access to DB2.
Hy, somebody knows if exist a driver for database access to DB2/400, running on AS/400. Something like a module. Thanks. --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.250 / Virus Database: 123 - Release Date: 18/04/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and Access to DB2.
Check www.p2p.wrox.com...more later on this Phil J. Nicolas Machado wrote: Hy, somebody knows if exist a driver for database access to DB2/400, running on AS/400. Something like a module. Thanks. --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.250 / Virus Database: 123 - Release Date: 18/04/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP mysql_connect Access Denied
Hi
Newbie here
I am running Apache/PHP/MySQL locally which emulates my server environment
online. I want to use it as a test environment.
I am running through Julie Meloni's 'PHP Fast Easy...' and have run up
against a problem.
Using the mysql_connect statement in a php page:
?
$connection=mysql_connect("localhost", "threezero", "qwerty00") or die
("could not connect");
if ($connection) {
$msg = "success";
}
?
html
head
titleMySQL Connection/title
/head
body bgcolor="#FF" text="#00"
? echo "$msg"; ?
/body
/html
I get the following error returned in any browser:
Warning: MySQL Connection Failed: Can't connect to MySQL server on
'localhost' (10061) in c:\program files\apache
group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2
could not connect
This is returned after enetering the following into the 'mysql' database
using the MySQL monitor:
insert into user (host, user, password) values ('localhost', 'threezero',
password('qwerty00');
Querying the table returns the inserted values in the table (the password
column being encrypted).
I am thinking that there are some potential configuration problems as the
php page works in my online server environment (pair networks)
Has anyone got an idea where I am going wrong and/or can point me in the
right direction?
Any help appreciated.
TIA
Matt Coyne
t h r e e z e r o : : :
the mill, millstone lane, leicester, le1 5jn
e : [EMAIL PROTECTED] :: m : 07747 845690
w : http://www.threezero.co.uk
: : :t h r e e z e r o
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP mysql_connect Access Denied
I get the following error returned in any browser: Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in c:\program files\apache group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2 could not connect could be that mysqld isn't running... ++ | Julie Meloni ([EMAIL PROTECTED]) | || | "PHP Essentials" and "PHP Fast Easy" | | http://www.thickbook.com | ++ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP mysql_connect Access Denied
http://mysql.com/documentation/mysql/bychapter/manual_Privilege_system.html#
Adding_users
Check out the docs here.
You need to add users this way:
shell mysql --user=root mysql
mysql GRANT ALL PRIVILEGES ON *.* TO monty@localhost
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql GRANT ALL PRIVILEGES ON *.* TO monty@"%"
IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql GRANT RELOAD,PROCESS ON *.* TO admin@localhost;
mysql GRANT USAGE ON *.* TO dummy@localhost;
olinux
- Original Message -
From: "Matt Coyne" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, March 19, 2001 8:16 AM
Subject: [PHP-DB] PHP mysql_connect Access Denied
Hi
Newbie here
I am running Apache/PHP/MySQL locally which emulates my server environment
online. I want to use it as a test environment.
I am running through Julie Meloni's 'PHP Fast Easy...' and have run up
against a problem.
Using the mysql_connect statement in a php page:
?
$connection=mysql_connect("localhost", "threezero", "qwerty00") or die
("could not connect");
if ($connection) {
$msg = "success";
}
?
html
head
titleMySQL Connection/title
/head
body bgcolor="#FF" text="#00"
? echo "$msg"; ?
/body
/html
I get the following error returned in any browser:
Warning: MySQL Connection Failed: Can't connect to MySQL server on
'localhost' (10061) in c:\program files\apache
group\apache\htdocs\threezero\phptests\dbstuff\db_connect.php on line 2
could not connect
This is returned after enetering the following into the 'mysql' database
using the MySQL monitor:
insert into user (host, user, password) values ('localhost', 'threezero',
password('qwerty00');
Querying the table returns the inserted values in the table (the password
column being encrypted).
I am thinking that there are some potential configuration problems as the
php page works in my online server environment (pair networks)
Has anyone got an idea where I am going wrong and/or can point me in the
right direction?
Any help appreciated.
TIA
Matt Coyne
t h r e e z e r o : : :
the mill, millstone lane, leicester, le1 5jn
e : [EMAIL PROTECTED] :: m : 07747 845690
w : http://www.threezero.co.uk
: : :t h r e e z e r o
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
_
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
