PHP - Problem With Mysqli And Bind Variables In Php 5.3

I've been starting to play around the mysqli class and I've been having trouble using it due to various error it gives me from simple queries like this one. I'm not sure what the error is really, I've been following the php manual. Any help would be greatly appreciated.



Code: [Select]
<?php 


$mysqli = new MySQLi('localhost', 'root', 'root', 'jaipai');

if ($mysqli->connect_errno)
{
echo "There was a connection error: ". $mysqli->connecterrno;
}



class testClass 

{

private $db;


function __construct($mysqli)
{
$this->db = $mysqli;
}

public function pageInfo()
{
$query = "SELECT * FROM users WHERE username = jaipai";
$results = $this->db->query($query);

$result = $this->db->fetch_assoc($results);

return $result['username'];

}

}

$testClass = new testClass($mysqli);

echo $testClass->pageInfo();


?>
This gives me this error:
Code: [Select]
Fatal error: Call to undefined method mysqli::fetch_assoc() in /Users/JPFoster/Sites/Research & Development/Programs/Object Sandbox/DatabaseConnection.php on line 30



Just to be a little more informative I've also tried this method
Code: [Select]
$results = $this->db->query($query);

$result = $results->fetch_assoc();

return $result['username'];

This gives me an error:
Code: [Select]
Fatal error: Call to a member function fetch_assoc() on a non-object in Sites/Research & Development/Programs/Object Sandbox/DatabaseConnection.php on line 30

I'm not sure which is on the best path to go. Any help would be greatly appreciated.

<?php

if (isset($_POST['reset-submit'])) {
    $selector = $_POST['selector'];
    $validator = $_POST['validator'];
    $password = $_POST['password'];
    $password2 = $_POST['password2'];

    // probably better to check this earlier
    if (empty($password) || empty($password2)) {
        header("Location: ../create-new-password.php?newpassword=empty&selector=$selector&validator=$validator");
    } elseif ($password !== $password2) {
        header("Location: ../create-new-password.php?newpassword=passwordsnotmatch");
    }

    $currentDate = date("U");

    require "dbh.inc.php";
    
    $sql = "SELECT * FROM reset_password WHERE selector=? AND expires >= $currentDate";
    $stmt = mysqli_stmt_init($conn);
    if (!mysqli_stmt_prepare($stmt, $sql)) {
        echo "SQL error 1";
        exit();
    } else {
        mysqli_stmt_bind_param($stmt, 'ss', $selector, $currentDate);
        mysqli_stmt_execute($stmt);
        $result = mysqli_stmt_get_result($stmt);
        
        if (!$row = mysqli_fetch_assoc($result)) {
            echo 'You need to re-submit your reset request.';
            exit();
        } else {
            $tokenBin = hex2bin($validator);
            $tokenCheck = password_verify($tokenBin, $row['token']);

            if (!$tokenCheck) {
                echo 'You need to re-submit your reset request.';
                exit();
            } else {
                $email = $row['email'];
                $sql = "SELECT * FROM users WHERE email = $email";
                $stmt = mysqli_stmt_init($conn);
                if (!mysqli_stmt_prepare($stmt, $sql)) {
                    echo "SQL error 2";
                    exit();
                } else {
                    mysqli_stmt_bind_param($stmt, 's', $email);
                    mysqli_stmt_execute($stmt);
                    $result = mysqli_stmt_get_result($stmt);
                    if (!$row = mysqli_fetch_assoc($result)) {
                        echo "SQL error 3";
                        exit();
                    } else {
                        $sql = "UPDATE users SET password=? WHERE email=?";
                        $stmt = mysqli_stmt_init($conn);
                        if (!mysqli_stmt_prepare($stmt, $sql)) {
                            echo "SQL error4 ";
                            exit();
                        } else {
                            $hashed_password = password_hash($password, PASSWORD_DEFAULT);
                            mysqli_stmt_bind_param($stmt, 'ss', $hashed_password, $email);
                            mysqli_stmt_execute($stmt);
                            $sql = 'DELETE FROM reset_password WHERE email=?';
                            $stmt = mysqli_stmt_init($conn);
                            if (!mysqli_stmt_prepare($stmt, $sql)) {
                                echo 'SQL error5';
                                exit();
                            } else {
                                mysqli_stmt_bind_param($stmt, 's', $email);
                                mysqli_stmt_execute($stmt);
                                header("Location: ../signup.php?newpassword=updated");
                            }
                        }
                    }
                }
            }
        }
    }
    mysqli_stmt_close($stmt);
    mysqli_close($conn);

    header('Location: ../reset-password.php?reset=success');
} else {
    header('Location: ../index.php');
}

