14
« on: March 17, 2013, 01:49:10 am »
Hello. I wanna display data from database but there is nothing on the page. Take a look in the script. Btw i try with echo $id and nothing appends in browser.
user_profile.php
<?php
require 'core.inc.php';
require 'connect.inc.php';
require 'loginform.inc.php';
$id = $_SESSION['user_id'];
$query = "SELECT * FROM `users` WHERE `id` = '$id'";
$query_run = mysql_query($query);
WHILE($row = mysql_fetch_array($query_run)):
$ime = $row['ime'];
$prezime = $row['prezime'];
endwhile;
echo $id;
?>
loginform.inc.php
<?php
if (isset($_POST['username'])&&isset($_POST['password'])) {
$username = $_POST['username'];
$password = $_POST['password'];
$password_hash = md5($password);
if (!empty($username)&&!empty($password)) {
$query = "SELECT `id` FROM `users` WHERE `username` = '".mysql_real_escape_string($username)."' AND `password` = '".mysql_real_escape_string($password)."'";
if($query_run = mysql_query($query)){
$query_num_rows = mysql_num_rows($query_run);
if($query_num_rows==0){
echo 'invalid username/password combination';
}else if ($query_num_rows == 1){
$user_id = mysql_result($query, 0, 'id');
$_SESSION['user_id']=$user_id;
header('Location: user_profile.php');
}
}
}else{
echo "<p id='warning'>'Moras popuniti sva polja'</p>";
}
}
?>
[size=78%]core.inc.php[[/size][size=78%]/b][/size]
<?php
error_reporting(E_ALL ^ E_NOTICE);
ob_start();
session_start();
$current_file = $_SERVER['SCRIPT_NAME'];
$http_referer = $_SERVER['HTTP_REFERER'];
function loggedin() {
if(isset($_SESSION['user_id'])&&!empty($_SESSION['user_id'])){
return true;
}else{
return false;
}
}
function getuserfield($field){
$query = "SELECT `$field` FROM `users` WHERE `id`='".$_SESSION['user_id']."' ";
if($query_run=mysql_query($query)){
if ($query_result = mysql_result($query_run ,0 ,$field)){
return $query_result;
}
}
}
?>
Show Posts
