using database without mysql installed

------=_NextPart_000_0011_01C935F6.ADFB8A20
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

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






------=_NextPart_000_0011_01C935F6.ADFB8A20--

RE: 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=20

-------- Original Message --------
Subject: [PHP-DB] using database without mysql installed
From: "Patrick Price"
Date: Fri, October 24, 2008 1:36 pm
To:

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?=20



If it is not possible, what would be the best solution to accessing the
database?=20



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: using database without mysql installed

Well, *technicaly*... you could open a socket to the MySQL server and tal=
k to
it, but that's probably a bit much, so...

You never mentioned what kind of server this is. Is this on *nix or Windo=
ws?
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 applicatio=
n run
more smoothly (and definitely scalable).

HTH,

Yves


------ Original Message ------
Received: Fri, 24 Oct 2008 03:35:47 PM CDT
From: "Patrick Price"
To:
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 t=
o
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 a=
nd
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: using database without mysql installed

------=_Part_20749_32441157.1224958483520
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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"
> To:
> 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
>
>

------=_Part_20749_32441157.1224958483520--

Re: using database without mysql installed

------=_Part_10537_26770389.1224958714863
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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 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 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"
> > To:
> > 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
> >
> >
>

------=_Part_10537_26770389.1224958714863--

Re: 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