PHP - Score Update/result Via Function

Can anyone suggest a solution?

Code: [Select]
function getOtherProject($worker) {
$query2  = "SELECT company_project FROM projects WHERE username='$worker'";
$res = mysql_query($query2);
while($a = mysql_fetch_array($res)) {
echo "company_project = '".$a["company_project"]."' or ";
}
  }
  getOtherProject($session->username);
When called here reads: company_project = 'HTML' or company_project = 'Coder' or



$query1  = "SELECT username, company, company_line_manager, firstname, lastname, level FROM work_users WHERE level = '4' and ";
$query2  = getOtherProject($session->username);
$query3 = "company_project = 'abc123'";
$query = $query1.$query2.$query3;

$res = mysql_query($query, $cid);

echo $query;
[/code]

When called here the function getOtherProject, get ignored:
SELECT username, company, company_line_manager, firstname, lastname, level FROM work_users WHERE level = '4' and company_project = 'abc123'

Hi there, hope one of you can help me with a problem im just having.

Ok, lets start with the explanation what i want to to:
I'd like to collect headlines from a html site, and get the test results in an array, so that the array structure represents the dom-levels of the site.

Small Example:
<h1>test1.1<h1/>
<h2>test2.1</h2>
<h2>test2.2</h2>
<h3>test3</h3>
<h1>test1.2<h1/>
Shoul end in a array structure like:

Code: [Select]
array('level 1' => array (
            'sibble1' => array (
                'headline' => 'test1.1',
                'level2' => array(
                    'sibble1' => array (
                        'headline' => 'test2.1',
                        'level3' => array(), // empty data, needs to be processed anyway to find gaps, to maybe a h4 headline would be existing
                    ),
                    'sibble2' => array (
                        'headline' => 'test2.2',
                        'level3' => array (
                            'sibble1' => array (
                                'headline' => 'test3.1',
                                'level4' => array(), // empty data, needs to be processed anyway to find gaps, to maybe a h4 headline would be existing
                            ),
                        ),
                    ),
                ),
            ),
            'sibble2' => array (
                'headline' => 'test1.1',
                'level2' => array(),
             ),
        ),
);

So i hope out of this example you can see what i want to do. level represents the healdine level 1-9, sibblin is as name for the childs on the headline level.

Ok, so to extract the herefore needed data out of the html, i build a class with a recursive function, that filters the html by a regex from one headline to the next, first iteratin all childs, if there are no more childs i go tho ne nextsibbling element.

as an running example code look he

Code: [Select]
<?php

class Application_Model_DomParser {

    const PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH = 4;

    private $slicedFields = array();

    public function __construct() {
    }

    public function sliceFirstSectionToDataFields($level = 1, $haystack) {

        preg_match_all("#(.*?)<h$level>(.*?)</h$level>(.*?)(<h$level>|$)#s", $haystack, $data);

        // prepare the chunkData
        $pageText = '';
        if (isset($data[1][0])) {
            $pageText = $data[1][0];
        }
        $headline = '';
        if (isset($data[2][0])) {
            $headline = $data[2][0];
        }
        $dataToProcessNextLevel ='';
        if (isset($data[3][0])) {
            $dataToProcessNextLevel = $data[3][0];
        }
        // @todo dirty warnings compression, search why warning occures
        @$posOfNextChild = strlen($data[0][0]) - self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH;


// from here goes the debug...
echo $headline ."::" .strlen($dataToProcessNextLevel). "<br>";


        if (strlen($dataToProcessNextLevel) <= self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH) {
            if ($level < 9) {
                $dataToProcessNextLevel = $haystack;
            }
            else {
                return;
            }
        }
        //recursive check for next level in $dataToProcessNextLevel
        $nextLevel = $level + 1;
        $this->sliceFirstSectionToDataFields($nextLevel, $dataToProcessNextLevel);


        $haystack = substr($haystack, $posOfNextChild);
        // slized To The End
        if (self::PREG_MATCH_ONE_ELEMENT_TO_MUCH_LENGTH == strlen($haystack)) {
//            die("slized To The End");
            return;
        }

        // recursive check for other childs in actuall level...
        $this->sliceFirstSectionToDataFields($level, $haystack);
    }
}


$htmlString = 'test<h1>headkline1.1</h1>
<p>test test</p>
<h2>headline 2.1</h2>test test
<h2>headline 2.2</h2>
<p>tes test test</p>
<h3>headline 3.1</h3>test
<h3>headline 3.2</h3>test
<h2>headline 2.3</h2>
<p>&nbsp;</p>
<p>test</p>
<h1>headline 1.2</h1>
<h2>headline 2.4</h2>
<p>11111111111112222222222222222222222</p>
<p>&nbsp;ewfwrefg upowmdg w3q09umq09wrt n3q089ty 3q0898943ty -98 41</p>
<h3>headline 3.3</h3>
<p>test</p>
<p>test</p>
<p>test</p>
<h1>1.3 testtest</h1>
<p>test</p>
<h3>head 3.4</h3>
<p>sadfsadfsadf asdfsda f sdaas saf saddas</p>
<h3>head 3.4</h3>
<h3>test 1.3</h3>
<p>test;</p>
';

$model = new Application_Model_DomParser();
$result = $model->sliceFirstSectionToDataFields(1, $this->htmlString);


So letting this piece of code run, you can se via the debug echo, every headline is found, even in the right order of its occurence.

My problem now is dont get it how to return the extracted values, and collect them to get a result as my above shown structure shows.

So i spent ours to solve this problem but didnt come to a result.

I know its a hard problem, and to help me takes time, cause its a complex situation.

Allthough i hope someone knows a anser. I need this problem solved, to get my mind rested!

Thanks, and greetings
Selma

I've been hacking at this for about 4 hours now.. Throwing the towel in! Any feedback or suggestions please:

I'm calling a function like so:

<!--START :: Run report and update records -->
<p>
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
 <!--<input type="hidden" name="post_var">-->
  <input type="submit" name="runUpdate" value="Run Update">
</form>
</p>
<?php
if (isset($_POST['runUpdate'])) {
updateRecords();
};
?>
<!--END :: Run report and update records -->

Here are the function details:

<?php
function updateRecords() {
// START :: Query to replace matches
mysql_query("UPDATE orig_codes_1a AS a
      JOIN old_and_new_codes_1a AS b ON concat(a.orig_code_1, a.orig_code_2) = concat(b.old_code_1, b.old_code_2)
   SET a.orig_code_1 = b.new_code_1,
                           a.orig_code_2 = b.new_code_2") or die(mysql_error());
// END :: Query to replace matches

echo "<p><table border='1' cellpadding='3' width='100%'>";
echo "<tr>
<th>Updated Code 1</th>
<th>Updated Code 2</th>
</tr>";
// START :: While loop - keeps getting the next row until there are no more to get
while($row = mysql_fetch_array($result)) {
//START :: If to find matching criteria class it w/ bg color
if ($row['orig_code_1'] < '10000') {
$changedClass = "changedClassCSS";
} else {
$changedClass = "";
};
//END :: If to find matching criteria class it w/ bg color

//START :: Print out the contents of each row into a table
echo "<tr><td class=\"$changedClass\">"; 
echo $row['orig_code_1'];
echo "</td><td class=\"$changedClass\">"; 
echo $row['orig_code_2'];
echo "</td>"; 
}
echo "</table></p>";
//END :: Print out the contents of each row into a table

// START //
//echo "$tableOutput";
// END //
};
?>

I'm getting this error:

Notice: Undefined variable: result in C:\wamp\www\php_practice\apps\records_updater_2\functions.php on line 27

Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\wamp\www\php_practice\apps\records_updater_2\functions.php on line 27

Now what I don't understand is 1) This script works fine (even though the $result is not defined) when all of the code is in one file not being called as a function. And 2) Why the hell would it work as in number 1??

Please please please tell me what I am doing wrong here!

Hello,

New to PHP and trying to loop through rows to and get the name of the "property" in this case.  I have tried foreach and while and neither seem to want to return all rows by calling the function.  Does it have something to do with echo'ing the table structure or can I not return an array out of a function like this?  I commented out the while loop as that wasn't working and put in a foreach loop though that didn't return all the data either.  Any help is greatly appreciated 


Code: [Select]
<?php

function getProperties(){

$sql = "SELECT propertyName FROM properties;";
$result = mysql_query($sql);
//$count = mysql_num_rows($result);
$property = mysql_fetch_array($result);
foreach($property as $propertyName){

echo  "<td width=\"157\" height=\"24\" valign=\"middle\"><div align=\"left\"><input type=\"checkbox\" name=\"$propertyName\"
 \"id=\"$propertyName\" />$propertyName</div></td>";

 
}

/*
for($i=0;$i>=$count;$i++){

while($property = mysql_fetch_array($result)){

$propertyName = $property['propertyName'];

echo  "<td width=\"157\" height=\"24\" valign=\"middle\"><div align=\"left\"><input type=\"checkbox\" name=\"$propertyName\"
 \"id=\"$propertyName\" />$propertyName</div></td>";

}
}
*/
}
?>

Hello, I have been developing a website that needs to display products online, I was originally going to hand-write the PHP code but I thought it would be more beneficial to make it database orientated as new products can easily be added and a search function becomes possible.

I have it working so far so good, but the last part I can't seem to get working. I have it so all the products that have the desired category are displayed, but I want a more detailed analysis of the product to appear when the image is clicked, which at the moment, displays a blank page.

http://www.webwib.co...?p=floorpuzzles - this is the hand coded version that demonstrates how I want it to work. http://www.webwib.co...hp?floorpuzzles - this is the db version so far, it works how it is intended to apart from the last stage, which returns as a blank page rather than a dedicated page for the selected product.

Here is my code, the third segment beginning with "if(isset($_GET['$ID'])){", is my attempt at the final stage.

<?php
	$db=mysql_connect  ("localhost", "webwibco_charlie",  "Hello123") or die ('I cannot connect to the database  because: ' . mysql_error()); 
	$mydb=mysql_select_db("webwibco_products"); 

	include("header.php");

	if(isset($_GET['floorpuzzles'])){ 
		     echo "<h1>Our Floor Puzzles</h1>";
		$sql="SELECT  ID, Name, Tags, Description, Category FROM products WHERE Category LIKE '%" . FloorPuzzles .  "%'"; 
		$result=mysql_query($sql); 
		while($row=mysql_fetch_array($result)){ 
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description'];  
			echo "<div class=\"box\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"floorbox\"><a href=\"?$ID#productspage\"><img src=\"images/products/catalogue/$ID.jpg\" class=\"small\"></a></div>";
			echo "<h2>$Description</h2>";
			echo "</div>";
		}
	}

	if(isset($_GET['anothercategory'])){ 
		$sql="SELECT  ID, Name, Tags, Description, Category FROM products WHERE Category LIKE '%" . AnotherCategory .  "%'"; 
		$result=mysql_query($sql); 
		while($row=mysql_fetch_array($result)){ 
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description'];  
			echo "<h1>Our Floor Puzzles</h1>";
			echo "<div class=\"box\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"floorbox\"><a href=\"?$ID0#productspage\"><img src=\"images/products/catalogue//$ID.jpg\" class=\"small\"></a></div>";
			echo "<h2>$Description</h2>";
			echo "</div>";
		}
	}

	if(isset($_GET['$ID'])){   
		$sql="SELECT  ID, Name, Tags, Description, Peices, Size, Barcode, Category FROM products WHERE ID LIKE '%" . $ID .  "%'";   
		$result=mysql_query($sql);   
		while($row=mysql_fetch_array($result)){  
			$Name  =$row['Name'];
			$ID  =$row['ID']; 
			$Description  =$row['Description']; 
			$Pieces  =$row['Pieces']; 
			$Size =$row['Size']; 
			$Barcode  =$row['Barcode'];   
			echo "<div class=\"1\">";
			echo "<h1>$Name</h1>";
			echo "<div class=\"bigbox\">";
			echo "<div class=\"floorbox\"><img src=\"images/products/catalogue/$ID.jpg\" class=\"big\"></div>";
			echo "</div>";
			echo "</div>";
			echo "<div class=\"2\">";
			echo "<p>Puzzle Pieces: $Pieces</p>
				  <p>Puzzle Size: $Size</p>
				  <p>Barcode $Barcode</p>";
			echo "</div>"; 
		}  
	}  

include("footer.php");
?>

Thank you in advance for any assistance given.  

Hi all !   I have a piece of code he

$result = display_all(fcon, $var1, $var2);

function display_all( // defined in another file
$query = "SELECT one, two, three four, index1, index2 FROM numbers WHERE index1 = $var1 LIMIT 0, 1"; $result = mysqli_query($fcon, $query); return ($result); )

and then I use the returned variable $result to display the value as follows:-

		while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC))
		{
			echo "<tr>";
			echo "<td>".$one."</td>";
			echo "<td>".$two."</td>";
			echo "<td>".$three. "</td>";
			echo "<td>".$four. "</td>";
			echo "<td>".$index1. "</td>"; 
                        echo "</tr>";
               }    

