PHP - Script Works On Vps But Not On Dedicated Server

Hi guys,

I know this is a bit of a messy question, but i have a problem with some code that my friend wrote, and now i don't know how to fix it.

Basically there is a line of code on my site, and what my friend told me was that this specific line of code has to do with the server and is similar to a ticking clock.

What he told me is that it is a "counted related value" which needs to been changed every now and then when it hits the servers limit.

This actually means nothing to me, but i'm hoping some one out there knows what my friend means. Anyway this is the line of code i need to change, or in fact the number i need to change. The problem is that as i dont really know what i'm doing i have no idea as to what to change the number to.

Please help guys, I really need to fix this asap. Anyways this is the code:

// unique references
define ('NID', floor(hexdec(substr(uniqid(''),0,11))/100)-52330000000); // table id
define ('SID', strtoupper(uniqid(''))); // short unique id
define ('UID', strtoupper(md5(uniqid('')))); // 32char id

Its the number 52330000000 that i had to change the last time i had this problem.

Many thanks in advance.

Hi,
 My program works on WAMP (PHP Version 5.5.12) running on my machine. However, the same program will not run on remote server (PHP Version 5.4.32). Basically, I'm trying to insert values obtained from a form into a database. I've checked and rechecked the table I'm inserting into and I can't find anything wrong with it. The trouble is it's hard to debug a PHP program. Unlike, say, C++ which requires a compiler, you can trace the program line by line to look for errors. That's not possible with PHP and makes it so much harder to look for faults.
 The relevant functions used to send data to database are shown below. insert() is returning false every time and I can't understand why! I wonder if anyone can suggest where things might be going wrong. I would be very grateful.
 

public function insert($table, $fields = array())
   { if(count($fields)) //true if $fields holds data
     { $keys = array_keys($fields);

       $values = '';  //to put inside query
       
       $x = 1;

      foreach($fields as $field)
      { $values .= '?';
        if($x < count($fields))
        { $values .= ', ';
        }
        $x++;
      }
   $sql = "INSERT INTO {$table} (`".implode('`, `', $keys) . "`) VALUES({$values})";
      if(!$this->query($sql, $fields)->error())
      { return true;
      }
     }
     return false;
   }

  public function query($sql, $darams = array())
  {
    $this->_error = false;   //reset error
    if($this->_query = $this->_pdo->prepare($sql))
    { $x = 1;
      if(count($darams))
      { foreach($darams as $param)
        { $this->_query->bindValue($x, $param);
          $x++;
        }
      }
      if($this->_query->execute())
      { $this->_results = $this->_query->fetchAll(PDO::FETCH_OBJ);
        $this->_count = $this->_query->rowCount();
      }
      else      //an error has occured in SQL query
      { $this->_error = true;
      }
    }
    return $this;
  }

  public function error()
  { return $this->_error;
   }

   public function count()
   { return $this->_count;
   }

I was hoping someone could help me figure out why my
  Code: [Select]
header('Location: .');works right on my localhost testing computer but not when I load it onto the actual server.

Here are the two files in question.  The first is a snippet from my index.php controller file.
Code: [Select]
if (isset($_POST['action']) and $_POST['action'] == 'Edit')
{
include '../../includes/db.inc.php';
  {
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "Select * from s_times where id = '$id'";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching service time details ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

$row = mysqli_fetch_array($result);
$pagetitle = 'Edit Category';
$action = 'editform';
$id =  $row['id'];
$day = $row['day'];
$time =  $row['time'];
$event =  $row['event'];
$avail =  $row['avail'];
$orderby = $row['orderby'];
$button = 'Update';

 }
include 'stimes_modify.php';
exit();
}

if (isset($_GET['editform']))
{
include '../../includes/db.inc.php';

$id = mysqli_real_escape_string($link, $_POST['id']);
$day = mysqli_real_escape_string($link, $_POST['day']);
$time = mysqli_real_escape_string($link, $_POST['time']);
$event = mysqli_real_escape_string($link, $_POST['event']);
$avail = mysqli_real_escape_string($link, $_POST['available']);
$orderby = mysqli_real_escape_string($link, $_POST['orderby']);
$sql = "Update s_times set
day = '$day',
time = '$time',
event = '$event',
avail = '$avail',
orderby = '$orderby'
where id = '$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error updating service times ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

header('Location: .');
exit();
}


