HELP: PHP&MYSQL website problem

sam127 · May 13, 2010

Hi, i am designing an international website with different languages as button or flag. i have all my factlets in diff languages saved in database already, all i need now is a function that will load my selected language on the click button or flag to the front page,each time the button or flag is click, i wont corresponding language to language to load from database.

here is my code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

div.container{

width:100%;

background-color:#e7ffcd;}

div.header{

background-color:#700000;

font-size:1.5em;

padding:0.4em 1.5em 0.4em 1.5em;

border-style:outset;}

div.nav{

background-color:#600000;

width:8em;

min-height:51.5em;

em;

float:left;}

div.content{

background-color:#383838 ;

margin-left:8em;

min-height:50em;

padding:0.4em 1.5em 0.4em 1.5em;

border-style:inset;

line-height:150%;}

div.footer{

background-color:#700000;

clear:left;

padding:0.4em 1.5em 0.4em 1.5em;

border-style:outset;}

div.nav-button{

margin:5% 5% 5% 15%;}

div.nav-button-mark{

background-color:#ffaaaa;

margin:5% 0% 5% 15%;}

</style>

<title>Framework: DIV based</title>

</head>

</style>

<title>Framework: DIV based</title>

</head>

<body>

<html>

<head>

<title> PHP & MySQL </title>

</head>

<body>

ADAPTIVE INTERNATIONALISED WEBSITE

<marquee direction="left" height="26" scrolldelay="90" scrollamount="6" behavior="alternate" loop="0";" id="Marquee1"><font style="font-size:13px" color="#00FF00" face="Arial Black"><i>University Library in Chinese, Japanese, French and Afrikaans.</i></font></marquee>

<option type='selected' method='POST' name='$row[3]'>French</option>

<option type='selected' method='POST' name='$row[1]'>Chinese(simplified)</option>

<option type='selected' method='POST' name='$row[2]'>Japanese</option>

<option type='selected' method='POST' name='$row[0]'>English</option>

</select>

<?php

/**

* Just add this in your page where you

* want the date/time to appear

*

* For more configuration options look

* in the PHP manual at http://uk2.php.net/date

*/

// Displays in the format Saturday, November 22, 2003 11.38

echo date("l, F d, Y H:i " ,time());

?>

</font>

</div>

<!-- You may want to include the php echo $_SERVER['PHP_SELF'] so that one has the

full URL rather than leave it to the Browser to complete -->

<div class="nav-button"><a href='href='?page=page1'>gallery</a></div>

<div class="nav-button"><a href='?page=page2'>business</a></div>

<div class="nav-button"><a href='?page=page3'>contact us</a></div>

</div>

<?php

"../../group01.php" ;

$mysql_hostname="co-project.lboro.ac.uk";

$mysql_username="group05";

$mysql_password="gmp66env";

$link_id_resource=mysql_connect($mysql_hostname, $mysql_username, $mysql_password);

if($link_id_resource === false){exit("Cannot make connection to the MySQL server");}

mysql_query("SET NAMES 'utf8';", $link_id_resource); //utf8 stuff

// Selecting a MySQL database

$mysql_database="group05";

$database_selected=mysql_select_db($mysql_database,$link_id_resource);

mysql_query("SET NAMES 'utf8';", $link_id_resource); //utf8 stuff

echo '<h2>• UNIVERSITY LIBRARY •</h2>';

$sql_query = "SELECT Chinese FROM `Table`";

$result=mysql_query($sql_query);

while ($row=mysql_fetch_row($result)){

echo $row[0]."<br/>";

};

mysql_close($link_id_resource);

?>

</div>

</font>

</div>

</body>

</html>

urgent help needed as i need to submit it soon....thanks

andrewgauger · May 13, 2010

$sql_query = "SELECT Chinese FROM `Table`";

changes to:

$sql_query = "SELECT {$_GET['language']} FROM `Table`";

and you request the page using:

page.php?language=Chinese

You then need to build out the form (which you are missing). Just replace this:

<option type='selected' method='POST' name='$row[3]'>French</option>

<option type='selected' method='POST' name='$row[1]'>Chinese(simplified)</option>

<option type='selected' method='POST' name='$row[2]'>Japanese</option>

<option type='selected' method='POST' name='$row[0]'>English</option>

</select>

with:

<form action="page.php" method="get">
<select name="language" size="1" id="Combobox1"">
<option name='French'>French</option>
<option name='Chinese'>Chinese(simplified)</option>
<option name='Japanese'>Japanese</option>
<option name='English'>English</option>
</select>
<input type="submit" id="Button1" name="Button1" value="GO" style="postion:absolute;left:82px;width:35px;height:24px;font-family:Tahoma;font-size:13px;z-index:0">
</form>

Also, replace every instance of page.php with the name of your page. Verify that the entries in your MySQL match the languages I have hard coded.

Sign In

HELP: PHP&MYSQL website problem

Recommended Posts

sam127

Link to comment

Share on other sites

andrewgauger

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information