HTML table displays PHP source code and not data from variables

Question

my html table is expected to display variables from mysql table using php , but the table rather displays the raw codes in its cells and not the variables

Below is the diagram of the table: table displays codes

<?php
$host="localhost"; // Host name 
$username="root"; // Mysql username 
$password=""; // Mysql password 
$db_name="test"; // Database name 
$tbl_name="test_mysql"; // Table name 
$server_name="localhost";


// Create connection
$con = new mysqli($server_name, $username, $password, $db_name , 3306);

if ($con->connect_error) {
    die("Connection failed: " . $con->connect_error);
}  

// get value of id that sent from address bar
$id=$_GET['id'];

// Retrieve data from database 
$sql="SELECT * FROM $tbl_name WHERE id='$id'";

$result = $con->query($sql);

$rows = $result->fetch_assoc();          

?>

<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<form name="form1" method="post" action="update_ac.php">
<td>
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>&nbsp;</td>
<td colspan="3"><strong>Update data in mysql</strong> </td>
</tr>
<tr>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
<td align="center">&nbsp;</td>
</tr>
<tr>
<td align="center">&nbsp;</td>
<td align="center"><strong>Name</strong></td>
<td align="center"><strong>Lastname</strong></td>
<td align="center"><strong>Email</strong></td>
</tr>
<tr>
<td>&nbsp;</td>
<td align="center">
<input name="name" type="text" id="name" value="<? echo $rows['name']; ?>">
</td>
<td align="center">
<input name="lastname" type="text" id="lastname" value="<? echo $rows['lastname']; ?>" size="15">
</td>
<td>
<input name="email" type="text" id="email" value="<? echo $rows['email']; ?>" size="15">
</td>
</tr>
<tr>
<td>&nbsp;</td>
<td>
<input name="id" type="hidden" id="id" value="<? echo $rows['id']; ?>">
</td>
<td align="center">
<input type="submit" name="Submit" value="Submit">
</td>
<td>&nbsp;</td>
</tr>
</table>
</td>
</form>
</tr>
</table>

<?php
// close connection 
$con->close();
?>

you are missing an `=` sign which is for the echo part. `=`. But better to use ` — roullie, Jul 14 '15 at 01:59

score 1 · Answer 1 · answered Jul 14 '15 at 01:53

1

Try use <?php echo $rows['id']; ?>

answered Jul 14 '15 at 01:53

Mohamad Arafat

553
1
5
22

@Mohamed can you please explain further your suggestions – faisal abdulai Jul 14 '15 at 01:57
Your double quotes mess it up – Drew Jul 14 '15 at 01:58
The php is missing. Try put php after Eg. – Mohamad Arafat Jul 14 '15 at 02:06

score 1 · Accepted Answer · answered Jul 14 '15 at 02:08

1

All the php versions do not support this short cut <?= so at the server where you are executing this code you need to replace <? with <?php.

answered Jul 14 '15 at 02:08

Sourabh Kumar Sharma

2,804
3
21
32

score 0 · Answer 3 · answered Jul 14 '15 at 02:04

It seems that you are missing the php tag

If you are using a PHP version earlier than 5.4, you should use

<?php echo ... ?>

If using PHP 5.4 or earlier, you can print by using

<?= ?>

You can find more information here: http://php.net/manual/en/language.basic-syntax.phptags.php

HTML table displays PHP source code and not data from variables

3 Answers3