PHP - Is Php The Best Option For Changing Languages On A Page?

Hi guys.

This is my first post here - so HELLO.

I am a very experienced software developer, but new to web work. I am building a software tool using PHP (primarily). As such, many of my questions will concern optimum solutions (in so far as they may be determined), best practices, and the unwritten standards that will surely have evolved through the PHP community over time.

My first question concerns the mixing of HTML and PHP. My efforts so far contain a mix, but it doesn't "feel" right. I am using straight XHTML, PHP echo, and also heredoc. I can post the code if folk think it may help. But what is the general view as to whether "mixing" like this is a good and accepted practice, or is another approach preferred?

Many thanks in advance for any replies.

S

The first thing I learned after HTML and CSS is PHP. Its my primary language now, but I also use SQL and javascript and XML regularly, and since I use linux, I use bash scripting. The cool thing is they all work hand in hand. I recently learned how to use SQLite too, which is good because it can be accessed directly by javascript. Are there any other languages which would enable me to make new things and combine them with PHP scripts? I was looking into java but the security restrictions on applets make it pointless. Flash actionscript looks good. What about perl? Or ruby? Would they enable me to do things I can't easily do with PHP? I've heard about node.js recently a lot so I'm looking into that. Bash scripting is great, but the only issue is I could only use it on a server owned by myself, commercial servers won't let you execute commands like that. I'm interested in perl, python and java but I'll only learn them if they enable me to do things I can't do (easily) with PHP.

Hi,   I am looking for a tutorial or code sample I can use to learn MySQLi pagination with an option to select items per page, like the attached screenshort.   Any help is grately appreciated.   Regards.   joseph Attached Files  table-pagination.jpg   32.87KB   0 downloads

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 developing an arabic site...but also want to view it in English...I'm thinking of using windows translating service (depending on good it is).

Now I was thinking of having columns in my table like so...english title, arabic title, english description, arabic description

As it can charge for words to be translated...when translating arabic to english I can store the results in the column so they would no longer have to be translated again

My question is...is it good practice to have separate columns for different languages?...thank you...any input would be great

I have a time and date using the code

echo date("l jS \of F Y H:i:s.");

Now I need to show this in several different languages, including French German and Dutch

I have tried setlocale();
and echo strftime

The date shows but still in English.
Any idea how to show the day date and time in Php for the languages suggested.

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=307346.0

Hi everyone this is my first post so I'm sorry if I've posted it in the wrong section!

Before I begin I'd like to point out that I'm not just here to get someone to produce what I want for me! I have a genuine interest in this forum and I'm slightly surprised and disappointed in myself that I hadn't took the time to join sooner!