and this displays the n rows of data returned.       Now I have started using prepared statements and the function is now 

function display_all{

      $query = "SELECT one, two, three four, index1 FROM numbers WHERE index1 = ?
                LIMIT 0, 10";
      $stmt = $conn->prepare($query);
      $stmt->bind_param('i',$var)
      if($stmt->execute())
      {
          $stmt->bind_result($one, $two, $three, $four, $index1);
          $stmt->store_result();
      }
return($stmt);
}

However the returned $stmt object is unable to display the n rows of data since it shows null values. I assume that this is not the right way to use the $stmt object to display data. I must be missing something. So I request you guys to help me with this.   Thanks loads.
Edited by ajoo, 23 December 2014 - 11:24 AM.

Hi,

I have the following code which basically checks an array of input textboxes and inserts them into a database table:


    public function insertAuthor($authArray, $PCorder=0)
    {
        $query = sprintf('SELECT Pid, Pname FROM People WHERE Pname IN(\'%s\') ORDER BY Pid ASC', implode('\',\'', $authArray));
        $result = mysql_query($query);

        $maxquery = "SELECT MAX(CPid) as max FROM ConfPaper WHERE CPRid = ".$_GET['CPRid'];
        $maxresult = mysql_query($maxquery);
        $max = mysql_fetch_array($maxresult);
        $CPid = $max['max'];

        if($result && mysql_num_rows($result) > 0)
        {
            $sqlValues = array();
            while(list($PId, $PName) = mysql_fetch_row($result))
            {
                if(in_array($PName, $authArray))
                {
                    $sqlValues[] = sprintf("(%d, 1, ".$CPid.", %d, now(), 0)", $PId
                                                               , $PCorder++ );
                    // Author already exists within the Pname table
                    // remove user from $authArray
                    $key = array_search($PName, $authArray);
                    unset($authArray[$key]);
                }
            }
        $sql  = "INSERT INTO PeopleCon(Person_id, PCHid, Pid, PCorder, PCdateadded, PCdeleted) VALUES \n";
        $sql .= implode(",\n", $sqlValues);
        $result = mysql_query($sql);
        }
        // If there are Authors left within the $authArray
        // Add them to the Pname table
        if(count($authArray) > 0)
        {
            People::insertPersons($authArray); // call insertPersons method for remaining authors
            $this->insertAuthor($authArray, $PCorder); // insert the remaining auhtors into PeopleCon
        }
    }


insertPersons method is as such:


    public function insertPersons($PName)
    {
        $query = "INSERT INTO People (Pname) VALUES ('" . implode("'), ('", $PName) . "')";
        $result = mysql_query($query);
    }


The logic works by firstly checking to see if an Author exists, if so they are inserted into PeopleCon, if not they are inserted into People AND PeopleCon. This all works perfectly..


But now what  i need to do is build an update method where users can edit the authors also. The logic would be more or less the same, but i wouldn't neeed an insertpersons method, i would need to change it, and also the script would edit the existing authors, and if anymore are added apply the same method as above.

Can anyone help me out as to how i should go about tackling this?

Thanks

Kind regards
Billy

Is there any way to tell my php ajax file to run the update query if the data already exist and if not, then create the row in the database?  I have both the update and the insert functions created, but was just wondering if I could tell php which one to use without passing through a parameter.

I am trying to create a CMS management website, but I can't seem to get the update function to work. Everything else works fine but not the update function. Can anyone please tell me why or what the problem is? I have spent too long trying to fix it and have failed. It is correctly linked to the database when I hit the edit button all i get is UPDATE_CONTENT_FORM($_GET['ID'])?>where the text boxes should be is   . Please help, I am really stuck. (sorry about spelling )
code in CMS_Class.php

