test-tableau-postgres.php

Go to the documentation of this file.

<?php
 
include_once("../include/constant.php");
include_once("lib/ac_common.php");
require_once('lib/database.class.php');
require_once ('class/dossier.class.php');
require_once('lib/html_input.class.php');
require_once ('lib/function_javascript.php');
require_once 'class/noalyss_user.class.php';
load_all_script();
 
global $cn, $g_user, $g_succeed, $g_failed;
$cn=new Database();
 
 
$id=$cn->get_value('insert into test_array(list_tag) values (\'{"1"}\') returning id');
echo $id;
 
$cn->exec_sql('update test_array set list_tag = array_append(list_tag,\'test\')');
 
$cn->exec_sql('update test_array set list_tag = array_append(list_tag,$1) where id=$2',array('Nouveau , test',$id));
 
$val=$cn->get_value ("select array_to_string(list_tag,'/#!/') from test_array where id=$1",array(8));
 
var_dump($val);
 
$val=explode('/#!/',$val);
var_dump($val);