here is the stimes_modify.php file code
Code: [Select]
if (isset($_POST['action']) and $_POST['action'] == 'Edit')
{
include '../../includes/db.inc.php';
  {
$id = mysqli_real_escape_string($link, $_POST['id']);
$sql = "Select * from s_times where id = '$id'";
$result = mysqli_query($link, $sql);
if (!$result)
{
$error = 'Error fetching service time details ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

$row = mysqli_fetch_array($result);
$pagetitle = 'Edit Category';
$action = 'editform';
$id =  $row['id'];
$day = $row['day'];
$time =  $row['time'];
$event =  $row['event'];
$avail =  $row['avail'];
$orderby = $row['orderby'];
$button = 'Update';

 }
include 'stimes_modify.php';
exit();
}

if (isset($_GET['editform']))
{
include '../../includes/db.inc.php';

$id = mysqli_real_escape_string($link, $_POST['id']);
$day = mysqli_real_escape_string($link, $_POST['day']);
$time = mysqli_real_escape_string($link, $_POST['time']);
$event = mysqli_real_escape_string($link, $_POST['event']);
$avail = mysqli_real_escape_string($link, $_POST['available']);
$orderby = mysqli_real_escape_string($link, $_POST['orderby']);
$sql = "Update s_times set
day = '$day',
time = '$time',
event = '$event',
avail = '$avail',
orderby = '$orderby'
where id = '$id'";
if (!mysqli_query($link, $sql))
{
$error = 'Error updating service times ' . mysqli_error($link);
include '../../includes/error.php';
exit();
}

header('Location: .');
exit();
}


The functionality of both pages seems to be working in relation to editing the database but the page will not redirect back to the main page when it gets back down to the header line.  Like I said it works on localhost just not on actual server.  I also tried putting in the full URL like this
Code: [Select]
header('Location: http://www.bbcpa.org/dbsite/admin/stimes/stimes/php');and still got a blank page.

The URL in the address bar shows this
http://www.bbcpa.org/dbsite/admin/stimes/?editform
it should show this
http://www.bbcpa.org/dbsite/admin/stimes/
so maybe something is wrong with this line in stimes_modify.php
Code: [Select]
<form action="?<?php htmlout($action); ?>" method="POST">
anyway any help would be greatly appreciated.
Thanks

So, I'm trying to read a file from a different filepath than the current working directory.    I have some simple PHP like this :

<?php
 
    $input_map = "readfile.php";
    $map_contents = file_get_contents($input_map);
    echo $map_contents."<br />\n";
?>

And this'll work fine because it's in the same directory but if I try to set $input_map = "/home/...", the browser will return an empty string. This script will work from the command line though. So how do I get file_get_contents() to read from the server's file structure instead of just the working directory?   Edit : For example, this will not work through the browser :

<?php
 
    $input_map = 
"/home/...";
    $map_contents = file_get_contents($input_map);
 
    echo $map_contents."<br />\n";
    var_dump($map_contents);
?>

Edited by MutantJohn, 21 January 2015 - 06:35 PM.

    
    $account="54646456456464";
    $station= "12345";
    $options="11-1";
    $image="C:/Desktop/Sample Images/usco1.jpg";
    
    
$ch = curl_init();

curl_setopt($ch, CURLOPT_URL,"http://dfdgfsfs.com/kgdfgd.php");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, array(
            'image' => '@'.$image, 'account' => $account, 'station' => $station, 'options' => $options));


$postResult = curl_exec($ch);


curl_close ($ch);

$xmlobj = simplexml_load_string($postResult);

echo (string)$xmlobj->ID->attributes()->value;
echo (string)$xmlobj->FullName->attributes()->value;

All, I have spend days trying to figure this out without any luck.  I am now in crisis mode.  I need to get this working asap.  The following code works perfect on my local xampp machine.  As soon as I upload it to my web server, I don't get any data back.  I have narrowed it down to the image i am trying to send is not being received properly.  Thanks in advance.

Hi all,

I wonder if any of you have this problem before..