Class modernCMS{

var $host='localhost';
var $username='lmcmanus13';
var $password='k0gl0zfh3g1ccm4v';
var $db='lmcmanus13';

function connect(){
$con = mysql_connect($this->host, $this->username, $this->password);
mysql_select_db($this->db,$con);
}

function get_content($id =''){

if ($id != ""):
$id = mysql_real_escape_string($id);//helps to protect database from beening hacked 
$sql = "SELECT * FROM `CMS_Content` WHERE id ='$id'";

else:
$sql = 'SELECT * FROM `CMS_Content` WHERE 1';

endif;

//$query = 'SELECT * FROM `CMS_Content` WHERE 1';
$result = mysql_query($sql) or die(mysql_error());

if (mysql_num_rows($result)!=0):
while($row= mysql_fetch_assoc($result)){
echo '<h1><a href="Animals.php?id=' . $row['id'] . '">' . $row['Title'] . '</h1>';
echo '<p>' . $row['Body'] . '</p>';
}
else:
echo '<p> we are sorry there seems to be a problem with your request</p>';
endif;
echo $return='<p><a href ="Animals.php">Back</a></p>';

}

function add_content($_POST){

$Title= mysql_real_escape_string($_POST['Title']);
$Body= mysql_real_escape_string($_POST['Body']);

if(! $Title || ! $Body):
if(!$Title=""):
echo"<p>The Title is required<p>";
endif;
if(!$Body=""):
echo"<p>The Body is required<p>";
echo '<a href="add-content.php">Try Again</a>';
endif;
else:
$sql="INSERT INTO `CMS_Content`(`id`, `Title`, `Body`) VALUES ('null','$_POST[Title]','$_POST[Body]')";
$result = mysql_query($sql) or die(mysql_error());
echo "<meta http-equiv='refresh' content='0;url=added.php'>";
endif;
} 

function manage_content (){
echo '<div id ="manage">';
$sql = 'SELECT * FROM `CMS_Content`';
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_assoc($result)):
echo '<h1><a id=' . $row['id'] . '">' . $row['Title'] . '</h1>'
?>
<div>
<span ><a href="update-content.php?id=<?php= echo= $row['id']?>">Edit</a>|<a href="?delete=<?php echo $row['id']; ?>">Delete</a></a></span>
</div>

<?php
endwhile;
echo '</div>';//closes the manages div
}

Function delete_content($id){

if(!$id){
return false;
}else{
$id=mysql_real_escape_string($id);
$sql="DELETE FROM CMS_Content WHERE id='$id'";
$result = mysql_query($sql) or die(mysql_error());
echo "<meta http-equiv='refresh' content='0;url=deleted.php'>";
}
function update_content_form($id) {
$id = mysql_real_escape_string($id);
$sql = "SELECT * FROM CMS_Content WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($res) 
?>
<form action="Animals.php" method="post" > 
<input type="hidden" name="update" value="true" />
<input type="hidden" name="id" value="<?php=$row['id']?>" />
<div>
<label for="title">Title:</label>
<input type="text" name="Title" id="Title" value="<?php=$row['Title']?>" />
</div>
<div>
<label for="body">Body:</label>
<textarea name="body" id="body" rows="8" cols="40"><?php=$row['Body']?></textarea>
</div>
<input type="submit" name="submit" value="Update content" />
</form>
<?php

function update_content($p) {
$title = mysql_real_escape_string($s['title']);
$body = mysql_real_escape_string($s['body']);
$id = mysql_real_escape_string($p['id']);

if(!$title | !$body):

if(!$title):
echo "<p>The Title is Required</p>";
endif;
if(!$body):
echo "<p>The body is Required</p>";
endif;
echo '<p><a href=" update_content.php?id=' . $id . '">Try Again</a></p>';
else:
$sql = "UPDATE CMS_Content SET title = '$title', body = '$body' WHERE id = '$id'";
$res = mysql_query($sql) or die(mysql_error());
echo "Updated Successfully!";
endif;
}
}
}//end of class
}
?>

code in Animals.php

<h1> Our Animals </h1>



<ul>
<li><a href="manage-content.php">Manage Content</a></li>
<li><a href="add-content.php">Add Content</a></li>
</ul>

<?php 
if(isset($_POST['add'])):
$obj->add_content($_POST);
elseif(isset($_POST['update'])):
$obj->update_content_form($_POST);
endif; 
?>
Code in update-content.php
<h1> Our Animals j,j</h1>
<h1> Update Content </h1> 
<?=$obj->update_content_form($_GET['id']) ?>

