PostgreSQL/mySQL: connecting, login code problem.

#1 (**permalink**) 02-28-2004

Hey,
Hours ... I am searching
I have these code and we found it's postgreSQL.
Now we have mysql, isn't it possible to change the connect code and let it
connect
to my mysql ?
My dB is there alrdy I just need this template to use the dB.

CODE
function l2dp_connect( $database )
{
return pg_connect( "host=localhost user=test dbname=$database
password=blabla");
}

This ain't working for me. Allthoug not for me

CODE
function l2dp_connect( )
{ //PAS ONDERSTAANDE AAN !!!!

$database_url = "mysqlhost"; // URL van je database
$gebruiker = "";// gebruiker van je database
$wachtwoord = ""; // wachtwoord van je database
$database = "lin2_"; // de naam van de db

mysql_connect($database_url, $gebruiker, $wachtwoord); //
maakt verbinding met de databse
mysql_select_db($database);
}

This is the whole code, maybe you guy's understand this faster then I do,
I'm kinda roockie in PHP, but for sure in postgreSQL.
It should work cause others used this code alrdy with mysql.

CODE
<?php

function ***_header()
{
global $***_lang;

if ( isset( $_GET['language'] ) )
{
setcookie( 'language', '', time()-3600, '/' );
setcookie( 'language', $_GET['language'], time()+3600*24*30, '/' );
$l2dp_lang = $_GET['language'];
}
else
{
if ( isset( $_COOKIE['language'] ) )
{
$***_lang = $_COOKIE['language'];
}
else
{
setcookie( 'language', '', time()-3600, '/' );
setcookie( 'language', 'e', time()+3600*24*30, '/' );
$***_lang = 'e';
}
}

echo <<<EOD
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-US"
xml:lang="en-US">
<head>
<META http-equiv=Content-Type content="text/html; charset=UTF-8">
<LINK href="***.css" rel="stylesheet" type="text/css"/>

EOD;
}

function l2dp_body()
{
echo "</head>\n";
echo "<body bgcolor=\"#FFFFFF\" text=\"#000000\" link=\"#0000FF\"";
echo " vlink=\"#FF00FF\" alink=\"#FF0000\">\n";

if ( strstr( $_SERVER['REQUEST_URI'], '?' ) )
{
$base = $_SERVER['REQUEST_URI'] . '&';
}
else
{
$base = $_SERVER['REQUEST_URI'] . '?';
}
echo "<table border=0 width=100%><tr><td>";
echo "<a href=\"index.php\">[home]</a>";
echo "<td align=right><a href=\"" . $base .
"language=e\">English</a> - ";
echo "<a href=\"" . $base . "language=k\">Korean</a> - ";
echo "<a href=\"" . $base . "language=j\">Japanese</a> - ";
echo "<a href=\"" . $base .
"language=c\">Chinese</a></td></tr><table><br>\n";
echo "<table width=740 border=0 cellpadding=0 cellspacing=0>";
echo "<tr><td width=\"100%\">\n\n";
}

function l2dp_footer()
{
echo "</td></tr></table><p>"
. "<a href=\"http://***">***</a> data from "
. gmdate('Y-M-d H:i:s \U\T\C', time() ) . "</p>\n";
echo "</body></html>";
}

function ***_connect( $database )
{
return pg_connect("host=localhost user=tester dbname=$test_");
}

function l2dp_disconnect( $db_conn )
{
pg_close( $db_conn );
}

?>

Thanks a ton alrdy.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode