Reply to thread

Message

<blockquote data-quote="NSA" data-source="post: 175481" data-attributes="member: 10034">Hey guys,&nbsp;Doing a project for College and I need to be able to display information from a database.I currently have a profile.php page which set's some variables, send's them to another PHP file which acts as a CSS file. The problem I am having is, it doesn't update unless I &quot;refresh the page&quot;. If I go directly to the url profile.php?id=Josh it will still display for instance Anna's username from &quot;profile.php?id=anna&quot;. But when I refresh the new one, it updates to &quot;Josh&quot;.&nbsp;I am aware of security issues in my code, but it is just for a College project, so don't bawl on at me about security.&nbsp;Code:[CODE]&lt;?php$_SESSION['localhostrealname'] = &quot;&quot;;include(&quot;ban.php&quot;);session_start();$id = $_SESSION['localhostid'];$con = mysql_connect(&quot;localhost&quot;,&quot;root&quot;,&quot;&quot;);if (!$con)&nbsp; {&nbsp; die('Could not connect: ' . mysql_error());&nbsp; }&nbsp;mysql_select_db(&quot;vote&quot;, $con);&nbsp;$result = mysql_query(&quot;SELECT * FROM layout WHERE username='$id'&quot;);&nbsp;while($row = mysql_fetch_array($result))&nbsp; {&nbsp; $background = $row['background'];&nbsp; $profile_picture = $row['profile_picture'];&nbsp; $real_name = $row['real_name'];&nbsp; $_SESSION['localhostrealname'] = &quot;$real_name&quot;;&nbsp; }&nbsp;mysql_close($con);?&gt;&lt;link rel='stylesheet' type='text/css' href='back.php' /&gt;&lt;div id=&quot;profile_picture&quot;&gt;&nbsp;&lt;/div&gt;&lt;?php$id = $_GET['id'];$_SESSION['localhostid'] = &quot;$id&quot;;?&gt;&lt;span id=&quot;real_name&quot;&gt;&lt;?php echo $_SESSION['localhostrealname']; ?&gt;&lt;/span&gt;[/CODE]</blockquote>

[QUOTE="NSA, post: 175481, member: 10034"] Hey guys, Doing a project for College and I need to be able to display information from a database. I currently have a profile.php page which set's some variables, send's them to another PHP file which acts as a CSS file. The problem I am having is, it doesn't update unless I "refresh the page". If I go directly to the url profile.php?id=Josh it will still display for instance Anna's username from "profile.php?id=anna". But when I refresh the new one, it updates to "Josh". I am aware of security issues in my code, but it is just for a College project, so don't bawl on at me about security. Code: [CODE]<?php $_SESSION['localhostrealname'] = ""; include("ban.php"); session_start(); $id = $_SESSION['localhostid']; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("vote", $con); $result = mysql_query("SELECT * FROM layout WHERE username='$id'"); while($row = mysql_fetch_array($result)) { $background = $row['background']; $profile_picture = $row['profile_picture']; $real_name = $row['real_name']; $_SESSION['localhostrealname'] = "$real_name"; } mysql_close($con); ?> <link rel='stylesheet' type='text/css' href='back.php' /> <div id="profile_picture"> </div> <?php $id = $_GET['id']; $_SESSION['localhostid'] = "$id"; ?> <?php echo $_SESSION['localhostrealname']; ?>[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members