PHP - Testing A Quiz Question

Wow, am I glad I found this forum!  I spent the past few hours trying to modify a PHP/mySQL script in order to test it. What this script does is basically look up a mySQL database (based on ip2nation) to find out what country and currency the IP address belongs to. This is the code sample:

Code: [Select]
$sql = 'SELECT  c.country, c.curr_code FROM  ip2nationcountries c, ip2nation i WHERE  i.ip < INET_ATON("24.24.24.24") AND c.code = i.country ORDER BY  i.ip DESC LIMIT 0,1';

        $countryName = $db->get_sql_row($sql);

I tested the code in PHPmyAdmin and it returns 2 rows:

country ------- curr_code (row names)
United States ------- USD (actual values)

So basically 2 variables, United States and USD. Now comes the problem, in order to test the script for several countries, I need to be able to "override" the result in the PHP script

I tried to do that by commenting out the part that returns the result from the mySQL query and modifying it with the following style, but I think I'm doing something wrong:

Code: [Select]
### $countryName = $db->get_sql_row($sql); ###

$countryName = "United States USD";

Is there any way that I can temporarily override the result returned by mySQL and "fake it" so to say? I understand the mySQL query returns 2 rows, so how would I go about overriding 2 rows?

I hope this makes sense ...you're all my last hope.

 

Hi,
 
My name is Karel van der Veen. I am trying to creat a script for a quiz on my website but I am stuck. I was hoping you might have an idea for the solution.
 
The idea is a page with a picture and multiple choice questions about that picture. For example a picture of a bike.
Question 1: what colour is the bike? --> choices are green, red, blue.
Question 2: what shape are the wheels? --> round, square.
 
I have made a script that compares the answers given by the student, with the correct answers I put in the database corresponding with the bike on the picture. If the student has it right, than after clicking on "next", the "correct answer" page will load.
If he made a mistake a "wrong answer" page will load.
So far the script works. But what I would like to happen is if the student gives a wrong answer, that after clicking on the `next` button, he will go back to the front page where the picture and the questions are with a sign or mark around the question he answered wrong, so he knows what question he had wrong and has to answer again.
 
Below is the script I have so far. Do you know what I have to change or to add to the script?
 
regards Karel

Code: [Select]
script of the question page:

<?php

$array_vorm = Array("rond","vierkant");

$array_kleur= array("rood","blauw","groen");

$array_grootte = array("4x4","8x8");

?>

<form  method="post" action="results.php"><br />

<div id="vorm">

          <div id="vorm1"><img src="images/vorm.gif" alt="vorm" width="75" height="75" class="vorms" /></div>

          <div id="vorm2">

<table>

                                                               <tr><td>

                <label class="vormhead">VORM</label><br>

   <select name="form_vorm[]" class="randmenu" size="4" multiple >

         <option><?php echo implode("</option><option>",$array_vorm); ?></option>

    </select>

    </td></tr>

                </table>

    </div>

        </div>

 

<div id="kleur">

          <div id="kleur1"><img src="images/kleur.gif" alt="vorm" width="75" height="75" class="kleur" /></div>

          <div id="kleur2">

<table>

                                                               <tr><td>

                <label class="kleurhead">KLEUR</label><br>

   <select name="form_kleur[]" class="randmenu" size="4" multiple >

         <option><?php echo implode("</option><option>",$array_kleur); ?></option>

    </select>

    </td></tr>

                </table>

    </div>

        </div>

 

<div id="grootte">

          <div id=" grootte 1"><img src="images/ grootte .gif" alt="vorm" width="75" height="75" class=" grootte " /></div>

          <div id=" grootte2">

<table>

                                                               <tr><td>

                <label class=" grootte head">GROOTTE</label><br>

   <select name="form_ grootte []" class="randmenu" size="4" multiple >

         <option><?php echo implode("</option><option>",$array_ grootte ); ?></option>

    </select>

    </td></tr>

                </table>

    </div>

        </div>

 

<input type="submit" class="zoekbalk" value="zoeken" />

 
 
 
 
 
 
And this is the script of the result page:
 


<?php

error_reporting ( E_ALL | E_STRICT ); 

    ini_set ( 'display_errors', 1 ); 

?>

 

<?php

include 'connect.php';

?>

<?php

$geenbeschrijving = "De beschrijving is onjuist. 

$geenselectie = "Je hebt geen selectie gemaakt, maak eerst een selectie en klik dan op zoeken. <br/><br/>

$antwoord = "Antwoord: ";

$diagnose = "Beschrijving: ";

$diagnose2 = "Diagnose: ";

$vormeggo = "Vorm: ";

$kleureggo = "Kleur: ";

$grootteeggo = "Grootte: ";

 

$array_vorm = array("rond","vierkant");
$array_kleur= array("rood","blauw","groen");
$array_grootte = array("4x4","8x8");

 

