PHP bdConnect示例

示例#1

文件： landing-page.php 项目： kochira/competstrat

function insert($mail)
{
    $connexion = bdConnect();
    $insert = $connexion->prepare("INSERT INTO newsletter(mail) VALUES(?)");
    $insert->execute(array($mail));
    $select = $connexion->prepare("select * FROM newsletter WHERE mail = ?");
    $select->execute(array($mail));
    $data = $select->fetch();
    return $data;
}

示例#2

文件： Inscription.php 项目： jordanreouven/udpm

$ligne = $resultat->fetch();
if ($ligne['Login'] == $Login) {
    $ConfLogin = false;
    $erreur = 1;
} else {
    $ConfLogin = true;
}
/*--------------------------------------- Fin de block ---------------------------------------*/
/*--------------------------------------------------------------------------------------------*/
/*--------------------------------------------------------------------------------------------*/
/*----- Ajout de l'utilisateur dans la base de donnée --------*/
/*--------------------------------------------------------------------------------------------*/
if ($_SESSION['email'] == true && $_SESSION['password'] && $AgeConf == true && $ConfLogin == true) {
    $varSql = "Insert into user (Firstname, Surname, Email, Birthday, Login, Password) values ('{$Prenom}', '{$Nom}', '{$Email}', '{$DateDeNaissance}', '{$Login}', '{$Passwd}')";
    //echo $varSql;
    bdConnect($varSql, "insert");
    mkdir("utilisateur/" . $Login);
    mkdir("utilisateur/" . $Login . "/Music");
    mkdir("utilisateur/" . $Login . "/Img");
    mkdir("utilisateur/" . $Login . "/Img/ImgMusic");
    mkdir("utilisateur/" . $Login . "/Img/ImgProfil");
    header('Location:index.php');
}
/*--------------------------------------- Fin de block ---------------------------------------*/
/*--------------------------------------------------------------------------------------------*/
?>
<div class="page">
    <div class="header">
        <nav>
            <ul>
                <li style="color:#b47f2a;font-size: 36pt;"><a href="index.php" style="text-decoration:none;color:#b47f2a;position:relative;top:30px;left:10px;">UD&amp;PM</a></li>

示例#3

文件： Upload.php 项目： alessipala/udpm

}
if (!empty($_FILES)) {
    foreach ($_FILES['files']['name'] as $f) {
        echo $_FILES['files']['name'][$f];
        /*$Extension = strtolower(substr($_FILES['files']['name'][$f],-4));
          if($Extension==".jpg")$Extension="jpg";
          if($Extension==".gif")$Extension="gif";
          if($Extension==".png")$Extension="png";
          $ExtensionAutoriserPhoto= array("jpeg","jpg","png");
          $ExtensionAutoriserMusic= array("mp3","ogg","flac","wav");
          if(in_array($Extension,$ExtensionAutoriserPhoto)){
              move_uploaded_file($_FILES['files']['tmp_name'][$f],$DestinationImg.$_FILES['files']['name'][$f]);
              $NomPhoto=$_FILES['files']['tmp_name'][$f];
          }
          else if(in_array($Extension,$ExtensionAutoriserMusic)){
              move_uploaded_file($_FILES['files']['tmp_name'][$f],$DestinationMusic.$_FILES['files']['name'][$f]);
          }
          else{
              $erreur = "Votre fichier n'est pas une image ou une musique.";   
          }*/
    }
    /*------------------------------------------------ Insère dans la base de données le nom de la musique------------------------------------------------------*/
    $requete = "INSERT INTO music (`Name`,`Artist`,`Featuring`,`AlbumName`,`SingleName`,`NameOfPicture`) VALUES('{$NomMusic}','{$NomArtist}','{$Featuring}','{$NomAlbum}','{$SingleName}','{$NomPhoto}')";
    //echo $requete;
    bdConnect($requete, 'insert');
    /*----------------------------------------------------------------------------------------------------------------------------------------------------------*/
    /*----------------------------------------------------------------------------------------------------------------------------------------------------------*/
}
?>

