| ------------------------------------------------------------------------------------------------------------------------------------ |
|
TECHN. RAPPEL ------------------------------------------------------------------------------------------------------------------------------------ |
|
PHP- Time //Afficher date et heure : $date = date("d-m-Y"); $heure = date("H:i"); //Serveur : setlocale(LC_TIME, "C"); $date = strftime ("%Y-%m-%d"); //Mettre la date en francais (JJ-MM-AAAA): function datem($date) { $split = split("-",$date); $annee = $split[0]; $mois = $split[1]; $jour = $split[2]; return "$jour","-","$mois","-","$annee"; } |
| ------------------------------------------------------------------------------------------------------------------------------------ |
|
PHP- Connexion base //connexion à MySQL $db = mysql_connect("mysql5-2.bdb", "log", "pass"); mysql_select_db('base',$db) or die('Erreur de selection '.mysql_error()); |
| ------------------------------------------------------------------------------------------------------------------------------------ |
|
PHP- Variable et boucle $prime=array(); for($yy=10; $yy < 40; $yy++){ $prime[$yy]=$_POST['prime'.$yy.'']; } |
| ------------------------------------------------------------------------------------------------------------------------------------ |
|
PHP- Extraire données $sql = "SELECT * FROM nom-base where n>9 and active='$oui' ORDER BY nom desc limit 1"; $req = mysql_query($sql) or die('Erreur SQL !'.$sql.''.mysql_error()); while($data = mysql_fetch_assoc($req)) { $nom=$data['nnom']; } |
| ------------------------------------------------------------------------------------------------------------------------------------ |
|
HTML- Formulaire methode POST |