I have a login page with "checked box remember me" - It is working fine in my localhost machine I can see the COOKIE in my browser's option setting (Firefox).

But now the problem is: When I run the script in my test server; and do exactly the same thing..the COOKIE did not seem know.

When I logged in as an admin and checked the box. And closed all the browser. Then, open the browser (Firefox)and go to the index page (landing page) then it redirect me to the login page instead. I looked the at COOKIE setting in my Firefox and I can it is stored there.

Any ideas whats wrong?

Hi guys, I need a help to find out what is a problem. Some of my code does not work on my local comp and in the same time it works well when I place it on Internet server.
First example:
Code: [Select]
<body>
<?php 
if($_POST['submit_form'] == "Submit") 
{ $varNewTeam = $_POST['Reg_Team']; 
$varNewCity = $_POST['Reg_City']; 

 $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m ,$db) or die('DB error');
mysql_query ("INSERT INTO reg2012 VALUES ('$varNewTeam','$varNewCity')") or die('insert error');
} 
?>
<form action="registration_2012_form.php" method="post">
<p>Team: <input type="text" name="Reg_Team" size="20" maxlength="50" value="<?=$varNewTeam;?>" /><br /></p>
<p>City: <input type="text" name="Reg_City" size="20" maxlength="50" value="<?=$varNewCity;?>" /><br /></p>
<p><input type="Submit" value="Submit" name="submit_form" /></p>
</form>
</body>
On local comp: It gives me message "Undefined index: submit_form".
On Net server works well.
If I split the code in two files. In the first one I leave the form with "action=FILE2.php" and put my php code in the second file "FILE2.php" - it starts work even on local server.

second example:
Code: [Select]
<body>
<?php 
  $db = mysql_connect('localhost', 'root', '') or die ('no connection with server');
  mysql_select_db('db_m' ,$db) or die('DB error');
mysql_query ("CREATE TABLE temp1 (team char(50), city char(50) )") or die('create tables error');
?>
</body>
It works in the Net and can not create the TABLE on my local comp.

