Mailing List Archive

   tlug.jp -> Mailing List -> tlug archive -> tlug Mailing List Archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [tlug] OT-Japanese in PHP

Hi All,

ok, I recompiled php to support J. Below are my settings,

output_handler = mb_output_handler
mbstring.language = Japanese
mbstring.internal_encoding = UTF-8
mbstring.http_input = auto
mbstring.http_output = SJIS
mbstring.encoding_translation = On
mbstring.detect_order = auto
mbstring.substitute_character = none
mbstring.internal_encoding = EUC-JP

Now, I think I still haven't got the page that requires J, displayed 
right, yet. Full code is below. Can anyone see any mistakes..? Cheers.

Mark Sargent.

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; 
charset=Shift-JIS" />
<title>Jumbo Status-Product Details</title>
</head>
<body lang="ja">
<hr>
<h1 align="center">JUMBO STATUS</h1><p>
<center>Used Hardware Specialist</center>
<center><a href="index.php">Home</a></center>     <center><a 
href="search.php">Search</a></center>
<hr>
<table align="center" bgcolor="lightblue" cellpadding="2" border="2" 
width="60%">
<?php
$db = mysql_connect("localhost", "????", "?????");
if (!$db) {
  echo "no connection because " . mysql_error();
  exit;
}
mysql_select_db("status", $db);
if (isset($_REQUEST[product_id])) {
   $product_id = $_REQUEST[product_id];
$result = mysql_query("SELECT Products.product_id, 
Products.product_name, Products.product_model_number, 
Products.product_price, Products.product_qty, Products.product_desc, 
Products.product_data_output, Conditions.condition_detail FROM Products 
INNER JOIN Conditions On Products.condition_id = Conditions.condition_id 
WHERE Products.product_id = '$product_id'");
if (!$result) {
    echo "Query failed: " . mysql_error();
  exit;
}
$num = mysql_num_rows($result);
$rows = mysql_fetch_array($result);
echo "<tr align=�"center�"><td colspan=�"4�">Status-Product 
Details</td></tr>";
}
for ($i=0; $i<$num; $i++){
echo "<tr align=�"center�"><td>PRODUCT 
NAME</td><td>".$rows['product_name']."</td><br><tr 
align=�"center�"><td>QUANTITY</td><td>".$rows['product_qty']."</td></tr><br><tr 
align=�"center�"><td>PRICE</td><td>".$rows['product_price 
yen']."</td></tr><br><tr 
align=�"center�"><td>CONDITION</td><td>".$rows['product_condition']."</td></tr><tr 
align=�"center�"><td colspan=�"2�">MORE DETAILS</td></tr><tr 
align=�"center�"><td 
colspan=�"2�">".$rows['product_desc']."</td></tr><tr 
align=�"center�"><td colspan=�"2�">DATA OUTPUT</td></tr><tr 
align=�"center�"><td  colspan=�"2�"><font 
type=�"Shift_JIS�">".$rows['product_data_output']."</font></td></tr>";
}
?>
</table>
<p>
<p>
<p>
<hr><center>email: status1@???????<p>
Telephone: ???????<p>
Fax: ????????
</center>
</body>
</html>
Home | Main Index | Thread Index

Home Page Mailing List Linux and Japan TLUG Members Links