Anyway to the point of this post: (Please bare with me I think I'll need to justify the use of SQLite)

I am currently undergoing a University gorup project that uses wireless sensors to collect environmental data such as, Temperature, Humidity, Light levels and Dew point. This application is programmed in Python and it collects these pieces of data (every 30 seconds) and places them into an SQLite database.

My job is to now graphically plot/show the data that the Python program collects and stores in the SQLite database on a web page. I'm using Ubuntu and have successfully installed LAMP, SQLite3 and the SQLite PD0 driver.

I have also successfully established a connection to the SQLite database as well as displaying the data on a web page (locally - thats all I need!) in the form of a simple HTML table through the use of the following PHP script:

Code: [Select]
<?php
  try
  {
    //open the database
    $db = new PDO('sqlite:/var/databases/307Code/python/readings.db');

    //now output the data to a simple html table...
    print "<table border=1>";
    print "<tr><td>Date & Time Recieved</td><td>Node</td><td>Temp</td><td>Hum</td><td>Light</td><td>Dew</td></tr>";
    $result = $db->query('SELECT * FROM readingstable');
    foreach($result as $row)
    {


      print "<tr><td>".$row['Recieved']."</td>";
      print "<td>".$row['Node']."</td>";
      print "<td>".$row['Temp']."</td>";
      print "<td>".$row['Hum']."</td>";
      print "<td>".$row['Light']."</td>";
      print "<td>".$row['Dew']."</td></tr>";
    }
    print "</table>";

    // close the database connection
    $db = NULL;
  }
  catch(PDOException $e)
  {
    print 'Exception : '.$e->getMessage();
  }
?>
What I'm now looking to do is the following:

1. Display the data from the SQLite database in the form of line graphs (I've seen that I may need to convert the data to XML?)
2. Make the application asynchronous, preferably every time a new entry is added to the SQLite database the line graph(s) update without a user needing to refresh the browser.
3. The SQLite database is storing a ridiculous floating point number for the time field in the database, for example: "2012-03-23 16:49:42.440818" is a entry in the SQLite database. Is there any way to omit the .440818 through the use of PHP? Or will I need to edit the Python script?

Also one thing to note: The person in my group who built the Python script didn't build it to make the SQLite database give each database entry a unique ID/Primary key.

Any tips/advice/help would be massively appreciated!

Regards,

Rich

I am using PHP for CV Generator. I need to add an element for 'Add another' option, e.g. on employment section, if you have more than one job you may require to add another form.

Would this work with PHP coding? If so, what is it called? If not so, maybe Javascript? I can google for it when I get a answer from you guys.

By the way, you may be aware with this- I have a little experience with PHP coding. 

Dean

Do I need to add value to this select statement?

Code: [Select]

<select id="expYear" name="expYear">
<option></option>
<option>2011</option>
<option>2012</option>
<option>2013</option>
<option>2014</option>
<option>2015</option>
<option>2016</option>
<option>2017</option>
<option>2018</option>
<option>2019</option>
<option>2020</option>
</select>



Debbie

I'm having the strangest thing happing.
When posting a form i'm not getting the option value. Instead its posting my text field

ie: <option name="1">text</option>

Code: [Select]
<?php
$query  = "SELECT id, name FROM locations ORDER BY name";
$res = mysql_query($query, $cid);
while($a = mysql_fetch_array($res)) {
echo "<option name=".$a["id"].">".$a["name"]."</option>";
}
 ?>

Code: [Select]
<?php
The code thats grapping it:
if($_POST['location']==""){
   $location = "";
   echo '<div class="message error">Please enter a <strong>Location</strong></div>';
 }else{
   $location = $_POST['location'];
 }
?>

Can anyone see why? I have also tried it in html to see if its my php, but i get the same result

how would i render this

Code: [Select]
<select name="state" value="<?php echo $state; ?>">
<option>Select a state</option>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AZ">Arizona</option>
<option value="AR">Arkansas</option>   
<option value="CA">California</option>   
<option value="CO">Colorado</option>   
<option value="CT">Connecticut</option>   
<option value="DE">Delaware</option>   
<option value="DC">District Of Columbia</option>   
<option value="FL">Florida</option>   
<option value="GA">Georgia</option>   
<option value="HI">Hawaii</option>   
<option value="ID">Idaho</option>   
<option value="IL">Illinois</option>   
<option value="IN">Indiana</option>   
<option value="IA">Iowa</option>   
<option value="KS">Kansas</option>   
<option value="KY">Kentucky</option>   
<option value="LA">Louisiana</option>   
<option value="ME">Maine</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>   
<option value="NV">Nevada</option>   
<option value="NH">New Hampshire</option>   
<option value="NJ">New Jersey</option>   
<option value="NM">New Mexico</option>
<option value="NY">New York</option>   
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="OH">Ohio</option>   
<option value="OK">Oklahoma</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="RI">Rhode Island</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>   
<option value="VA">Virginia</option>
<option value="WA">Washington</option>   
<option value="WV">West Virginia</option>   
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
</select>

I'm trying to create VIP zone, but I need to check if user has input correct username and password....I tried to make it work this way
HTML
Code: [Select]
<form action="vipchat.php" method="post" />
Korisnicko ime: <input type="text" name="ime"/>
Lozinka: <input type="password" name="lozinka"/>
<input type="submit" value="Uloguj se"/>
</form>php
Code: [Select]
<?php
$imet = "komp";
$sifrat = "racun";

if ($_POST["ime"]==$imet)and($_POST["lozinka"]==$sifrat) 
echo "Tacno je";
else echo "Netacno je";
?> But it gives me this error
Code: [Select]
Parse error: syntax error, unexpected T_LOGICAL_AND in C:\AppServ\www\adm\vipchat.php on line 16

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

I have a Payment Form that has become rather complex, and I think it's time to hand things off to another page?!

Here is the gist of my form...


Code: [Select]
<?php session_start(); ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head></head>
<body>
<?php
// Initialize variables.

// *********************************************************************
// HANDLE FORM.
// *********************************************************************
if (isset($_POST['submitted'])){
// Initialize Errors Array.
  $errors = array();

// ********************
// CHECK FORM DATA. *
// ********************

// Determine if any errors.
if (empty($errors)){
// *********************************************************************
// PROCESS PAYMENT.
// *********************************************************************

//@@@@@@@@@@@  START AUTHORIZE.NET CODE  @@@@@@@@@@@@@@@@@

// Use HTTP POST to send form data.
curl_setopt($request, CURLOPT_POSTFIELDS, $post_string);

// Print Response Code.
switch($response_array[0]){
case "1":
$responseCode = 'Approved';
break;
case "2":
$responseCode = 'Declined';
break;
case "3":
$responseCode = 'Error  (Please contact Customer Service.)';
break;
case "4":
$responseCode = 'Held for Review  (Please contact Customer Service.)';
break;
}

echo "<br />Response Code: " . $responseCode . "<br />";
//@@@@@@@@@@@  END AUTHORIZE.NET CODE  @@@@@@@@@@@@@@@@@@

// Do not return to Payment Form!!!
exit();
// *********************************************************************
}// End of PROCESS PAYMENT.
}// End of HANDLE FORM.

?>

<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -->
<!-- HTML PAYMENT FORM -->
<form id="payment" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">


</form>
</body>
</html>

In fairness, this actually isn't the entire page - it is just the HTML Form and PHP Handling Script...

The entire page will also have a Header and Footer, and is why I am asking for help.

As my code works no, after the form is submitted, the user sees a white screen with only a Response Message.

How can I redirect the user to another page which has my website's Header and Footer and a more personalized message??

(I could technically echo a boat-load of HTML in the IF-THEN-ELSE after the form is submitted, but that seems excessive.  So a page re-direct seems to make more sense...)

Thanks,


Debbie