marco
30dbf40af8
Aggiunta prima versione procedure per approvare e inserire post o rifiutare la pubblicazione
23 lines
689 B
PHP
23 lines
689 B
PHP
<?php
|
|
$username="root";
|
|
$password="vpsad24068";
|
|
$hostname = "localhost";
|
|
//connection string with database
|
|
$dbhandle = mysqli_connect($hostname, $username, $password)
|
|
or die("Unable to connect to MySQL");
|
|
//echo 'Hello ' . htmlspecialchars($_GET["email"]) . htmlspecialchars($_GET["doi"]) . '!';
|
|
$doi = htmlspecialchars($_GET["doi"]);
|
|
$email = htmlspecialchars($_GET["email"]);
|
|
echo $email;
|
|
$selected = mysqli_select_db($dbhandle, "wptest")
|
|
or die("Could not select DB");
|
|
$query = "UPDATE wp_articoli SET veto = 1, wp_articoli.emailVeto = '$email'
|
|
WHERE wp_articoli.doi = '$doi'";
|
|
echo $query;
|
|
$res3 = mysqli_query($dbhandle,$query);
|
|
mysqli_close($dbhandle);
|
|
|
|
?>
|
|
|
|
|