I always get this errors:

Warning: mysqli_stmt_bind_param(): Number of variables doesn't match number of parameters in prepared statement in C:\xampp\htdocs\php_login_system-master\includes\reset-password.inc.php on line 26

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\php_login_system-master\includes\reset-password.inc.php on line 30
You need to re-submit your reset request.

 

But i dont find the mistake in the Code. Can someone help me please

hi guys

I have two functions and they work well, but now i have a problem in the last if

the email is sent like www.yoursite.com/reset_password.php?userid=0&code=

and not http://your.url/set_new_password.php?userid=564979&code=54c4a2767c2f485185ab72cdcf03ab59

so, the problem is that i can get the value of hash and the userid.
If i do an echo "$hash" in the function code(); it shows the value like 564979&code=54c4a2767c2f485185ab72cdcf03ab59
my question is, how i can do the same in the last if? above two functions. Same occur in the last select select userid from password_reset where code=? none userid is showed, it is always zero.


Code: [Select]
<?
function check($sql, $db, $email) {
if(!empty($_POST['email'])) {

$email = $_POST["email"];
if ($sql = $db->prepare("select email from users where email=?")) {
$sql->bind_param('s', $email);

$sql->execute();

$sql->bind_result($email);

if ($sql->fetch()) {
return true;
}
else {
return false;
}
}
}
}



function code($sql, $db, $hash, $pwdHasher, $userExists, $sendPass) {

if (check($sql, $db, $email)) {

$pwdHasher = new PasswordHash(8, FALSE);

$hash = $pwdHasher->HashPassword($userExists["email"]);

$sendPass=$hash;
($sql = $db->prepare('insert into password_reset (code) values (?)'));
$sql->bind_param('s', $hash);

$sql->execute();
$sql->fetch();
return true;
}
}




if (code($sql, $db, $hash, $pwdHasher, $userExists, $sendPass)) {
($sql = $db->prepare("select userid from password_reset where code=?"));

$sql->bind_param('s', $hash);
$sql->execute();
$sql->bind_result($hash);
$sql->fetch();
echo $hash;
$pwrurl = "www.yoursite.com/reset_password.php?userid=" .$hash . "&code=" . $sendPass;

$mailbody = "Dear user,<br><br>If this e-mail does not apply to you please ignore it. It appears that you have requested a password reset at our website www.yoursitehere.com<br>
To reset your password, please click the link below. If you cannot click it, please paste it into your web browser's address bar.<br> <a href='$pwrurl'>$pwrurl</a>  <br> <br>
Thanks,\nThe Administration";

$mail->MsgHTML($mailbody);

$mail->AddAddress($email,"Membro");

$mail->IsHTML(true);

if(!$mail->Send()) {
echo "Deu erro: " . $mail->ErrorInfo;
} else {
echo "Enviado com sucesso";
}


$sql->close();
$db->close();

}


?>



any help?

thanks

Hello,

I'm getting some errors when binding parameters inside a loop, and it's doing my head in

public function query($sql, $params) {
       

if(!$sobj = $this->conn->prepare($sql)) {
               

die('Query Prepare Error (' . $this->conn->mysqli_errno . ') '

. $this->conn->mysqli_error);
               

} else {
               

if(!is_array($params)) {
                       

$params = array_slice(func_get_args(), 1);

}
 

foreach($params as $value) {
                       

$type = strtolower(gettype($value));

$sobj->bind_param($type[0], $this->conn->real_escape_string($value));
                       

}                      
               

$sobj->execute();

$sobj->bind_result($result);

$sobj->fetch();
               

$sobj->close();

return $result;
               

}

}




