PHP - Website Localization

Hello there,

I have a CMS which I've trying to create localization for. The idea is in the admin area you check a radio button and it changes the language of the entire admin interface. There is a mysql database with a table called nb_settings that has a column called lang. Up to this point I've gotten it to work but am having problems adding additional languages. The localization files have names like lang.nl.php,lang.en.php and so on..

The original code that works is this in a file called settings.php:

...
<?php
if($row['lang'] == nl)
{
echo '<input name="lang" type="radio" value="nl" checked="checked" /> '.($_CONSTANTS['NL']).'
<input name="lang" type="radio" value="en" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" /> '.($_CONSTANTS['DE']).'';
}
elseif($row['lang'] == en)
{
echo '<input name="lang" type="radio" value="nl" /> '.($_CONSTANTS['NL']).'
<input name="lang" type="radio" value="en" checked="checked" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" /> '.($_CONSTANTS['DE']).'';
}
elseif($row['lang'] == de)
{
echo '<input name="lang" type="radio" value="nl" /> '.($_CONSTANTS['NL']).'
<input name="lang" type="radio" value="en" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" checked="checked" /> '.($_CONSTANTS['DE']).'';
}
?>
...


Another file called common.php is used as well and has the following:


<?php
session_start();
header('Cache-control: private'); // IE 6 FIX

$sql = "SELECT * FROM nb_settings";
$query = mysql_query($sql);
$row = mysql_fetch_assoc($query);
                  
                        if($row['lang'] == nl) 
                        { 
                            include('languages/lang.nl.php'); 
                        } 
                        elseif($row['lang'] == en) 
                        { 
                            include('languages/lang.en.php'); 
                        } 
                        elseif($row['lang'] == de) 
                        { 
                            include('languages/lang.de.php'); 
                        } 
                     


?>


But I am havng trouble adding more languages and expanding this. There is a folder called languages into which I put the individual localization files.


Just adding similar lines of code as shown below in both common and settings files doesn't do it: ie:


1)modifying settings.php to become:


<?php 
 if($row['lang'] == nl) 
 { 
echo '<input name="lang" type="radio" value="nl" checked="checked" />  '.($_CONSTANTS['NL']).'
<input name="lang" type="radio" value="en" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" /> '.($_CONSTANTS['DE']).'
<input name="lang" type="radio" value="fra" /> '.($_CONSTANTS['FRA']).'';
 } 
 elseif($row['lang'] == en) 
 { 
 echo '<input name="lang" type="radio" value="nl" /> '.($_CONSTANTS['NL']).'
    <input name="lang" type="radio" value="en" checked="checked" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" /> '.($_CONSTANTS['DE']).'
<input name="lang" type="radio" value="fra" /> '.($_CONSTANTS['FRA']).''; 
 } 
 elseif($row['lang'] == de) 
 { 
 echo '<input name="lang" type="radio" value="nl" /> '.($_CONSTANTS['NL']).'
    <input name="lang" type="radio" value="en" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" checked="checked"  /> '.($_CONSTANTS['DE']).'
<input name="lang" type="radio" value="fra" /> '.($_CONSTANTS['FRA']).'';

 } 

 elseif($row['lang'] == fra) 
 { 
 echo '<input name="lang" type="radio" value="nl" /> '.($_CONSTANTS['NL']).'
    <input name="lang" type="radio" value="en" /> '.($_CONSTANTS['EN']).'
<input name="lang" type="radio" value="de" /> '.($_CONSTANTS['DE']).'
<input name="lang" type="radio" value="fra" checked="checked" />  '.($_CONSTANTS['FRA']).'';

 } 
?>



2)and adding in common.php:



elseif($row['lang'] == fra) 
                        { 
                            include('languages/lang.fra.php'); 
                        } 


Both don't work. The php is obviously not correctly parse and the syntax may have issues.
Can anyone help me out with how to add additional languages?

I'm trying to make a League of Legends (a video game) community website, both as a personal project and for practice.
Now the game has a lot of champions, each of whom have 5 unique abilities. Now, I thought about manually inputting all the details about each champion into a MySQL database, but that would long and tedious, and I don't really have the time for it now. Also, the game patches very oftern (like, once every 2 weeks) which changes many of the stats, etc. of the champion, and it is not possible for me to keep manually updating these every time there is a patch.

Fortunately, there is a League of Legends Wiki which has all the data I need in their specific champion pages, which they keep updated per patch. So I was wondering if there was any way to get the data from the divs in the wiki, and have it display on my site. What I want to do in my website is that whenever someone types a champion's name (in a post or whatever), I want it to display a hover-over dialog with some of the champions details. And a lot of other features such as that.

In plain English I need a way to :
> Tell PHP to go to the wiki's source code on a specific page
> Find a specific div container
> Get X data from there
> Pass X data into a function to display the hover-over

I think this way, I would not have to maintain a database as I can leech off the wiki's data.
I have not coded anything like this before, so I would like a few pointers as to how to achieve this. Any help will be appreciated!

I tried searching on google but couldn't find any relevant information, please redirect me to relevant source or help me with the code.

I want to pass a domain name in text field which will be scanned and then the script will display entire site map.

Not external links or links on a page. Sorry it is not easy for me to explain.

Eg. if i pass abc.com

Script will display

abc.com/12/adn.php
abc.com/asd/asd/
etc

Whatever their url format is.

All the links on that domain.

hello
My database is in a same server with seperate domain name , then I want to insert from website1 mysql data on website2 mysql data.
can anyone help me?

Is it possible to download files from a website to my online websites root directory? reason I'm asking is because I have been downloading large video files to my computer which take about 20 minutes!! Then I use FTP to upload them to my site but it takes about 2-3 hours per video!! I was looking for a faster way! All help would be great!