CREATE TABLE `tablename`
(
`id` int NOT NULL AUTO_INCREMENT,
`fieldname` varchar(300) CHARACTER SET utf8 collate utf8_general_ci ,
`fieldname` varchar(300) CHARACTER SET utf8 collate utf8_general_ci,
PRIMARY KEY (`id`)
)
<html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php
$query=mysql_connect("192.168.1.170","user","aipl2014");
mysql_select_db("test",$query);
mysql_query ("set character_set_results='utf8'");
$query = mysql_query("SELECT * FROM j") or die(mysql_error());
while($row=mysql_fetch_array($query))
{
echo $row['title']; // Article
echo $row['description']; // Description
}
?>
</html>
(
`id` int NOT NULL AUTO_INCREMENT,
`fieldname` varchar(300) CHARACTER SET utf8 collate utf8_general_ci ,
`fieldname` varchar(300) CHARACTER SET utf8 collate utf8_general_ci,
PRIMARY KEY (`id`)
)
<html>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php
$query=mysql_connect("192.168.1.170","user","aipl2014");
mysql_select_db("test",$query);
mysql_query ("set character_set_results='utf8'");
$query = mysql_query("SELECT * FROM j") or die(mysql_error());
while($row=mysql_fetch_array($query))
{
echo $row['title']; // Article
echo $row['description']; // Description
}
?>
</html>
No comments:
Post a Comment