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> Quote 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 Quote 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"; Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.