Pokušavam da nateram relativno jednostavan kod da radi ali ne prolazi.
ZAŠTO ?
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="test"; // Database name
$tbl_name="test_mysql"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Retrieve data from database
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<table width="400" border="1" cellspacing="0" cellpadding="3">
<?php
// Start looping rows in mysql database.
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td width="10%"><? echo $rows['id']; ?></td>
<td width="30%"><? echo $rows['name']; ?></td>
<td width="30%"><? echo $rows['lastname']; ?></td>
<td width="30%"><? echo $rows['email']; ?></td>
</tr>
<?php
// close while loop
}
</table>
?>
<?php
// close MySQL connection
mysql_close();
?>
Konekcija ka MySQL-u je u redu i gađa dobru tabelu
CREATE TABLE `test_mysql` (
`id` INT(4) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(65) NOT NULL DEFAULT '',
`lastname` VARCHAR(65) NOT NULL DEFAULT '',
`email` VARCHAR(65) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM
AUTO_INCREMENT=7;
A da. Javlja mi poruku:
"Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\x\Select.php on line 35"