TheSky Posted April 3, 2011 Share Posted April 3, 2011 i want to get NR from database how i should make it any help will be welcome <? session_start(); if (empty($_SESSION['username'])){ header("location:login.php"); exit; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Esileht</title> <?php include 'metainfo.js';?> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <? include "fns.php"; $action=$_GET['action']; if($action=="change"){ changepw($_SESSION['username']); update($newpass,$_SESSION['username']); }else{ } ?> </p> <table width="200" border="0"> <tr> <td>Sisse logitud</td> <td><? echo $_SESSION['username'];?></td> </tr> <tr> <td>Kuna tulid</td> <td><? echo $_SESSION['time'];?></td> </tr> <tr> <td>Telefon</td> <td><? echo $_SESSION['NR'];?></td> </tr> <tr> <td> </td> <td> </td> </tr> <tr> <td><a href="logout.php">Logi välja</a></td> <td><? echo '<a href="' .$_SERVER['PHP_SELF']. '?action=change">Vaheta parool</a>';?></td> </tr> </table> <p> </p> </div> </body> </html> Link to comment https://forums.phpfreaks.com/topic/232572-how-to-get-value-in-database-by-id/ Share on other sites More sharing options...
TheSky Posted April 3, 2011 Author Share Posted April 3, 2011 So i try explane how well i can // Query to select an int column include('config.php'); $query="select uname from user where id = 1"; $result = mysql_query($query); $array = mysql_fetch_assoc($result); $test = gettype($array['id']); //put in session vars $_SESSION['id'] = $test; so on index i have <? echo $_SESSION['id'];?> im kinda tired it's 2.00 AM Link to comment https://forums.phpfreaks.com/topic/232572-how-to-get-value-in-database-by-id/#findComment-1196398 Share on other sites More sharing options...
blacknight Posted April 4, 2011 Share Posted April 4, 2011 $query="select uname, id from user where id = 1"; Link to comment https://forums.phpfreaks.com/topic/232572-how-to-get-value-in-database-by-id/#findComment-1196417 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.