The errors I'm getting is:

Code: [Select]
Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement in /nfs/c06/h02/mnt/97387/domains/nickythorne.com/html/v2/includes/classes/class_db2.php on line 67

Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement in /nfs/c06/h02/mnt/97387/domains/nickythorne.com/html/v2/includes/classes/class_db2.php on line 67
(Line 67 is $sobj->bind_param($type[0], $this->conn->real_escape_string($value)); above)

I'm calling the function like this:
$details = new DB();
echo $details->query("SELECT `postcode` FROM `details` WHERE `name` = ?  and `address` = ?", array("Josh", "45 Ashdale Road"));


Does anyone know how I can solve this?


Thanks.

Normally this is how I do my query. I am binding min, max and featured parameters like this.

$min_price = 10;
$max_price = 50;
$featured  = 1;

$find_records = $db->prepare("SELECT * FROM projects WHERE min_price >= :min_price AND max_price <= :max_price AND featured = :featured");
$find_records->bindParam(':min_price', $min_price);
$find_records->bindParam(':max_price', $max_price);
$find_records->bindParam(':featured', $featured);
$find_records->execute();
$result_records = $find_records->fetchAll(PDO::FETCH_ASSOC);

 

Now I was wondering if it's ok to do the same thing but like this? I am adding the parameters directly in the query. Would it be prone to SQL injection?

$min_price = 10;
$max_price = 50;
$featured  = 1;

$find_records = $db->prepare("SELECT * FROM projects WHERE min_price >= $min_price AND max_price <= $max_price AND featured = $featured");
$find_records->execute();
$result_records = $find_records->fetchAll(PDO::FETCH_ASSOC);

 

Hi    Im trying to make a simple connect from my centos server to my test domain. I have disabled the firewall on the Windows Server & Centos. Installed php-ldap.x86_64 : A module for PHP applications that use LDAP   print scr from my AD     The ERROR i get:

Warning: ldap_bind(): Unable to bind to server: Can't contact LDAP server in /var/www/html/edit/ldap.php on line 16
LDAP bind failed...

I can telnet from Centos terminal too the DC fine. : telnet dc1.devlab.local 389  

How would I output the value of a variable, getting the name from the value of another variable? For example:

$var1 = 'var2';
$var2 = 'output';


I want it to return 'output', which I'd imagine would work through entering something along lines of $$var1;
Does anyone know what I mean?

        $errors=0;

         //NEW USER NAME HAS BEEN SUBMITTED, CHECK IT OUT AND THEN ADD IF OKAY
$newuser=$_REQUEST['newuser'];

function TryAgain(){
global $errors;
$errors++;
echo '<br/><br/>Please try again <a href="index.php?locate=admin&sub=add_admin">here</a>';
echo "<br/>errors=[$errors]";
}



echo "<br/>Trying to add user: $newuser<br/><br/>";
if ($newuser){
}else{
// field was left blank, report this to user and give them option to try again
echo '<br/>Field was left empty, you must pick a username.';TryAgain();
}

if (strlen($newuser)<5){echo 'Username should be at least 5 characters.';TryAgain();}

if (!$errors){echo "continue to SQL [errors=$errors]";}



what is wrong with this code?
For some reason if I increment $errors with $errors++   within the function it doesn't increment outside the function's scope. even though I declare it as a global at the start of the function. I know I'm doing something stupid here but can somebody please tell me what it is?

Thanks

I am having probelm in saving Session variables ALthough I'm writing session_start();
in the header of my php script and saving the values of Session array in the next page. It does not print the values or show right results.

Code: [Select]
session_start();
require_once ("functions.php");

