Geek Answers Handbook

Using php and mysql to display a specific url in iFrame V2

I am new to SQL and PHP and need help with the solution below.

I have an SQL database with, for example, "username, password, nationality, class", what I want to do is a simple PHP or SQL query that will check the user class field from the database and display the corresponding URL in the designated iFrame (for example, classes J1, J2, J3, if the field already contains J3, then when loading it displays the corresponding URL for this without user input (everything will be determined in advance)

You can think of it as a student profile, after the student successfully logs in, the request reads the class field and, according to what he finds, he will return a URL suitable for clicks with the correct link.

This is too difficult for the level at which I am now, hopefully someone can shed light on me.

this is the code after a successful user login.

<!-- NOTIFICATIONS STARTS HERE -->
<?php
require_once('connection.php');
$id=$_SESSION['SESS_MEMBER_ID'];
$result3 = mysql_query("SELECT * FROM member where mem_id='$id'");
while($row3 = mysql_fetch_array($result3))
{ 
$fname=$row3['fname'];
$country=$row3['country'];
$class=$row3['class'];
$headteacher=$row3['headteacher'];
$attendance=$row3['attendance'];
$homework=$row3['homework'];
$messageparents=$row3['messagestudent'];
}
?>
<table width="468" border="0" align="center" cellpadding="0">
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS">
<table width="468" border="0" align="center" cellpadding="0">
<tr>
<td class="FONTS"><div align="left" class="FONTS"><b>名前:</b></div>
<?php echo $fname ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>国:</b></div>
<?php echo $country ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>クラス:</b></div>
<?php echo $class ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>家庭教師の先生:</b></div>
<?php echo $headteacher ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>出席率:</b></div>
<?php echo $attendance ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>宿題率:</b></div>
<?php echo $homework ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>先生からメッセージ:</b>            
</div>
<?php echo $messagestudent ?></td>
</tr>
</table>
</div></td>
</tr>
</table>
<p align="center" class="FONTS"><a href="index.php">ログアウト</a></p>
<!-- NOTIFICATIONS ENDS HERE -->

it already works as intended, so I won’t change it if it’s not completely needed, I just have to be able to display this URL link.

early!

+4
source share
3 answers
<?php
if($class=='J1')
echo "<a href='www.first_url.com'>Click Here</a>";
else if($class=='J2')
echo "<a href='www.second_url.com'>Click Here</a>"; 
..............
?>
+1
source

You use this line of code on your page

$id=$_SESSION['SESS_MEMBER_ID'];

Your code doesn't work because you forgot start sessionat the top of the page

start_session();// at the top of your page
0
source

You must use PDO or MYSQLi_ *, mysql_ is deprecated and is vunerable.

<?php
start_session();

require_once('connection.php');

$id=$_SESSION['SESS_MEMBER_ID'];

$mysqli = new mysqli("myhost","myuser","mypassw","mybd");

if (mysqli_connect_errno()) {

printf("Connect failed: %s\n", mysqli_connect_error());

exit();

}

$result3 = $mysqli->query("SELECT * FROM member WHERE mem_id='$id'");

while($row3 = mysqli_fetch_array($result3))
{ 
  $fname=$row3['fname'];
  $country=$row3['country'];

if($row3['class'] == "J1"){

    $class='<a href="your link here">Your link info here</a>';

} elseif($row3['class'] == "J2") {

    $class='<a href="your link here">Your link info here</a>';

} elseif($row3['class'] == "J3") {

    $class='<a href="your link here">Your link info here</a>';

}else {

    $class='<a href="your link here">Your link info here</a>';

}
$headteacher=$row3['headteacher'];
$attendance=$row3['attendance'];
$homework=$row3['homework'];
$messageparents=$row3['messagestudent'];
}
?>
<table width="468" border="0" align="center" cellpadding="0">
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS">
<table width="468" border="0" align="center" cellpadding="0">
<tr>
<td class="FONTS"><div align="left" class="FONTS"><b>名前:</b></div>
<?php echo $fname ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>国:</b></div>
<?php echo $country ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>クラス:</b></div>
<?php echo $class ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>家庭教師の先生:</b></div>
<?php echo $headteacher ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>出席率:</b></div>
<?php echo $attendance ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>宿題率:</b></div>
<?php echo $homework ?></td>
</tr>
<tr class="FONTS">
<td valign="top"><div align="left" class="FONTS"><b>先生からメッセージ:</b>            
</div>
<?php echo $messagestudent ?></td>
</tr>
</table>
</div></td>
</tr>
</table>
<p align="center" class="FONTS"><a href="index.php">ログアウト</a></p>
<?php
mysqli_close($mysqli);
?>
0
source

More articles:


All Articles