Edited by Ch0cu3r, 10 December 2014 - 11:47 AM.
Added code tags

Hi, i have a user update function in my code so I can easily change user fields int he database
        public function updateUser ($username, $value, $what) {
$q = "UPDATE `users` SET ? = ? WHERE username = ?";
if ($stmt = $this->db_connection->prepare($q)) {
$stmt->bind_param("sis", $what, $value, $username);
$stmt->execute();
}
}

The database is connected successfully, but say i run a updateUser('blaine0002', 'blah', 'password'); nothing would get updated and no errors are thrown.
Am i doing something wrong? Thank you!

Hi, I've seen this done, and I thought it would be simple now that I am starting to understand ajax but I can't figure it out.   I am using jQuery ajax via wordpress.  I can click a button,  call a php function and use the value returned from php to populate the textbox.   Ok, great!   but I want to run a rather lengthy procedure, and while it's running I would like it to record it's status in a multi-line text box as sort of a debugger ( and to pass the time while waiting )   How can I accomplish this?      I've googled but I must not be using the correct words to search.

I've tried a few different methods, but I can't get this damn function to work. Can someone show me where I've gone wrong?

Here's my code & form. I'm still baffled why it doesn't work! :lol:

url is update-content.php?id=12


<?php
    include("../include/session.php");
      
      if(!$session->logged_in)
      {   
          header('Location: ../login.php');
          die; 
      } 
    require_once('../include/functions.php');
    


    function content($id)
    {    
        $id = $_GET['id'];
        $connection = db_connect();            
        $query = sprintf("select * from content where id = '$id'",                                     
                                     mysql_real_escape_string($id)                                
                                     ); 
            
            $result = mysql_query($query);                
            $number_of_posts = mysql_num_rows($result);
            if ($number_of_posts == 0) 
            {
              return false;    
            }            
            $row = mysql_fetch_array($result);            
            return $row;            
    }