$token=$_GET['t'];
if(!isset($token)){
 
$name = stripslashes($_POST['username']);
$email = stripslashes($_POST['email']);

check_validate_input($name, $email);
}
if($token=='register')
{
show_registration_form();
}
  $my_model = new model();
  $arr_info = $my_model->check_members($name,$email);
 
   if (($arr_info==NULL)&&($token!='register'))
    {   
    echo '<p> Hello Guest</p><br />';
       show_mailing_form();
    }
   
  else if (($arr_info['role']=='user')||($arr_info['role'] == 'admin'))
    {
         $_SESSION['userId']=$arr_info['id'];
         $_SESSION['user_role']=$arr_info['role'];
         $_SESSION['user_name']=$arr_info['name'];
        print_r  ($_SESSION);}
here it does not print session array.

This code was given to me by mjdamato to help display a student and the course that student has take and within that the modules in the course and the sessions in course including module mark and grade and student's session marks and grades. I am very weak on php code as I have only done it once and that was following a php workbook 2 years ago. I am more of a database specialist. Below is the code given to me and you can also download the code from the attachment:

Code: [Select]
<?php

function outputModule($moduleID, $moduleName, $sessionData)    
  
  {        
  
  if(!count($sessionData)) { return false; }        
  
  $markTotal = 0;        
  $markGrade = 0;
  $weightSession = 0;
  $grade = "";
  $sessionsHTML = "";
  
  foreach($sessionData as $session)        {           
  
   $sessionsHTML .= "<p><strong>Session:</strong> {$session['SessionId']} <br><strong>Session Mark:</strong> {$session['Mark']}</strong> <br><strong>Session Weight Contribution</strong> {$session['SessionWeight']}%</p>\n";            
   $markTotal += round($session['Mark'] / 100 * $session['SessionWeight']); 
   $weightSession  += ($session['SessionWeight']);  
   $markGrade = round($markTotal /  $weightSession * 100);
   
if ($markGrade >= 70){
$grade = "A";}      

else if ($markGrade >= 60 && $markGrade <= 69){
$grade = "B";}

else if ($markGrade >= 50 && $markGrade <= 59){
$grade = "C";}

else if ($markGrade >= 40 && $markGrade <= 49){
$grade = "D";}

else if ($markGrade >= 30 && $markGrade <= 39){
$grade = "E";}

else if ($markGrade >= 0 && $markGrade <= 29){
$grade = "F";}
   
   }        
   
   $moduleHTML = "<p><br><strong>Module:</strong> {$moduleID} - {$moduleName} <br><strong>Module Mark:</strong> {$markTotal} <br><strong>Mark Percentage:</strong> {$markGrade} <br><strong>Grade:</strong> {$grade} </p>\n";       
   
    return $moduleHTML . $sessionsHTML;    }    
    
    $output = "";    
    
    $studentId = false;    
    $courseId  = false;    
    $moduleId  = false;    
    
    while ($row = mysql_fetch_array($result))    {               
     
     if($studentId != $row['StudentUsername'])        {            
     
     //Student has changed              
     $studentId = $row['StudentUsername'];                    
     
     $output .= "<p><strong>Student:</strong> {$row['StudentForename']} {$row['StudentSurname']} ({$row['StudentUsername']})\n";          
     
      }        
      
     if($courseId != $row['CourseId'])        {         
      
      //Course has changed           
       $courseId = $row['CourseId'];                    
       
       $output .= "<br><strong>Course:</strong> {$row['CourseId']} - {$row['CourseName']} <strong>Course Mark</strong> <strong>Grade</strong>  <br><strong>Year:</strong> {$row['Year']}</p>\n";           
       
        }      
        
 if($moduleId != $row['ModuleId'])        {            
 
 //Module has changed            
 if(isset($sessionsAry)) //Don't run function for first record           
 
  {              
  
    //Get output for last module and sessions                
    $output .= outputModule($moduleId, $moduleName, $sessionsAry);            }            
    
    //Reset sessions data array and Set values for new module           
    
     $sessionsAry = array();            
     $moduleId    = $row['ModuleId'];         
     $moduleName  = $row['ModuleName'];        }        
     
     //Add session data to array for current module      
     
     $sessionsAry[] = array('SessionId'=>$row['SessionId'], 'Mark'=>$row['Mark'], 'SessionWeight'=>$row['SessionWeight']);    
     
     }    //Get output for last module  
     
      $output .= outputModule($moduleId, $moduleName, $sessionsAry);   
      
       //Display the output    
       echo $output;

      }
  }
    ?>
