Re: [PHP-DB] using database without mysql installed
Patrick Price wrote:
I am trying to access a mysql database server from a php 5.2 server that
doesn't have mysql installed on it. I don't have access or the ability to
reinstall php on this server. Is it possible to install mysql after php is
installed and up and running?
Of course.
php just needs the php-mysql connector. When that's provided doesn't
matter (just remember to restart the webserver).
The best solution I could think of would be to require a php file that is
running on a server that I have control of and that has mysql installed and
using that file to call the database to get the information I need.
Connect to mysql remotely. The db does not have to be on the same
machine at all.
mysql_connect lets you put in a server name - it can be an ip address
(recommended) or a hostname (not so recommended - if dns plays up, you
can't connect).
mysql_connect('192.168.0.50', 'user', 'pass');
--
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] using database without mysql installed
Well, *technicaly*... you could open a socket to the MySQL server and talk to it, but that's probably a bit much, so... You never mentioned what kind of server this is. Is this on *nix or Windows? And do you have access to the php.ini file at least so you can enable the mysql extension? Other than that, I think your idea of putting a script on a second server to get your data would work just fine. You could have the second script even send back your requested data in XML or use Ajax to populate tables on the client-side rather than the server side. It may even make your application run more smoothly (and definitely scalable). HTH, Yves -- Original Message -- Received: Fri, 24 Oct 2008 03:35:47 PM CDT From: Patrick Price [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] using database without mysql installed I am trying to access a mysql database server from a php 5.2 server that doesn't have mysql installed on it. I don't have access or the ability to reinstall php on this server. Is it possible to install mysql after php is installed and up and running? If it is not possible, what would be the best solution to accessing the database? The best solution I could think of would be to require a php file that is running on a server that I have control of and that has mysql installed and using that file to call the database to get the information I need. Thanks for any help. Patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] using database without mysql installed
Umm you can convert it to files-based database (for instance - .sq3 - sqlite) and work with it, and yes, installing mysql after php is possible. HTH, Nitsan On Sat, Oct 25, 2008 at 4:32 PM, YVES SUCAET [EMAIL PROTECTED] wrote: Well, *technicaly*... you could open a socket to the MySQL server and talk to it, but that's probably a bit much, so... You never mentioned what kind of server this is. Is this on *nix or Windows? And do you have access to the php.ini file at least so you can enable the mysql extension? Other than that, I think your idea of putting a script on a second server to get your data would work just fine. You could have the second script even send back your requested data in XML or use Ajax to populate tables on the client-side rather than the server side. It may even make your application run more smoothly (and definitely scalable). HTH, Yves -- Original Message -- Received: Fri, 24 Oct 2008 03:35:47 PM CDT From: Patrick Price [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] using database without mysql installed I am trying to access a mysql database server from a php 5.2 server that doesn't have mysql installed on it. I don't have access or the ability to reinstall php on this server. Is it possible to install mysql after php is installed and up and running? If it is not possible, what would be the best solution to accessing the database? The best solution I could think of would be to require a php file that is running on a server that I have control of and that has mysql installed and using that file to call the database to get the information I need. Thanks for any help. Patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] using database without mysql installed
I think I will have to use a second script on mysql server since (I forgot to mention) the database is replicated and that seems like the best option. Thanks for the help patrick On Sat, Oct 25, 2008 at 2:14 PM, Nitsan Bin-Nun [EMAIL PROTECTED] wrote: Umm you can convert it to files-based database (for instance - .sq3 - sqlite) and work with it, and yes, installing mysql after php is possible. HTH, Nitsan On Sat, Oct 25, 2008 at 4:32 PM, YVES SUCAET [EMAIL PROTECTED] wrote: Well, *technicaly*... you could open a socket to the MySQL server and talk to it, but that's probably a bit much, so... You never mentioned what kind of server this is. Is this on *nix or Windows? And do you have access to the php.ini file at least so you can enable the mysql extension? Other than that, I think your idea of putting a script on a second server to get your data would work just fine. You could have the second script even send back your requested data in XML or use Ajax to populate tables on the client-side rather than the server side. It may even make your application run more smoothly (and definitely scalable). HTH, Yves -- Original Message -- Received: Fri, 24 Oct 2008 03:35:47 PM CDT From: Patrick Price [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] using database without mysql installed I am trying to access a mysql database server from a php 5.2 server that doesn't have mysql installed on it. I don't have access or the ability to reinstall php on this server. Is it possible to install mysql after php is installed and up and running? If it is not possible, what would be the best solution to accessing the database? The best solution I could think of would be to require a php file that is running on a server that I have control of and that has mysql installed and using that file to call the database to get the information I need. Thanks for any help. Patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] using database without mysql installed
I am trying to access a mysql database server from a php 5.2 server that doesn't have mysql installed on it. I don't have access or the ability to reinstall php on this server. Is it possible to install mysql after php is installed and up and running? If it is not possible, what would be the best solution to accessing the database? The best solution I could think of would be to require a php file that is running on a server that I have control of and that has mysql installed and using that file to call the database to get the information I need. Thanks for any help. Patrick
RE: [PHP-DB] using database without mysql installed
yes it is possible, but you need to edit php.ini manually in order to enable mysql so that php can talk to mysql database. --- http://ainab.com http://somaliyrics.net Original Message Subject: [PHP-DB] using database without mysql installed From: Patrick Price [EMAIL PROTECTED] Date: Fri, October 24, 2008 1:36 pm To: php-db@lists.php.net I am trying to access a mysql database server from a php 5.2 server that doesn't have mysql installed on it. I don't have access or the ability to reinstall php on this server. Is it possible to install mysql after php is installed and up and running? If it is not possible, what would be the best solution to accessing the database? The best solution I could think of would be to require a php file that is running on a server that I have control of and that has mysql installed and using that file to call the database to get the information I need. Thanks for any help. Patrick -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