示例#4

文件： index.php 项目： xyaa/DaWeather---Project

<?php

// DEPANDANCES :
require "bdd.php";
// TRAITEMENTS :
// connexion à la base de données :
bdConnect();
// récupération de la configuration :
$req = $GLOBALS['DB']->prepare("SELECT email, private_key, nom, lieu, altitude, date_installation FROM station WHERE idStation='1'");
$req->execute();
$params = $req->fetch();
// déconnexion de la base de données :
bdDisconnect();
?>
<!doctype html>
<html lang="fr">
	<head>
		<meta charset="utf-8">
		<title>DaWeather</title>
		<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1" />

		<link href='http://fonts.googleapis.com/css?family=Raleway:500,600,700,400,200,300' rel='stylesheet' type='text/css'>
		<link href='http://fonts.googleapis.com/css?family=Lato&subset=latin,latin-ext' rel='stylesheet' type='text/css'>
		<link rel="stylesheet" href="assets/styles/font-awesome.min.css">
		<link rel="stylesheet" href="assets/styles/animate.css">
		<link rel="stylesheet" href="assets/styles/style.css">
		<link rel="shortcut icon" href="assets/images/icon.ico">
	</head>

	<body>
		<noscript><div id="noJS" class="fullscreen green">

示例#5

文件： Accueil.php 项目： jordanreouven/udpm

                <p>Top Musique</p>
                <?php 
$requete = "SELECT * FROM `music` ORDER BY `Like` DESC LIMIT 5 ";
$resultat = bdConnect($requete, 'select');
while ($ligne = $resultat->fetch()) {
    echo "<div style=' width:200px; height:150px; float:left;'align=center>";
    echo $ligne['NameOfMusic'];
    echo "</div>";
}
?>
            </div>
            <div id="TopArtiste">
                <p>Top Artiste</p>
                <?php 
$requete = "SELECT * FROM `artist` ORDER BY `Like` DESC LIMIT 5 ";
$resultat = bdConnect($requete, 'select');
while ($ligne = $resultat->fetch()) {
    echo "<div style=' width:200px; height:150px; background-color:white; float:left;'align=center>";
    echo $ligne['NameArtist'];
    echo "</div>";
}
?>
            </div>
        </div>
    </div>
    <div id="Upload" hidden>
        <div id="EffetFondNoir">
            <?php 
include "pages/Upload.php";
?>
        </div>

示例#6

文件： Profil.php 项目： alessipala/udpm

        //ouvre le répértoir de l'utilisateur
        while (false !== ($fichier = readdir($dossier))) {
            // vérifie que le répértoire existe et lis le contenu
            $nb_fichier++;
            // On incrémente le compteur de 1
        }
    }
    // si le compteur est égal a 2 l'utilisateur aura une photo de profil par defaut dans le cas contraire l'utilisateur aura une photo de profil qu'il a choisi
    if ($nb_fichier == 2) {
        $chemin = "utilisateur/Defaut.png";
    } else {
        $chemin = "utilisateur/{$NomUtilisateur}/Img/ImgProfil/profil.png";
    }
    closedir($dossier);
    $requete = "SELECT * from user where Login='******'";
    $resultat = bdConnect($requete, "select");
    while ($ligne = $resultat->fetch()) {
        $prenom = $ligne['Firstname'];
        $nom = $ligne['Surname'];
        $texte = $ligne['Biographie'];
    }
    ?>


<div class="page">
    
        <div class="header">
            <?php 
    include "Include/MenuHeader.php";
    ?>
        </div>

示例#7

文件： functions.php 项目： atta-agency/competstrat

function insert($prenom, $nom, $mail, $pre_co)
{
    $connexion = bdConnect();
    $insert = $connexion->prepare("INSERT INTO club(prenom,nom,email,pre_co) VALUES(?,?,?,?)");
    $insert->execute(array($prenom, $nom, $mail, $pre_co));
    $select = $connexion->prepare("select * FROM club WHERE email = ?");
    $select->execute(array($mail));
    $data = $select->fetch();
    return $data;
}