Convertion de Script PHP utilisant Mysql vers Postgresql

Version imprimable

1 pièce(s) jointe(s)

Dans le cadre d'un projet PFE j'ai voulu intégrer un module de chat existant utilisant (php+Ajax+mysql) (source : "http://www.dynamicajax.com/fr/AJAX_Driven_Web_Chat-271_290_291.html" )

Le problème c'est que je suis obligé de passer par une base de donnée Postgresql.

le script php utilisant le sgbd mysql (database.php) est le suivant :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
<?php
 
//Make the database connection.
  db_connect() or die('Unable to connect to database server!');
 
//You will need to replace the parameters below with the values for your database connection
//server = the database server (usually localhost).
//username = The user name to connect to the database.
//password = The password to connect to the database.
  function db_connect($server = 'your server', $username = 'your db user name', $password = 'your db password', $database = 'your database name', $link = 'db_link') {
    global $$link;
 
    $$link = mysql_connect($server, $username, $password);
 
    if ($$link) mysql_select_db($database);
 
    return $$link;
  }
//Function to handle database errors.
  function db_error($query, $errno, $error) { 
    die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[STOP]</font></small><br><br></b></font>');
  }
//Function to query the database.
  function db_query($query, $link = 'db_link') {
    global $$link;
 
    $result = mysql_query($query, $$link) or db_error($query, mysql_errno(), mysql_error());
 
    return $result;
  }
//Get a row from the database query
  function db_fetch_array($db_query) {
    return mysql_fetch_array($db_query, MYSQL_ASSOC);
  }
//The the number of rows returned from the query.
  function db_num_rows($db_query) {
    return mysql_num_rows($db_query);
  }
//Get the last auto_increment ID.
  function db_insert_id() {
    return mysql_insert_id();
  }
//Add HTML character incoding to strings
  function db_output($string) {
    return htmlspecialchars($string);
  }
//Add slashes to incoming data
  function db_input($string, $link = 'db_link') {
    global $$link;
 
    if (function_exists('mysql_real_escape_string')) {
      return mysql_real_escape_string($string, $$link);
    } elseif (function_exists('mysql_escape_string')) {
      return mysql_escape_string($string);
    }
 
    return addslashes($string);
  }

de l'aide SVP

1ere essaie :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
<?php
 
 
//Make the database connection.
  db_connect() or die('Unable to connect to database server!');
 
//You will need to replace the parameters below with the values for your database connection
//server = the database server (usually localhost).
//username = The user name to connect to the database.
//password = The password to connect to the database.
  function db_connect($server = 'your server', $username = 'your db user name', $password = 'your db password', $database = 'your database name', $link = 'db_link') {
    global $$link;
 
    $$link = pg_connect("dbname=chat host=".$server." user=".$username." password=".$password);
 
    if ($$link) // Warning: mysql_select_db() not supported.
;
 
    return $$link;
  }
//Function to handle database errors.
  function db_error($query, $errno, $error) { 
    die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[STOP]</font></small><br><br></b></font>');
  }
//Function to query the database.
  function db_query($query, $link = 'db_link') {
    global $$link;
 
    $result = pg_query($$link,$query) or db_error($query, pg_last_error() , pg_result_error());
 
    return $result;
  }
//Get a row from the database query
  function db_fetch_array($db_query) {
    return pg_fetch_array($db_query,NULL,PGSQL_ASSOC);
  }
//The the number of rows returned from the query.
  function db_num_rows($db_query) {
    return pg_num_rows($db_query);
  }
//Get the last auto_increment ID.
  function db_insert_id() {
    return pg_last_oid();
  }
//Add HTML character incoding to strings
  function db_output($string) {
    return htmlspecialchars($string);
  }
//Add slashes to incoming data
  function db_input($string, $link = 'db_link') {
    global $$link;
 
  if (function_exists('pg_escape_string')) {
      return pg_escape_string($string, $$link);
    } elseif (function_exists('pg_escape_string')) {
      return pg_escape_string($string);
    }
 
    return addslashes($string);
  }
 
 
?>

09/08/2013, 01h52
Boy_From_HelL

MySQL PHP to PostgreSQL

http://mp2p.mikekohn.net/docs.php