PHP et SQL

DB1 -> données clients

DB2 -> données clients validées
       -> statut

drop database if exists client;   
create database client;   
use client;   

create table client(   
 id   int(11) unsigned auto_increment primary key,   
 nom   varchar(255),   
 prenom  varchar(255)   
)engine=innoDB;   

create table client2(   
 nom   varchar(255),   
 prenom  varchar(255),   
 statut  int(1)   
)engine=innoDB;   

insert into client(nom, prenom)    
 values   
 ('Dupond','Marc'),   
 ('pouette','Anne'),   
 ('Bush','Georges'),   
 ('Bla bla','BLAAAA');   

<?php 
 $database = 'client'; 
 $user = 'root'; 
 $password = ''; 
 $host = 'localhost'; 
  
 mysql_connect($host, $user, $password); 
 mysql_select_db($database); 
  
 $query = 'select * from client'; 
  
 $request = mysql_query($query); 
 $html = '<table>'; 
 $html .= '<tr><td>Nom</td><td>Prenom</td><td>Action</td></tr>'; 
  
 while($response = mysql_fetch_array($request)){ 
  if(isset($_POST['id'])){ 
   if($response['id'] == $_POST['id']){ 
    $nom = $response['nom']; 
    $prenom = $response['prenom']; 
    $statut = '1'; 
   } 
  } 
  $html .= '<tr><td>' . $response['nom'] . '</td><td>' . $response['prenom'] . '</td><td>'; 
  $html .= '<form method="post">'; 
  $html .= '<input type="hidden" name="id" value="'.$response['id'].'">'; 
  $html .= '<input type="submit" value="valider"/></form></td></tr>'; 
 } 
 if(isset($_POST['id'])){ 
  $query = "insert into client2(nom, prenom, statut) values ('$nom','$prenom','$statut')"; 
  $request = mysql_query($query); 
  echo 'Sauvegarde effectuée'; 
 }else{ 
  print $html; 
 } 
?>