Witam, próbuje wyświetlić wiersze, które zostały zmienione podczas użycia funkcji np. update, insert lub delete. Niestety nie wiem jak zwrócić odpowienio zapytanie... wewnątrz else if($check === 0)
...
function execute($execute)
{
function do_alert($msg)
{
echo '<script type="text/javascript">alert("' . $msg . '"); </script>'; }
$tab = array("update","delete","insert"); foreach( $tab as $tab2) {
$check = strpos($execute, $tab2); $res;
if($tab2 == "insert" && $check == null){
do_alert('Comand update,delete,insert is on the bad position or you use before comand some white spaces');
//throw new Exception( pg_last_error( $this->connection ) );
return false;
}
else if($tab == "insert" && $check === FALSE && $check !=1)
{
do_alert('Comand update, delete or insert is not found');
//throw new Exception( pg_last_error( $this->connection ) );
return false;
}
else if($check === 0)
{
$res=pg_query( $this->connection, $execute );
return new Resource( $res );
// return Resource->fetch();
break;
}
}
}...
class Resource
{
private $resource;
function __construct( $res )
{
$this->resource=$res;
}
function fetch()
{
}
function __destruct()
{
}
}
$db=new Database();
$result=$db->execute( "update użytkownicy SET nick='haker' WHERE nick='maker'" );
if ($result) {
while ( $row = $result->fetch())
{
foreach ( $row as $col ) echo "<td>$col</td>"; }
}
$db=null;