Here's a code:
<?php
require_once('./includes/connection.inc.php');
session_start();
// create database connection
$connread = dbConnect('read', 'pdo');
$connwrite = dbConnect('write', 'pdo');
$komentari = 'SELECT * FROM komentariodobreni ORDER by komentarodobren_id DESC';
$kontakt = 'SELECT poruka_id, ime, prezime, email, predmet, ordinacija, poruka, DATE_FORMAT(datum, "%H:%i:%s %d. %b. %Y")
AS datum FROM kontakt ORDER by poruka_id DESC';
if (isset($_POST['slanje'])) {
$potvrdiquery = "SELECT * FROM kontrola WHERE adminname='" . $_POST["adminname"] . "' and adminpassword = '". $_POST["adminpassword"]."'";
$stmt = $connwrite->prepare($potvrdiquery )
;
// bind the parameters and execute the statement
// execute and get number of affected rows
$stmt->execute();
$OK = $stmt->rowCount();
foreach ($connread->query($potvrdiquery) as $row) {
$_SESSION['adminid'] = $row['adminid'];
$_SESSION["adminname"] = $row["adminname"];
$_SESSION["adminpassword"] = $row["adminpassword"];
}
header('Location: index.php');
}
?>
It works perfectly on my local, but when I upload it to Ipage or some other server it doesn't register session variables.