Below the what this code outputs:


Student: Mayur Patel (u0867587)
Course: INFO101 - Bsc Information Communication Technology       Course Mark
Year: 3


Module: CHI2550 - Modern Database Applications        Module Mark: 41          Mark Percentage: 68            Grade: B

Session: AAB             Session Mark: 72               Session Weight Contribution 20%

Session: AAE             Session Mark: 67               Session Weight Contribution 40%


Module: CHI2513 - Systems Strategy            Module Mark: 31           Mark Percentage: 62            Grade: B

Session: AAD              Session Mark: 61             Session Weight Contribution 50%


If you look above it shows that there is nothing in the Course Mark: section, what Course Mark is suppose to do is total up all the module mark percentages and then divide it by the number of modules. So the calculation will be adding up all the Code: [Select]
$markGrade and dividing it by count Code: [Select]
$ModuleID. In examle above it will be 68 (mark percentage for 1st module) + 62 (mark percentage for 2nd  module) / 2 (number of modules in the course). So the Course Mark should equal 65. 

The problem is that all of the calculations are in the foreach loop but where the course details and where the course marks are going to be placed are in the while loop. So the problem is that if the total Course Mark (lets say we call in $totalCourse) is displayed in the while loop it will provide an undifined index as the calculation will be placed with the other calculations in the foreach loop which is outside the while loop, if I do the calculation with in the while loop, it will only choose the 1st module mark percentage and divdie it by the first module only, this is obviously incorrect as it sohuld try and do this for all modules hence why my calculations are in the foreach loop which does this.

So how will change the code so that the course details can go from the while loop and be placed in the foreach loop so then I can include the calculation in the foreach loop.

Thank You and hopefully you understand it, just read it very carefully to understand it, it is very simple what I want to achieve but I do not know how to do it.

[attachment deleted by admin]

what is the problem in this code
<div id="product">
    <a class='inline' href="?prod=<?php echo $row['id'];?>#<?php echo $row['id']; ?>"  >
    .....
    </a>
</div>
<div style='display:none'>
   <div id='<?php echo $row['id'];?>'>
   ....
    </div>
</div>

$prod=$_GET['prod'];    
echo "the value of prod".$prod;
$_SESSION['cart']=$prod;


<script>
      $(document).ready(function(){
         //Examples of how to assign the ColorBox event to elements
         $(".inline").colorbox({inline:true});
      });
</script>