function update($param)
{
     // Get the content id from url to output into the editor    
     $id = $_GET['id'];
     $connect = db_connect();
    
            $page = mysql_real_escape_string($_POST['page']);
            $page_id = mysql_real_escape_string($_POST['page_id']);
            $title = mysql_real_escape_string($_POST['title']);
            $text = mysql_real_escape_string($_POST['text']);   
                    
            $query = ("UPDATE content SET
                                                page = '$page'
                                                page_id = '$page_id'
                                                title = '$title'
                                                text = '$text'
                                             WHERE id = '$id'
                                             ");
             $result = mysql_query($query); 
    
            if (!$result) {
                return false;
            } else {
                return true;
            }                           
}  

?>

<?php
        // Send form data to mysql    
        if(isset($_POST['text']))
        {
            $result = update($_POST);
            if($result === true)
            {
                echo 'Success!';
                die();
            }
        }
        
?> 



And the form..

 <form form name="editor" id="editor" method="post"  action="update-content.php">
  <p><br />
        <b>Assign to page</b><br />
          <input name="page" id="page" size="60" maxlength="500" value="<?php $page = content($id);  echo stripslashes($page['page']); ?>" />
    
          <br />
          <br />
          <b>Page id</b>
          <input  name="page_id" id="page_id" size="4" maxlength="4" value="<?php $page_id = content($id); echo stripslashes($page_id['page_id']); ?>" />
          <br />
          <br />                                                
    
    <b>Title</b>
           <span class="smalltext">(Just a short name this piece of content)</span><br />
          <input name="title" id="title" size="60" maxlength="200" value="<?php $title = content($id);  echo stripslashes($title['title']); ?>" />
          <br />
          <br />
          <br />
      <strong>Content</strong> <span class="smalltext">(paste html in here)</span><br />
      <textarea name="text" id="text" cols="75" rows="15"><?php $text = content($id); echo stripslashes($text['text']); ?></textarea>
      <?php //turn the text area into CK Editor  echo $ckeditor_ini; ?>
          <br />
          <input type="image" src="../images/button_submit.gif" alt="submit" name="submit" value="submit" />
 &nbsp;&nbsp;<a href="index.php"><img src="../images/button_cancel.gif" alt="Cancel" width="120" height="26" border="0" />   
    </form> 

Hey guys,  I have set a quiz up that pulls questions and answers from an array, every correct answer,.... score increments; however it is within a loop.  Something must be wrong with the loop as it keep incrementing however i cant see why.
Any help would be great,

The main aim what i am trying to do is have 5 questions answered and go to different page (different topic for 5 more questions) however keep the on going score.

Hope this makes sense. If not ill try and clear it up.

Thanks for all your help guys in advance, i appreciate it

also not, i have a functions.php, questionsandanswers.php
Code: [Select]


<?php
session_name("Question_Test");
session_start();
echo $_SESSION['score'];
require_once('questionsandanswers.php');
require_once('functions.php');



if (!isset($_POST['submit'])) 
{
$score = 0;
$_SESSION['score'] = $score;
$_SESSION['correct'] = array(); 
$_SESSION['wrong'] = array();
$_SESSION['finished'] = 'no';

if (isset($_SESSION['error']))
{
unset($_SESSION['error']); 
$num = 0;
} 
else
{
$score = 0;
$_SESSION['score'] = $score;
$_SESSION['correct'] = array(); 
$_SESSION['wrong'] = array(); 
$_SESSION['finished'] = 'no';
$num = 0;
} 
}
else
{
$num = (int) $_POST['num'];
$postedanswers = str_replace("_"," ",$_POST['answers']);
if ($postedanswers == $answers[$num]['0'])
{
$_SESSION['score'] ++;
$_SESSION['correct'][] = $postedanswers; 
} 
else
{
$_SESSION['wrong'][] = $postedanswers;
}

if ($num < count($questions)-1) 
{
$num++;
} 
else 
{
$last = true;
$_SESSION['finished'] = 'yes';
}
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>running an array</title>
<?php 
if (!isset($last)) {
echo "<script type=\"text/javascript\" src=\"form.js\"></script>";
}
?>
</head>
<body>
<h1>Protection Section</h1>
<?php if (!isset($last)){?>
<h2>Questions <?php echo $num+1; ?>:</h2>
<p><strong><?php echo $questions[$num]; ?></strong></p>
<form id="questionBox" method="post" action="test1.php">

<?php
$pattern = ' ';
$replace = '_';
$shuffledAnswers = shuffle_assoc($answers[$num]);
#var_dump($newanswers);
foreach ($shuffledAnswers as $answer) 
{
$answer2 = str_replace($pattern,$replace,$answer);
echo "<li><input type=\"radio\" id=\"$answer2\" value=\"$answer2\" name=\"answers\" />\n";
echo "<label for=\"$answer2\">$answer</label></li>\n";
}
?>
<input type="hidden" name="num" value="<?php echo $num; ?>" />
<input type="submit" id="submit" name="submit" value="Submit Answer" /></p>
</form>
<?php
} else
{ 
 echo "your final score is:</h2>\n
 <h3>{$_SESSION['score']}/20</h3><h4>Verdict:</h4>";
 if($_SESSION['score'] <= 5) echo "<p id=\"verdict\"><span>S</span>everely <span>H</span>indered <span>I</span>n the <span>T</span>est!</p>\n";
 if(($_SESSION['score'] > 5) && ($_SESSION['score'] <= 10)) echo "<p id=\"verdict\"><span>C</span>ould <span>R</span>ead <span>A</span>nd <span>P</span>ractice more.</p>\n";
 if(($_SESSION['score'] > 10) && ($_SESSION['score'] <= 15)) echo "<p id=\"verdict\"><span>A</span>cronyms a<span>R</span>e <span>S</span>o <span>E</span>asy!</p>\n";
 if($_SESSION['score'] > 15) echo "<p id=\"verdict\"><span>S</span>uper <span>A</span>cronym <span>S</span>pecialist</p>";
 
 echo "<p id=\"compare\"><a href=\"test2.php\">Next Section! <img src=\"images/arrow.png\" /></a></p>";
}
?>

</body>
</html>

hey guys.  Hopefully someone can help me with this.  I have been trying to figure out for a while now why the quiz score keeps incrementing even if i refresh the page.
so far there is 2 quiz sections, firstly $_SESSION['score']; is incremented on every correct answer then this information is carried on to the second part of the quiz which increments $_SESSION['score'1];

However everytime a page is refreshed then it increments again.  How can i get around this? 

Also note i have a questions and answers section (array of q's and a's) and a functions page.  Any help would be great.

Thanks in advance

Lance


Code: [Select]
<?php
session_name("Question_Test");
session_start();
$_SESSION['score'];
require_once('questionsandanswers2.php');
require_once('functions.php');


if (!isset($_POST['submit'])) 
{
$score1 = 0;
$_SESSION['correct'] = array(); 
$_SESSION['wrong'] = array();
$_SESSION['finished'] = 'no';

if (isset($_SESSION['error']))
{
unset($_SESSION['error']); 
$num = 0;
} 
else
{
$score1 = 0;
$_SESSION['score1'] = $score1;
$_SESSION['correct'] = array(); 
$_SESSION['wrong'] = array(); 
$_SESSION['finished'] = 'no';
$num = 0;
} 
}
else
{
$num = (int) $_POST['num'];
$postedanswers = str_replace("_"," ",$_POST['answers']);
if ($postedanswers == $answers[$num]['0'])
{
$_SESSION['score1'] ++;
$_SESSION['correct'][] = $postedanswers; 
} 
else
{
$_SESSION['wrong'][] = $postedanswers;
}

if ($num < count($questions)-1) 
{
$num++;
} 
else 
{
$last = true;
$_SESSION['finished'] = 'yes';
}
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>running an array</title>
<?php 
if (!isset($last)) {
echo "<script type=\"text/javascript\" src=\"form.js\"></script>";
}
?>
</head>
<body>
<?php if (!isset($last)){?>
<h1>Detection Section</h1>
<h2>Questions <?php echo $num+1; ?>:</h2>
<p><strong><?php echo $questions[$num]; ?></strong></p>
<form id="questionBox" method="post" action="test2.php">

<?php
$pattern = ' ';
$replace = '_';
$shuffledAnswers = shuffle_assoc($answers[$num]);
#var_dump($newanswers);
foreach ($shuffledAnswers as $answer) 
{
$answer2 = str_replace($pattern,$replace,$answer);
echo "<li><input type=\"radio\" id=\"$answer2\" value=\"$answer2\" name=\"answers\" />\n";
echo "<label for=\"$answer2\">$answer</label></li>\n";
}
?>
<input type="hidden" name="num" value="<?php echo $num; ?>" />
<input type="submit" id="submit" name="submit" value="Submit Answer" /></p>
</form>
<?php
} else
{ 
$_SESSION['finalscore'] = $_SESSION['score'] + $_SESSION['score1'];
 echo "your final score is:</h2>\n
 <h3>{$_SESSION['finalscore']}/20</h3><h4>Verdict:</h4>";
 if($_SESSION['finalscore'] <= 5) echo "<p id=\"verdict\"><span>S</span>everely <span>H</span>indered <span>I</span>n the <span>T</span>est!</p>\n";
 if(($_SESSION['finalscore'] > 5) && ($_SESSION['finalscore'] <= 10)) echo "<p id=\"verdict\"><span>C</span>ould <span>R</span>ead <span>A</span>nd <span>P</span>ractice more.</p>\n";
 if(($_SESSION['finalscore']) && ($_SESSION['finalscore'] <= 15)) echo "<p id=\"verdict\"><span>A</span>cronyms a<span>R</span>e <span>S</span>o <span>E</span>asy!</p>\n";
 if($_SESSION['finalscore'] > 15) echo "<p id=\"verdict\"><span>S</span>uper <span>A</span>cronym <span>S</span>pecialist</p>";
 
 echo "<p id=\"compare\"><a href=\"test2.php\">Next Section! <img src=\"images/arrow.png\" /></a></p>";
}
?>

</body>
</html>

I try to get a high score system to work. The problem is to write data to the txt file:
The file adder.php contains:
<?php
if(array_key_exists('name',$_GET)==true and array_key_exists('score',$_GET)==true)
{
$name=$_GET['name'];
$score=$_GET['score'];
$file=fopen('highscore.txt','a');
fwrite($file,$name.';'.$score.';'); 
fclose($file);
}

header("Location: index.php"); // Replace index.php with the name (and, if not in the same folder, path)
                               // of the page that will display the scores (see below)

?>

I use this website: http://members.multimania.nl, so it looks like http://members.multimania.nl/mine/adder.php?name=winner&score=99

What am I doing wrong?