<?php SELECT * FROM table WHERE nom REGEXP '^A' ?>
<?php SELECT * FROM table WHERE nom LIKE 'A%'; ?>
1- <?php
2 - include_once ('../includes/_KB05_UZ.php');
3 - $sql = ('UPDATE actuel SET visible="0" WHERE id="'.$_GET['id_news'].'"');
4 - mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
5 - mysql_close($con);
6 - header('Location: index_non_visible.php');
7 - exit();
8 - ?>
<?php
include ('./includes/config.php');
$base = mysql_connect(MYSQL_SERVEUR, MYSQL_LOGIN, MYSQL_PASSWORD);
mysql_select_db(MYSQL_BASE, $base);
$sql = 'SELECT id, date, auteur, titre, news, visible FROM danews_news ORDER BY date DESC';
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
while ($data = mysql_fetch_array($req)) {
$titre=$data['titre'];
$date=$data['date'];
$auteur=$data['auteur'];
$news=$data['news'];
$news_id=$data['id'];
$news_visible=$data['visible'];
echo '<p>'.$data ['id'].'</p>';
echo '<p>'.$data ['date'].'</p>';
echo '<p>'.$data ['auteur'].'</p>';
echo '<p>'.$data ['titre'].'</p>';
echo '<p>'.nl2br($data ['news']).'</p>';
echo '<p>'.$data ['visible'].'</p>';
echo '<p></p>';
if ($news_visible == 0) {
$activation = '<a href="visible.php?visible=1&id_news='.$news_id.'"><img src="./images/off.png" border="0" alt="Rendre la news visible" /></a> <a href="#" onclick="if(confirm(\'Voulez-vous supprimer cette nouvelle ?\')) document.location.href=\'del_news.php?id='.$news_id.'\'"><img src="./images/del.gif" border="0" alt="Supprimer"></a> <a href="edit_news.php?id='.$news_id.'"><img src="./images/edit.gif" border="0" alt="Editer"></a>';
}
else {
$activation = '<a href="visible.php?visible=0&id_news='.$news_id.'"><img src="./images/on.png" border="0" alt="Rendre la news invisible" /></a> <a href="#" onclick="if(confirm(\'Voulez-vous supprimer cette nouvelle ?\')) document.location.href=\'del_news.php?id='.$news_id.'\'"><img src="./images/del.gif" border="0" alt="Supprimer"></a> <a href="edit_news.php?id='.$news_id.'"><img src="./images/edit.gif" border="0" alt="Editer"></a>';
}
echo '<span>'.$activation.'</span>';
echo '<br>';
}
mysql_free_result ($req);
mysql_close ($base);
?>
<form method="post" action="add_news_1.php">
<?php
print '
<p>Date<br />
<input type="text" id="date" name="date" size="15" maxlength="15" value="'.$_POST['date'].'"></p>
<p>Auteur<br />
<input type="text" id="auteur" name="auteur" maxlength="30" size="50" value="'.$_POST['auteur'].'"></p>
<p>Titre<br />
<input type="text" id="titre" name="titre" size="30" maxlength="250" value="'.$_POST['titre'].'"></p>
<p>News<br />
<textarea id="news" name="news" cols="60" rows="10">'.$_POST['news'].'</textarea></p>
<p>visible<br />
<input type="text" id="visible" name="visible" size="1" maxlength="1" value="'.$_POST['visible'].'"></p>';
?>
<p><input type="submit" name="go" value="Poster la news"></p>
<?php
include ('./includes/config.php');
$base = mysql_connect(MYSQL_SERVEUR, MYSQL_LOGIN, MYSQL_PASSWORD);
mysql_select_db(MYSQL_BASE, $base);
if (isset($_POST['go']) && $_POST['go']=='Poster la news') {
if (!isset($_POST['date']) || !isset($_POST['auteur']) || !isset($_POST['titre']) || !isset($_POST['news']) || !isset($_POST['visible'])) {
$erreur = 'Les variables nécessaires au script ne sont pas définies.';
}
else {
$sql = 'INSERT INTO danews_news VALUES("", "'.$_POST['date'].'", "'.$_POST['auteur'].'", "'.htmlentities($_POST['titre']).'", "'.$_POST['news'].'", "'.$_POST['visible'].'")';
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br />'.mysql_error());
mysql_close();
header('Location: index.php');
exit();
}
}
?>
<?php
if (isset($erreur)) echo '<br />',$erreur;
?>
<?php
include ('./includes/config.php');
$base = mysql_connect(MYSQL_SERVEUR, MYSQL_LOGIN, MYSQL_PASSWORD);
mysql_select_db(MYSQL_BASE, $base);
if (isset($_GET['id'])) {
$sql = ('SELECT id, date, auteur, titre, news, visible FROM danews_news WHERE id="'.$_GET['id'].'"');
$req = mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
$row = mysql_fetch_array($req);
print '<form method="post" action="edit_news_1.php?go=ok">
<table border="0" cellpadding="0" cellspacing="0" style="width: 40%"><col /><tbody>
<tr>
<td style="width: 50%">Date</td>
<td style="width: 50%"><input type="text" id="date" name="date" size="10" maxlength="10" value="'.$row['date'].'"></td>
</tr>
<tr>
<td style="width: 50%">Auteur</td>
<td style="width: 50%"><input type="text" id="auteur" name="auteur" size="10" maxlength="50" value="'.$row['auteur'].'"></td>
</tr>
<tr>
<td style="width: 50%">Titre</td>
<td style="width: 50%"><input type="text" id="titre" name="titre" size="20" maxlength="150" value="'.$row['titre'].'"></td>
</tr>
<tr>
<td style="width: 50%">News</td>
<td style="width: 50%"><textarea id="news" name="news" cols="80" rows="8">'.$row['news'].'</textarea></td>
</tr>
<tr>
<td style="width: 50%">Visible</td>
<td style="width: 50%"><input type="text" id="visible" name="visible" size="1" maxlength="1" value="'.$row['visible'].'"></td>
</tr>
<tr>
<td style="width: 50%">Save</td>
<td style="width: 50%"><input type="submit" value="Save" /></td>
</tr>
</tbody></table>
</form>';
}
mysql_free_result($req);
?>
<?php
include ('./includes/config.php');
$base = mysql_connect(MYSQL_SERVEUR, MYSQL_LOGIN, MYSQL_PASSWORD);
mysql_select_db(MYSQL_BASE, $base);
if (isset($_GET['id']) && !isset($_GET['go'])) {
$sql = ('UPDATE danews_news SET date="'.$_POST['date'].'", auteur="'.htmlentities($_POST['auteur']).'", titre="'.htmlentities($_POST['titre']).'", news="'.htmlentities($_POST['news']).'",
visible="'.$_POST['visible'].'" WHERE id="'.$_POST['id'].'"');
header('Location: index.php');
exit();
}
mysql_close($con);
?>
<?php
if (isset($erreur)) echo '<br />',$erreur;
?>
<?php
include ('./includes/config.php');
$base = mysql_connect(MYSQL_SERVEUR, MYSQL_LOGIN, MYSQL_PASSWORD);
mysql_select_db(MYSQL_BASE, $base);
if (isset($_GET['id_news'])) {
$sql=('UPDATE danews_news SET visible="1" WHERE id="'.$_GET['id_news'].'"');
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
}
header('Location: index.php');
exit();
?>
<?php
include ('./includes/config.php');
$base = mysql_connect(MYSQL_SERVEUR, MYSQL_LOGIN, MYSQL_PASSWORD);
mysql_select_db(MYSQL_BASE, $base);
if (isset($_GET['id'])) {
$sql=('UPDATE danews_news SET visible="0" WHERE id="'.$_GET['id_news'].'"');
mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
}
header('Location: index.php');
exit();
?>
<?php
include_once 'crud.class.php';
$crud = new crud();
$crud->dsn = "mysql:dbname=BASE-DONNEES;host=localhost";
$crud->username = 'USENAME';
$crud->password = 'PASSWORD';
$records = $crud->rawSelect('SELECT * FROM TABLE');
$rows = $records->fetchAll(PDO::FETCH_ASSOC);
foreach($rows as $row) {
//code pour affichage des données
print '
<span>'.$row['col_name'].'</span>
<span>'.$row['col_name'].'</span>
<span>'.$row['col_name'].'</span>
<span>'.$row['col_name'].'</span>
<span>'.$row['col_name'].'</span>
';
}
?>
<?php
include 'crud.class.php';
$crud = new crud();
$crud->dsn = "mysql:dbname=BASE DONNEES;host=localhost";
$crud->username = 'USERNAME';
$crud->password = 'PASSWORD';
$values = array(
array("col_name"=>"".$_POST['col_name']."", "col_name"=>"".$_POST['col_name'].""),
);
$crud->dbInsert('tbl_name', $values);
header('Location: index.php');
exit();
?>
<?php
$mysql_hostname = 'localhost';
$mysql_username = 'xxxxxxxxxxx';
$mysql_password = 'xxxxxxxxxxxxxxxx';
$mysql_dbname = 'xxxxxxxxxxxxxxxxxxxxxx';
$options = array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8');
try {
$dbh = new PDO("mysql:host=$mysql_hostname;dbname=$mysql_dbname", $mysql_username, $mysql_password);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
if (isset($_POST['titre']) && isset($_POST['menu']) && isset($_POST['sortie']) && isset($_POST['realisateur']) && isset($_POST['acteurs']) && isset($_POST['genre']) && isset($_POST['nationalite']) && isset($_POST['news']) && isset($_POST['casting']) && isset($_POST['visible'])) {
if (!empty($_POST['titre']) && !empty($_POST['menu']) && !empty($_POST['sortie']) && !empty($_POST['realisateur']) && !empty($_POST['acteurs'])&& !empty($_POST['genre']) && !empty($_POST['nationalite']) && !empty($_POST['news']) && !empty($_POST['casting']) && !empty($_POST['visible'])) {
$stmt = $dbh->prepare("INSERT INTO Science_fiction (titre, menu, sortie, realisateur, acteurs, genre, nationalite, news, casting, visible) VALUES (:titre, :menu, :sortie, :realisateur, :acteurs, :genre, :nationalite, :news, :casting, :visible)");
$stmt->bindParam(':titre', $_POST['titre']);
$stmt->bindParam(':menu', $_POST['menu']);
$stmt->bindParam(':sortie', $_POST['sortie']);
$stmt->bindParam(':realisateur', $_POST['realisateur']);
$stmt->bindParam(':acteurs', $_POST['acteurs']);
$stmt->bindParam(':genre', $_POST['genre']);
$stmt->bindParam(':nationalite', $_POST['nationalite']);
$stmt->bindParam(':news', $_POST['news']);
$stmt->bindParam(':casting', $_POST['casting']);
$stmt->bindParam(':visible', $_POST['visible']);
$stmt->execute();
echo 'Quote saved.';
header('Location: index.php');
exit();
}
else {
$message = 'Au moins un des champs est vide.';
}//if isset
}//empty
}//try
catch (PDOException $ex) {
echo 'Connection failed: ' . htmlspecialchars($ex->getMessage());
}//catch
?>
<?php
if (isset($message)) {
echo '<h1><center>'.$message.'</center></h1>';
}
?>
<?php
$mysqli = new mysqli("localhost","xxxxxxx","xxxxxxxxxxxxx","xxxxxxxxxxxxxxx");
$db->set_charset('UTF8');
if (mysqli_connect_errno()) {
printf("Echec de la connexion : %s\n", mysqli_connect_error());
exit();
}
$query = 'INSERT INTO Science_fiction VALUES("", "'.$_POST['titre'].'", "'.$_POST['menu'].'", "'.$_POST['sortie'].'", "'.$_POST['realisateur'].'", "'.$_POST['acteurs'].'", "'.$_POST['genre'].'", "'.$_POST['nationalite'].'", "'.$_POST['news'].'", "'.$_POST['visible'].'")';
$mysqli->query($query);
printf ("Le nouvel enregistrement a l'id %d.\n", $mysqli->insert_id);
$mysqli->close();
?>
<?php
include 'crud.class.php';
$crud = new crud();
include '../_require/videotheque_crud.php';
$values = array(
array("titre"=>"".$_POST['titre']."", "menu"=>"".$_POST['menu']."", "sortie"=>"".$_POST['sortie']."", "realisateur"=>"".$_POST['realisateur']."", "acteurs"=>"".$_POST['acteurs']."", "genre"=>"".$_POST['genre']."", "nationalite"=>"".$_POST['nationalite']."", "news"=>"".$_POST['news']."", "visible"=>"".$_POST['visible'].""),
);
$crud->dbInsert('films', $values);
?>
<?php
$con = mysqli_connect ('localhost', 'LOGIN', 'PASSWORD')
or die("Impossible de se connecter : " . mysqli_error());
mysqli_select_db ('BASE', $con);
$query = ("SELECT id, url, news, genre, visible FROM my_liens WHERE genre='bandeau' AND visible='1'");
if ($result = mysqli_query($con, $query)) {
while ($row = mysqli_fetch_row($result)) {
printf ('<ul><li><a href="%s" target="_blank">%s</a></li></ul>\',$row["url"], $row["news"]);
}
mysqli_free_result($result);
}
?>
<?php
$query = ("SELECT id, url, news, genre, visible FROM my_liens WHERE genre='PHP' AND visible='1'");
if ($result = mysqli_query($con, $query)) {
while ($row = mysqli_fetch_row($result)) {
printf ('<ul><li><a href="%s" target="_blank">%s</a></li></ul>\',$row["url"], $row["news"]);
}
mysqli_free_result($result);
}
?>
<?php
function caracteres($chaine){
$chaine = str_replace
(array('à','â','ä','æ','ç','è','é','ê','ë','î','ï','ô','ù','û','ü','Œ','œ','—','€','’','°','§','«','»','…','Æ','À','Â','Ç','È','É','Ê','Ë','Î','Ï','Ô','Ù','Ú','Û','Ü','’','€')
, array ( 'à'//à
, 'â'//â
, 'ä'//ä
, 'æ'//æ
, 'ç'//ç
, 'è'//è
, 'é'//é
, 'ê'//ê
, 'ë'//ë
, 'î'//î
, 'ï'//ï
, 'ô'//ô
, 'ù'//ù
, 'û'//û
, 'ü'//ü
, 'Œ'//Œ
, 'œ'//œ
, '—'//—
, '€'//€
, '''//’
, 'º'//°
, '§'//§
, '« '//«
, ' »'//»
, '…'//…
, 'Æ'//Æ
, 'A'//À
, 'A'//Â
, 'C'//Ç
, 'E'//È
, 'E'//É
, 'E'//Ê
, 'E'//Ë
, 'I'//Î
, 'I'//Ï
, 'O'//Ô
, 'U'//Ù
, 'U'//Ú
, 'U'//Û
, 'U'//Ü
, '’'//’
)
, $chaine
) ;
return $chaine;
}
?>
<?php
function caracteres($chaine){
$chaine = str_replace
(array('à','À','â','Â','æ','Æ','ç','Ç','é','É','ê','Ê','è','È','ë','Ë','í','Í','î','Î','ì','Ì','ï','Ï','ó','Ó','ô','Ô','ò','Ò','ö','Ö','œ','Œ','ú','Ú','û','Û','ù','Ù','ü','Ü','–','—','†','§','©','@','←','↑','→','↓','↔','•','«','»','…','’','°','º')
, array ('à'
, 'À'
, 'â'
, 'Â'
, 'æ'
, 'Æ'
, 'ç'
, 'Ç'
, 'é'
, 'É'
, 'ê'
, 'Ê'
, 'è'
, 'È'
, 'ë'
, 'Ë'
, 'í'
, 'Í'
, 'î'
, 'Î'
, 'ì'
, 'Ì'
, 'ï'
, 'Ï'
, 'ó'
, 'Ó'
, 'ô'
, 'Ô'
, 'ò'
, 'Ò'
, 'ö'
, 'Ö'
, 'œ'
, 'Œ'
, 'ú'
, 'Ú'
, 'û'
, 'Û'
, 'ù'
, 'Ù'
, 'ü'
, 'Ü'
, '–'
, '—'
, '†'
, '§'
, '©'
, '@'
, '←'
, '↑'
, '→'
, '↓'
, '↔'
, '•'
, '«'
, ' '
, ' '
, '»'
, '…'
, '’'
, '°'
, 'º'
)
, $chaine
) ;
return $chaine;
}
?>
<?php
$sql=('SELECT id, annee, mois, titre, menu, img, width, height, alt, title, auteur, news, visible FROM librairies WHERE genre="php" And type="mysql" ORDER BY ID ASC');
?>
Chargement en cours