Lonnie,
Try something like this:
create a file called db_connection_params.inc - I do this maintainability :)
(change to match your specifics)
<?
$host="localhost";
$usr="username";
$pass="password";
$database="database_name";
?>
Here is a sample page with connection/query:
<?
$sql = "SELECT * from table WHERE field = something";
include("db_connect_params.inc");
$link_id = mysql_connect($host, $usr, $pass); //setup a connection handle
mysql_select_db($database, $link_id); //select database catalog (schema,
namespace, etc)
$result = mysql_query($sql, $link_id); //return result set to php
echo $result;
?>
There are lot's of different ways to do this, check out the mysql functions:
http://www.php.net/manual/en/ref.mysql.php
HTH!
regards,
jaxon
On 2/11/01 4:40 PM, "Info" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Fifteen years ago I did lots of Informix SQL on Unix -- including transaction
> processing -- BUT I find there isn't a lot of immediate help from that
> experience -- I tried using some webmonkey examples as "basic training" for
> php with MySQL and got nowhere.
>
> I'm on Red Hat with Apache 1.3.9, PHP 4.02 and MySQL 3.22.32
>
> Is there a good place to find typical PHP and MySQL code examples for that
> configuration?
>
> My pages are "virtual" hosted and I have access to phpMyAdmin 2.0.5 which is a
> menu access by my ISP.
>
> My php.ini is at /usr/local/lib
>
> I've built a very small database of five fields in database "eprofitsys" in
> table "employees" and would like to connect to it within a .php file. So,
> obviously, I am at ground zero. Anyone want to lift me up.
>
> Lonnie
>
--
PHP General 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]