I use XAMPP on my local comp (if it's important)

I have the following 2 scripts. One adds to the database and the other deletes a record from the database.
Code: [Select]

<form action="deletebidder.php" method="post">
<table>
<tr>    <td><font face ="calibri" size="4"> Add Bidder:</td>
</tr>
<tr>    <td><input type="text" name="biddersId" /></td>
</tr>
<tr>    <td><input type="hidden" name="addedbidder" /></td>
</tr>
<tr>    <td><input type="Submit"  value="Add"></td>
</tr>
</table>
Second from:
Code: [Select]
<form name="deletebidder" action="process_bidders2.php" method="post">

<table>
<tr>   <td><font face= "calibri" size= "3"> Delete Bidder</font></td>
</tr>
<tr>   <td><input type= "text" name="deletebidder" /></td>
</tr>
<tr>   <td><input type= "hidden" name="deletebidder1" /></td>
</tr>
<tr>   <td><input type= "submit" value= "submit" /></td>
</tr>
</table>
</form>
Both forms are on the same page. Now I have tried separate processing pages with the same results (If i get one to work the other doesn't, it's either one or the other, but they won't work together.
 If i have the add bidder working, the delete bidder doesn't work and visa versa??
Also, ONE IMPORTANT note is, if i try to process each form on separate pages, no matter what action "name" i give the form, it will only go to the action page that is working.
Example is, I tried to process one form on deletebidder.php and the other on process_bidders2.php but it didn't matter. Both forms were processed by the deletebidder.php page. How is this even possible if I gave them both seperate action "paths"??

Code: [Select]
<?php
ob_start();

error_reporting(E_ALL);
ini_set("display_errors", 1);

$biddersId= $_POST['biddersId'];

if (isset($addedbidder)) \\hidden form field
{
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM bidders WHERE biddersId='$biddersId'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);


if($count==0){
// Add $biddersId to DB and redirect to anypage
mysql_Query("INSERT INTO bidders (biddersId)
VALUES ('$biddersId')");
 header("Location: attendance.php");
exit();

}
}
if (isset($deletebidder1)) \\hidden form field
{
$biddersId= $deletebidder;
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_query("DELETE FROM bidders WHERE biddersId='$biddersId'");
 header("Location: attendance.php");
exit();
}
ob_flush();
  


echo "<font color= \"red\" face=\"calibri\" size=\"4\">That bidder is already logged, Please press your browsers back button and try again.</font>";

?>

I am just helping out a friend with his online store that he would like to add multiple currencies to. I made this script to help him out:
$price = 99.95;
$default_currency = 20;
// displays all the file nodes
if(!$xml=simplexml_load_file('http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml')){
    trigger_error('Error reading XML file',E_USER_ERROR);
} else { 
$array['currency'][1] = 'EUR';
$array['value'][1] = 1.00;
$i = 2;
foreach ($xml->Cube->Cube->children() as $node) {
$arr = $node->attributes();   // returns an array
$array['currency'][$i] = $arr['currency'];
$array['value'][$i] = $arr['rate'];
$i++;
}
}
if (isset($_POST['currency'])){
$currency = $_POST['currency'];
} else {
$currency = $default_currency;
}
$price = $array['value'][$currency] / $array['value'][$default_currency] * $price;
$price = round($price, 2);
$currency_name = $array['currency'][$currency];
echo '<p>Price is '.$currency_name.$price.'<br />
To change currency, select from dropdown box below.</p>';
echo '<form action="currency.php" method="post"><select name="currency">';
$i = 1;
foreach ($array['currency'] as $value){
echo '<option value="'.$i.'">'.$value.'</option>';
$i++;
}
echo '</select><br /><input type="submit" /></form><br />';

$i = 1;
foreach ($array['currency'] as $value){
echo '<p>'.$value.' = '.$array['value'][$i].'</p>';
$i++;
}

But for some reason it only works some of the time and I can't work out why for the life of me.

If I could get some help in the matter, that would be greatly appreciated.

A link to the above example can be found here.

Regards,

I.

I have created a script (single file) that works fine when testing it alone, but when included it doesn't and rest of page is blank.

What could cause this? Is this because of some "mismatch" between the queries, variables used on the included file and the existing file?

My school is running PHP 4.3.2 on its network, and I'm running PHP 5.3.1 on my localhost machine using Xampp/Apache.

My login system works perfectly at school, however $_SESSION["LoggedIn"] does not register, recognise nor acknowledge on my home system.

It's not the script itself as I've copied the files across, so in theory it should work exactly the same?

I've compared phpinfo()'s and within the session category all values are the same.

The database/MySQL works fine on both networks so it's not a problem to do with this.

Any ideas? Thanks.

Can someone propose a solution to resolve the following:

I have a PHP script that runs just fine when processing small amounts of data (opening and reading CSV file and performing afew validation checks before saving to db).

Issue: when attempting to process a large file, I have found the execution time exceeds the "timeout" value currently set on the server which is 60 seconds.
Note: I do not want to increase this time interval as that's a security risk so need to figure out a way to break up the data - being read from the CSV file - into chunks and some way create mini-processes (I guess) to execute chunks of that data at a time until the entire file is read.

Any suggestions?

Well the subject line is pretty explicit.  I found this script that uploads a picture onto a folder on the server called images, then inserts the the path of the image on the images folder onto a VACHAR field in a database table. 
Code: [Select]




<?php

//This file inserts the main image into the images table.

//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);





//authenticate user
//Start session
session_start();

       
        //Connect to database
require ('config.php');

//Check whether the session variable id is present or not. If not, deny access.
if(!isset($_SESSION['id']) || (trim($_SESSION['id']) == '')) {
header("location: access_denied.php");
exit();
}

        else{ 







// Check to see if the type of file uploaded is a valid image type

function is_valid_type($file)

{

     // This is an array that holds all the valid image MIME types

     $valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif");

 

     if (in_array($file['type'], $valid_types))

         return 1;

     return 0;

}

 

// Just a short function that prints out the contents of an array in a manner that's easy to read

// I used this function during debugging but it serves no purpose at run time for this example

function showContents($array)

{

     echo "<pre>";

     print_r($array);

     echo "</pre>";

}

 

// Set some constants

 

// This variable is the path to the image folder where all the images are going to be stored

// Note that there is a trailing forward slash

$TARGET_PATH = "images/";

 

// Get our POSTed variable

$image = $_FILES['image'];

 

// Sanitize our input

$image['name'] = mysql_real_escape_string($image['name']);

 

// Build our target path full string.  This is where the file will be moved to

// i.e.  images/picture.jpg

$TARGET_PATH .= $image['name'];

 

// Make sure all the fields from the form have inputs

if ( $image['name'] == "" )

{

     $_SESSION['error'] = "All fields are required";

     header("Location: member.php");

     exit;

}

 

// Check to make sure that our file is actually an image

// You check the file type instead of the extension because the extension can easily be faked

if (!is_valid_type($image))

{

     $_SESSION['error'] = "You must upload a jpeg, gif, or bmp";

     header("Location: member.php");

     exit;

}

 

// Here we check to see if a file with that name already exists

// You could get past filename problems by appending a timestamp to the filename and then continuing

if (file_exists($TARGET_PATH))

{

     $_SESSION['error'] = "A file with that name already exists";

     header("Location: member.php");

     exit;

}

 

// Lets attempt to move the file from its temporary directory to its new home

if (move_uploaded_file($image['tmp_name'], $TARGET_PATH))

{

     // NOTE: This is where a lot of people make mistakes.

     // We are *not* putting the image into the database; we are putting a reference to the file's location on the server

     $sql = "insert into images (member_id, image_cartegory, image_date, image) values ('{$_SESSION['id']}', 'main', NOW(), '" . $image['name'] . "')";

     $result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());

     header("Location: images.php");

echo "File uploaded";

     exit;

}

else

{

     // A common cause of file moving failures is because of bad permissions on the directory attempting to be written to

     // Make sure you chmod the directory to be writeable

     $_SESSION['error'] = "Could not upload file.  Check read/write persmissions on the directory";

     header("Location: member.php");

     exit;

}







        } //End of if session variable id is not present.
 


?> 


The script seems to work fine because I managed to upload a picture which was successfully inserted into my images folder and into the database.
Now the problem is, I can't figure out exactly how to write the script that displays the image on an html page. I used the following script which didn't work.


Code: [Select]

//authenticate user
//Start session
session_start();

       
        //Connect to database
require ('config.php');

$sql = mysql_query("SELECT* FROM images WHERE member_id = '".$_SESSION['id']."' AND image_cartegory = 'main' ");
$row = mysql_fetch_assoc($sql);
$imagebytes = $row['image'];
header("Content-type: image/jpeg");
print $imagebytes;







Seems to me like I need to alter some variables to match the variables used in the insert script, just can't figure out which.  Can anyone help??

I have a very weird problem. On my website i have a script that takes random pages and displays them on the homepage. It works without a problem on its own but when i have it included in the homepage using include('webmaster fav.php'); i get this error: Warning: Cannot use a scalar value as an array in /mnt/w0210/d28/s25/b02a8bb2/www/webmaster fav.php on line 18
and this error: Warning: array_unique() [function.array-unique]: The argument should be an array in /mnt/w0210/d28/s25/b02a8bb2/www/webmaster fav.php on line 20
and this error: Warning: array_unique() [function.array-unique]: The argument should be an array in /mnt/w0210/d28/s25/b02a8bb2/www/webmaster fav.php on line 21
and this error: Warning: Cannot use a scalar value as an array in /mnt/w0210/d28/s25/b02a8bb2/www/webmaster fav.php on line 23
I am kindof new to php but i think its a good script and it works without errors when it isn't included on the homepage it works. what could be the problem?
heres the code:
<?php 
$directory = "/mnt/w0210/d28/s25/b02a8bb2/www/data/";
//the list of pages i want to be random on the site

$directory = (!strstr($directory,"*") || $directory =="./" ) ? $directory."*" : $directory;
//Checks if the wildcard operator is present, and if not it adds it by default at the end;

$files = glob($directory);
//Yes, it was that easy to get all the files;
$size=sizeof($files);
for($i=0;$i<sizeof($files) ; $i++){
  //Loop through the files and adds to array;
$fp = fopen($files[$i],"r");
$contents[$i]=fgets($fp,999);
fclose($fp);
}
for($x=0;$x<15;$x++){
$numb[$x]=rand(1, sizeof($files));
} 
$x=count($numb)-count(array_unique($numb));
$num = array_unique ($numb); 
for($q=0;$x<15;$x++){
$numb[$x]=rand(1, sizeof($files));
} 

//$imploded = implode(" ", $contents); //get rid of spaces
//$newcontent=explode("~", $imploded); // sort into chucks so i can display the data.
for($i=0;$i<15; $i++){
$number=$num[$i];
if($contents[$number]==""||$contents[$number]==" "||$contents[$number]==null){
}
else{
echo "<li>";
$replacedcontent=str_replace(' ', '-',$contents[$number]);
echo "<br/><a href='games/$replacedcontent'>";
$newrcontent=str_replace('-', ' ',$replacedcontent);
echo "<img src='$newrcontent.jpg' border='2'></img>";
echo "<br/>$newrcontent</a></li>";
}
}
?>

i copied and pasted it from many sites examples so thats why some comments are weird... but basically it gets all the data files. reads the title and puts them in an array, then chooses some random ones and puts them in with their image so they can be displayed on the homepage.

I have a really weird problem.
I'm trying to run a mysql query that works fine in phpmyadmin but in php script is giving me an error.
The query is:

Code: [Select]
(SELECT DISTINCT art.`TEMPLATE`,gal.`ARTICLE_ID`,art.`TITLE`,art.`DESCRIPTION`,MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`) AGAINST ('WORD*' IN BOOLEAN MODE) AS score
FROM articles art,galeries gal
WHERE gal.`ARTICLE_ID`=art.`ARTICLE_ID` AND MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`)
AGAINST ('WORD* ' IN BOOLEAN MODE))
UNION
(SELECT DISTINCT `TEMPLATE`,`ARTICLE_ID`,`TITLE`,`DESCRIPTION`,MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`)
AGAINST ('WORD* ' IN BOOLEAN MODE) AS score
FROM articles
WHERE (MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`) AGAINST ('WORD* ' IN BOOLEAN MODE)))
ORDER BY score DESC LIMIT 0,30
Snipset from php script code:


function search($start_row,$ammount,$search_key,$pages){
        $start_row = intval($start_row) * $ammount;

        $return_val = "";
        $symbols = array('/','\\','\'','"',',','.','<','>','?',';',':','[',']','{','}','|','=','+','-','_',')','(','*','&','^','%','$','#','@','!','~','`'

);//this will remove punctuation
        $pattern = "#[^(\w|&#945;|&#946;|&#947;|&#948;|&#949;|&#950;|&#951;|&#952;|&#953;|&#954;|&#955;|&#956;|&#957;|&#958;|&#959;|&#960;|&#961;|&#963;|&#964;|&#965;|&#966;|&#967;|&#968;|&#969;|&#913;|&#914;|&#915;|&#916;|&#917;|&#918;|&#919;|&#920;|&#921;|&#922;|&#923;|&#924;|&#925;|&#926;|&#927;|&#928;|&#929;|&#931;|&#932;|&#933;|&#934;|&#935;|&#936;|&#937;|&#962;|&#940;|&#941;|&#972;|&#943;|&#973;|&#974;|&#942;|&#970;|&#971;|&#912;|&#944;|&#902;|&#904;|&#908;|&#906;|&#910;|&#911;|&#905;|&#938;|&#939;|\d|\'|\"|\.|\!|\?|;|,|\\|\/|\-|:|\&|@)]+#";

        $search_key = greek_text::to_upper($search_key);
        $wc = strip_tags($search_key);
        $wc = preg_replace($pattern, " ", $wc);

        for ($i = 0; $i < sizeof($symbols); $i++) {

                $wc = str_replace($symbols[$i],' ',$wc);
        }

        $wc = str_replace("&#900;", " ", $wc);
        $wc = str_replace(chr(162), " ", $wc);

        if( !$keep_numbers ) {
            $wc = preg_replace('#(^|\s+)[\d\s]+(\s+|$)#',' ',$wc);
            $pattern = '#(^|\s+)([0-9]+[a-zA-Z&#945;&#946;&#947;&#948;&#949;&#950;&#951;&#952;&#953;&#954;&#955;&#956;&#957;&#958;&#959;&#960;&#961;&#963;&#964;&#965;&#966;&#967;&#968;&#969;&#913;&#914;&#915;&#916;&#917;&#918;&#919;&#920;&#921;&#922;&#923;&#924;&#925;&#926;&#927;&#928;&#929;&#931;&#932;&#933;&#934;&#935;&#936;&#937;&#962;&#940;&#941;&#972;&#943;&#973;&#974;&#942;&#970;&#971;&#912;&#944;&#902;&#904;&#908;&#906;&#910;&#911;&#905;&#938;&#939;]+\s*)+(\s+|$)#';
            preg_match($pattern,$wc,$aa);
            $wc = preg_replace($pattern, " ", $wc);
        }
        $wc = trim(preg_replace("/\s\s+/", " ", $wc));
        $wc = explode(" ", $wc);
        $cleaned_keyword = array_filter($wc);

        $cleaned_keyword = greek_text::removeStopWordsFromArray($cleaned_keyword);
        $stemmed_keywords = greek_text::stemWordsArray($cleaned_keyword);

        $query = "(SELECT DISTINCT art.`TEMPLATE`,gal.`ARTICLE_ID`,art.`TITLE`,art.`DESCRIPTION`,MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`) AGAINST ('";

        while(list($key,$val)=each($stemmed_keywords)){
                if($val<>" " and strlen($val) > 1){
                        $query .= $val."*";
                        $search_keys .= $val."* ";

                }
        }

        $query .= "' IN BOOLEAN MODE) AS score FROM articles art,galeries gal WHERE gal.`ARTICLE_ID`=art.`ARTICLE_ID` AND MATCH(art.`TITLE`,art.`DESCRIPTION`,gal.`CONTENT`) AGAINST ('".$search_keys."' IN BOOLEAN MODE))";
        $query .= " UNION (SELECT DISTINCT `TEMPLATE`,`ARTICLE_ID`,`TITLE`,`DESCRIPTION`,MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`) AGAINST ('".$search_keys."' IN BOOLEAN MODE) AS score FROM articles WHERE (MATCH(`TITLE`,`DESCRIPTION`,`CONTENT`) AGAINST ('".$search_keys."' IN BOOLEAN MODE))) ORDER BY score DESC LIMIT ".intval($start_row).",".$ammount;
                
        $rs = $this->dbActions->execQuery($query);
        $this->dbActions->execQuery("INSERT INTO searches (`KEY`,`DATE`,`RESULTS`) VALUES ('".$search_key."',NOW(),".$pages.")");
        $search_results = "<div id='results'>";
        while($row = mysql_fetch_array($rs)){           
           $search_results.= "<div id='result'>";
           $search_results.= "<div class='result_title'><h4><a href='article.php?articleId=".$row["ARTICLE_ID"]."'>".$row['TITLE']."</a></h4></div>";
           $search_results.= "<div class='result_description'>".$row['DESCRIPTION']."</div>";
           $search_results.= "</div>";
           $search_results.= "<div class='result_seperator'></div>";
        }
        $search_results .= "</div>";
        $return_val = $search_results;

        return $return_val;
    }


dbactions class:


require 'includes/errors.php';
error_reporting(0);

class DBActions{

var $dbCon;

var $errorHandler;

function DBActions(){

$this->dbCon = $this->dbCon();

$errorHandler = new errors(1);

}

private function dbCon(){

require 'conf/configuration.php';

$dbcon = mysql_connect($dbUrl,$dbUser,$dbPass);

if(!$dbcon)trigger_error("Unable to connect to database $dbUrl for user $dbUser",E_USER_ERROR);

mysql_select_db($dbName);

mysql_query("SET NAMES 'UTF8'");

mysql_query('set character set utf8');

return $dbcon;

}

function dbClose(){

if($this->dbCon)

mysql_close($this->dbCon);

}

function execQuery($query){

              
                $result = mysql_query($query,$this->dbCon);
                                               

$msg = "Unable to execute query ".$query;
                if(mysql_num_rows($result) > 0)

return $result;

else if($result == false)

trigger_error($msg,E_USER_ERROR);

else

return $result;

}

function send_error_mail(){

$this->errorHandler->sendErrorEmail();

}
}


I've try everything but can't get this working..
Any healp whould be really appreciated.

Thanks in advance.