if($_SERVER['REQUEST_METHOD'] == 'POST' ) {

    $query = "select * from foto1 where ";

    $query_init = $query;

    $first_option = true;

  if (isset($_POST["form_vorm"])){

                                               if ($first_option == false){

                                                               $query .= " AND ";

                } else{

                                                               $first_option = false;

                                                               }

                                                               $query .= "(";

                                                               for ($i=0; $i<=count($_POST["form_vorm"])-1; $i++){

                                                               if ($i == 0){

                                                                              $query .= "(vorm LIKE '%".$_POST["form_vorm"][$i]."%') ";

                                                               }else{

                                                                              $query .= " OR (vorm LIKE '%".$_POST["form_vorm"][$i]."%') ";

                                                               }

                                               }

                                               $query .= ")";

                               }

                                                               

                                 if (isset($_POST["form_ kleur "])){

                                               if ($first_option == false){

                                                               $query .= " AND ";

                } else{

                                                               $first_option = false;

                                                               }

                                                               $query .= "(";

                                                               for ($i=0; $i<=count($_POST["form_ kleur "])-1; $i++){

                                                               if ($i == 0){

                                                                              $query .= "( kleur LIKE '%".$_POST["form_ kleur "][$i]."%') ";

                                                               }else{

                                                                              $query .= " AND (kleur LIKE '%".$_POST["form_ kleur "][$i]."%') ";

                                                               }

                                               }

                                               $query .= ")";

                               }

                                               

                     if (isset($_POST["form_ grootte "])){

                                               if ($first_option == false){

                                                               $query .= " AND ";

                } else{

                                                               $first_option = false;

                                                               }

                                                               $query .= "(";

                                                               for ($i=0; $i<=count($_POST["form_ grootte "])-1; $i++){

                                                               if ($i == 0){

                                                                              $query .= "( grootte LIKE '%".$_POST["form_ grootte "][$i]."%') ";

                                                               }else{

                                                                              $query .= " AND (grootte LIKE '%".$_POST["form_ grootte "][$i]."%') ";

                                                               }

                                               }

                                               $query .= ")";

                               }

                  

                                

                

                if ($query == $query_init){

                                               echo "<div class=\"geenbeschrijving\">" . $geenselectie . "</div>";

                               }else{

                               

                               //echo $query."<br><br>";

 

                                  if ($result = mysql_query($query)) { 

                if (mysql_num_rows($result)<>0) { 

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

                                                echo "<div class=\"beschrijving\">" . $antwoord . "</div>"; echo "<div class=\"keuze\">" . $vormeggo . $row["VORM"]. "</div>"; echo "<div class=\"keuze2\">" . $kleureggo . $row["KLEUR"]. "</div>"; echo "<div class=\"keuze2\">" . $grootteeggo . $row["GROOTTE"]. "</div>"; </div>";   

                        $beschrijvingquery = "select BESCHRIJVING from beschrijving where Catalog_ID=".$row["ID"]; 

                        if ($beschrijvingresult = mysql_query($beschrijvingquery)) { 

                            if (mysql_num_rows($beschrijvingresult)<>0) { 

                                while ( $beschrijvingrow = mysql_fetch_assoc ( $beschrijvingresult ) ) { 

                                    echo "<div class=\"beschrijving\">" . $diagnose . "</div>"; echo "<div class=\"beschrijving2\">" . $beschrijvingrow["BESCHRIJVING"]."</div></br>";

                                 }                            

                                                                                                                              } else { 

                                echo "geen beschrijving<br />"; 

                            }                                                                                }

                                                                                                                                              $diagnosequery = "select DIAGNOSE from diagnose where Catalog_ID=".$row["ID"]; 

                        if ($diagnoseresult = mysql_query($diagnosequery)) { 

                            if (mysql_num_rows($diagnoseresult)<>0) { 

                                while ( $diagnoserow = mysql_fetch_assoc ( $diagnoseresult ) ) { 

                                    echo "<div class=\"beschrijving\">" . $diagnose2 . "</div>"; echo "<div class=\"beschrijving2\">".$diagnoserow["DIAGNOSE"]."<br /><br />";

                                }                                             

                                                                                                                                                                                            

                            } else { 

                                echo "geen beschrijving<br />"; 

                            } 

                        } 

                        $fotoquery = "select FOTOthumb, FOTObig from foto where Catalog_ID=".$row["ID"];

                        if ($fotoresult = mysql_query($fotoquery)) { 

                            if (mysql_num_rows($fotoresult)<>0) { 

                                while ( $fotorow = mysql_fetch_assoc ( $fotoresult ) ) { 

                                    echo "<div class=\"beschrijving4\">" .'<a title="' . $fotorow['FOTObig'] . '" href="images/big/' . $fotorow['FOTObig'] . '" rel="lightbox"><img src="images/thumb/' . $fotorow['FOTOthumb'] . '"></a></br></br><hr><hr> '; 


                                } 

                            } else { 

                                echo "<img src='geenfoto.jpg' alt='geen foto' /><br />"; 

                            } 

                        } 

                    } 

                } else { 

                    echo "<div class=\"geenhuidaandoeningen\">" . $geenhuidaandoeningen . "</div>"; 

                } 

            } 

 

 

        }

}

 

?>

 

Just wanted some general advice/guidance,

I know there are plenty of articles and tutorials online about unit testing, but I just wanted to get a first hand perspective off of some of you guys...

What are some real world examples of actual PHP Unit Testing?

Also any unit testing frameworks you can recommend?

Apologies if this has been covered before.

Hello all,

I have a script uploading files on the server.

I would like to send a confirmation to user if the file had been uploaded well.

Code: [Select]

$targetFile =  str_replace('//','/',$targetPath) . $filename;

move_uploaded_file($tempFile,$targetFile);

if (str_replace($_SERVER['DOCUMENT_ROOT'],'',$targetFile))
{
mail($to, 'upload notification', "Dear Mr/Mrs $fixedname, the file entitled $filename has been successfully uploaded");
}else {
mail($to, ' upload notification', "Dear Mr/Mrs $fixedname, the file entitled $filename has been NOT uploaded");
}

I presume I do something wrong because it doesn't work. The successfull email is sent each time.

Thank you very much for helping,
Eric

Hi, I have a class XMLtool where one of the functions is to output a parameter-passed dom document and then output to the browser screen, so basically:

function outputXML($domDocument) {
   if has attributes
     print cur nodes attributes
   for each child,
      if child is element node
          outputXML(cur node)
      else if child is text
          print text
   end for each
}

Please I am not sure what type of unit tests I can perform. I'd appreciate all the help!