Hello I first should say that I am a beginner. And actully friend was helping me with this but can't really contact him right now so I have to ask here. I have a php file where I have birthdate dropdown menu for month, day and a year and JS that just has all of the details about those 3 "variables" but the problem I am having is that this is inside submit form and whenever I or someone else submits this form and doesn't put any birthdate inside it doesn't show anything like "Please select your birthdate or something like that." and I honestly tried pretty much everything now but can' t get the answer on how to do that. Please help me. :(

This topic has been moved to Third Party PHP Scripts.

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

As the topic sais i have a problem trying to send variables to a javascript popup window, i think the problem is on line 38.
I would very much appreciate some help

Code: [Select]
<html>
<head>
<script type="text/javascript">
function newPopup(url)
{
popupWindow = window.open(url,'popUpWindow','height=700,width=400,left=10,top=10,resizable=no,scrollbars=no,toolbar=yes,menubar=no,location=no,directories=no,status=yes')
}
</script>
</head>
<?php
error_reporting(E_ALL);
require_once 'GameQ.php';

$servers = array(
    'server 1' => array('cs', 'd2o.warzone.nu', '27015'),
    'server 2' => array('cs', 'd2o.warzone.nu', '27017'),
    'server 3' => array('cs', 'wc3.warzone.nu', '27017'),
'server 4' => array('cs', 'aim.warzone.nu', '27015'),
'server 5' => array('cs', '83.255.249.204', '27025'),
'server 6' => array('tf2', 'tf2.warzone.nu', '27015'),
'server 7' => array('tf2', '83.255.249.200', '27015'),
'server 9' => array('cssource', 'css.warzone.nu', '27015'),
'server 10' => array('cssource', 'css.warzone.nu', '27017')
);

$gq = new GameQ();
$gq->addServers($servers);
$gq->setOption('timeout', 200);
$gq->setFilter('normalise');
$gq->setFilter('sortplayers', 'gq_ping');

$results = $gq->requestData();

echo "<a href='steam://connect/d2o.warzone.nu:27015'>" . $results["server 1"]['gq_hostname'] . "</a><p>";
echo $results["server 1"]['gq_mapname'] . "<br>";
echo $results["server 1"]['gq_numplayers'] . "/" . $results["server 1"]['gq_maxplayers'];
?> // I think the problem is the line below this one
<a href='JavaScript:newPopup("players.php?address=<?php echo="$results['server 1']['gq_address']"; ?>&port=<?php echo="$results['server 1']['gq_port']"; ?>");'> players online </a>";
<?php
echo "<p><p>";
echo "<a href='steam://connect/d2o.warzone.nu:27017'>" . $results["server 2"]['gq_hostname'] . "</a><p>";
echo $results["server 2"]['gq_mapname'] . "<br>";
echo $results["server 2"]['gq_numplayers'] . "/" . $results["server 2"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/wc3.warzone.nu:27017'>" . $results["server 3"]['gq_hostname'] . "</a><p>";
echo $results["server 3"]['gq_mapname'] . "<br>";
echo $results["server 3"]['gq_numplayers'] . "/" . $results["server 3"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/aim.warzone.nu:27015'>" . $results["server 4"]['gq_hostname'] . "</a><p>";
echo $results["server 4"]['gq_mapname'] . "<br>";
echo $results["server 4"]['gq_numplayers'] . "/" . $results["server 4"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/83.255.249.204:27025'>" . $results["server 5"]['gq_hostname'] . "</a><p>";
echo $results["server 5"]['gq_mapname'] . "<br>";
echo $results["server 5"]['gq_numplayers'] . "/" . $results["server 5"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/tf2.warzone.nu:27015'>" . $results["server 6"]['gq_hostname'] . "</a><p>";
echo $results["server 6"]['gq_mapname'] . "<br>";
echo $results["server 6"]['gq_numplayers'] . "/" . $results["server 6"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/83.255.249.200:27015'>" . $results["server 7"]['gq_hostname'] . "</a><p>";
echo $results["server 7"]['gq_mapname'] . "<br>";
echo $results["server 7"]['gq_numplayers'] . "/" . $results["server 7"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/tf2.warzone.nu:27015'>" . $results["server 8"]['gq_hostname'] . "</a><p>";
echo $results["server 8"]['gq_mapname'] . "<br>";
echo $results["server 8"]['gq_numplayers'] . "/" . $results["server 8"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/css.warzone.nu:27015'>" . $results["server 9"]['gq_hostname'] . "</a><p>";
echo $results["server 9"]['gq_mapname'] . "<br>";
echo $results["server 9"]['gq_numplayers'] . "/" . $results["server 9"]['gq_maxplayers'] . " players online <p>";

echo "<p><p>";
echo "<a href='steam://connect/css.warzone.nu:27017'>" . $results["server 10"]['gq_hostname'] . "</a><p>";
echo $results["server 10"]['gq_mapname'] . "<br>";
echo $results["server 10"]['gq_numplayers'] . "/" . $results["server 10"]['gq_maxplayers'] . " players online <p>";

?>
</html>

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';