PHP - Ajax Calling Not Encoding In Utf-8(ie) Problem

I submit text to my MySQL database using a form on my site. When I look at the text in my database, sometimes, there are strange characters. The strange characters are caused by quotation marks, em dashes, apostrophes and foreign letters of the alphabet. I think that this only happens when the source of the text is a Windows program. I understand that this is a character encoding issue, but I don't fully understand the subject. I've spent the last few hours researching it, but it's only confused me.   My site uses UTF-8 encoding:

<meta http-equiv="content-type" content="text/xml; charset=utf-8" />

The collation of my database is utf8_general_ci.   My form looks like this:

<form action="" method="post">
</form>

As you can see, an accept-charset="utf-8" attribute has not been specified.     Questions   1) I am guessing that my problem is that the Windows characters are being misinterpreted by my UTF-8 setup. Is that correct?   2) If so, is there a way that I can safely convert the Windows characters to UTF-8 during the submission process?   3) Should I also specify an accept-charset="utf-8" attribute on the form?   4) When I paste the Windows text directly into my database without using the form, the characters save without turning into the strange characters. But they don't render properly on my site. Can't browsers identify Windows characters?

Hi, I'm using an EPP for boring stuff that wont interest you guys anyway.

The problem I'm having is the EPP comes with its own API which parses XML for you.

The problem with it parsing XML is that the XML that is received comes in a format which has :'s in the keys.

Example:

Code: [Select]
SidnEppResult Object
(
    [message:SidnEppResult:private] =>
    [status:SidnEppResult:private] => domain_unavailable
    [code:SidnEppResult:private] =>
    [notifyUser:SidnEppResult:private] =>
)

Then I want to be able to put this information to use, so I call the constants like this:
Code: (php) [Select]
<?php
echo $object->status:SidnEppResult:private;

The problem then is that PHP throws me a little parse error.

Any help is appreciated,

Chris

As the title say, I can not for the life of me get the "$bank" content to display, no matter HOW much I try...
Does anyone see any errors. I am sooooooo wiped out at this!


main page

<?
$body = '

<script type="text/javascript" src="change-content.js"></script>

<div id="addSold">
<form action="'.$_SERVER['REQUEST_URI'].'" method="post" name="form" autocomplete="off">

<fieldset id="Vehicle">
<legend>Vehicle</legend>
<ul>
<li><label for="Year">Year</label>'.$Year.'</li>
<li><label for="Make">Make</label>'.$Make.'</li>
<li><label for="Model">Model</label>'.$Model.'</li>
<li><label for="Trim">Trim</label><input type="text" name="Trim" id="Trim" size="10" value="'.$trim.'" disabled="disabled"></li>
</ul>
<ul>
<li><label for="Mileage">Mileage</label><input type="text" name="Mileage" id="Mileage" size="5" maxlength="6" value="'.$row['mileage'].'"></li>
<li><label for="VIN">VIN</label><input type="text" name="VIN" id="VIN" size="23" maxlength="17" value="'.$row['vin'].'" disabled="disabled"></li>
<li><label for="Color">Color</label>'.$Exterior.'</li>
</ul>
</fieldset>

<fieldset id="Deal">
<legend>Deal</legend>
<ul>
<li>
<label for="soldDte1">Date</label>
<input type="text" name="soldDte1" id="soldDte1" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="08"> / 
<input type="text" name="soldDte2" id="soldDte2" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="30"> / 
<input type="text" name="soldDte3" id="soldDte3" size="1" maxlength="2" value="'.$year.'">
<a href="#"><img id="date_'.$row[stock].'" src="images/Icons/dateOff.png" onfocus="this.select();lcs(this)" onmouseover="MM_swapImage(\'date_'.$row[stock].'\',\'\',\'images/Icons/dateOn.png\',1)" onmouseout="MM_swapImgRestore()" alt="Choose Date"></a>
</li>
<li>
<label for="salesman">Salesman</label> 
<select name="salesman" id="salesman">
<option></option>
'.$salesmen.'
</select>
</li>
</ul>
<ul>
<li>
<label for="dealType">Deal Type</label>
<select name="dealType" class="select-content" onchange="getFile(this.value)">
<option></option>
<option value="AL">Auto Loan</option>
<option value="Cash">Cash</option>
<option value="CAC">Credit Acceptance</option>
<option value="IH">In House</option>
<option value="SAL">Sensible Auto</option>
</select>
</li>
<li>
<label for="tradeDrop">Trade</label> 
<select name="tradein" id="tradeDrop" onchange="show_hide_trade(this.value);">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
</li>
</ul>
</fieldset>

<div id="Bank" class="view">'.$bank.'</div>
</form>
</div>
';
?>


get_Bank.php

<?
if ($_GET['dealType'] == "AL") {
$bank = '
<fieldset id="AL">
<legend>Auto Loan Figures</legend>
<ul>
<li><label for="price">Price</label><input type="text" name="price" id="price" class="price" size="7" onchange="currency(this)"></li>
<li><label for="down">Down</label><input type="text" name="down" id="down" class="price" size="6" onchange="currency(this)"></li>
<li><label for="tax">Tax</label><input type="text" name="tax" id="tax" class="price" size="6" onchange="currency(this)"></li>
<li><label for="reg">Plates</label><input type="text" name="reg" id="reg" class="price" size="4" onchange="currency(this)"></li>
<li><label for="gap">Gap</label><input type="text" name="gap" id="gap" class="price" size="4" onchange="currency(this)"></li>
</ul>
<ul>
<li>
<label for="pymtNum">--------------- Payment ---------------</label>
<input type="text" name="pymtNum" id="pymtNum" size="3" maxlength="3" onkeyup="return autoTab(this, 3, event)"> @ 
<input type="text" name="pymtAmnt" id="pymtAmnt" class="price" size="5" onchange="currency(this)"> per 
<select name="pymtType">
<option value="Weekly" selected="selected">Week</option>
<option value="Monthly">Month</option>
</select>
</li>
<li><label for="APR">APR</label><input type="text" name="APR" id="APR" class="rate" size="6" value="19.00"></li>
</ul>
</fieldset>
';
} elseif ($_GET['dealType'] == "CAC") {
$bank = '
Credit Acceptance stuff goes here
';
} else {
$bank = 'You must choose a bank before continuing';
}

?>


change-content.js
Code: [Select]
window.onload = init;

// finds all <select> tags will class="select-content" and activates function
function init() {
var sel = document.getElementsByTagName("select");
for (var i=0; i<sel.length; i++){
if (sel[i].className == "select-content") {
sel[i].onchange = getFile;
}
sel[i].selectedIndex = 0;
}
}

function getFile (url) {
var url = "AJAX/get_Bank.php?dealType="+ this.value;
if (window.XMLHttpRequest) {xmlhttp=new XMLHttpRequest();}
else {xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");}

xmlhttp.open("GET",url,false);
xmlhttp.send();

// a loop that looks through all <div>s on the page
// and then replaces the id with the value and gets that file
var divs = document.getElementsByTagName("div");
for (var i=0; i<divs.length; i++) {
if(divs[i].id == "bank") {
divs[i].id = this.value;
divs[i].innerHTML=xmlhttp.responseText;
}
}
}

The Ajax Code:
Code: [Select]
<script language="javascript" type="text/javascript">
<!--
//Browser Support Code
function ajaxFunction(){
var ajaxRequest;  // The variable that makes Ajax possible!

try{
// Opera 8.0+, Firefox, Safari
ajaxRequest = new XMLHttpRequest();
} catch (e){
// Internet Explorer Browsers
try{
ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try{
ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
} catch (e){
// Something went wrong
alert("Your browser broke!");
return false;
}
}
}
// Create a function that will receive data sent from the server
ajaxRequest.onreadystatechange = function(){
if(ajaxRequest.readyState == 4){
var ajaxDisplay = document.getElementById('ajaxDiv');
ajaxDisplay.innerHTML = ajaxRequest.responseText;
}
}
var pic = document.getElementById('pic').value;

var queryString = "?pic=" + pic;
ajaxRequest.open("GET", "ajax-example.php" + queryString, true);
ajaxRequest.send(null);
}

//-->
</script>

The PHP code:
Code: [Select]
<?php
require_once("configure.php");
mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database" . mysql_error());
@mysql_select_db("$DBName") or die("Unable to select database $DBName" . mysql_error() );
$user_sqla = "select * from $emaila " ;

while($user_array = mysql_fetch_array($user_resulta)) 
{
$pictures = $user_array[picture];
?>
<form name='myForm'>
<?php


echo "<div align='left' style='padding-left:25px'><table border='1'><tr><td><img src=".$pictures." width='65' height='65'><input type='hidden' name='pic' id='pic' value=".$pictures.">". $pictures;?></td>
<td><div style="padding-left:5px; padding-top:15px"><?php echo "<a  href='#' onclick='ajaxFunction()' >Remove</a></td></tr></table></div>"; ?></div>
     </form><?php } ?>

the ajax-example.php code:
Code: [Select]
<?php

// Retrieve data from Query String
$age = $_GET['pic'];


echo $age;
?>


Now the Php code gives the following result:

"image1" "Remove"
"image2" "Remove"
"image3" "Remove"

when I click the "Remove" the result I keep getting is "image1" even if I click the remove beside image3 I still get the Image1 Name transffered from my ajax code to the ajax-example.php page

Evening fellow freaks

I am having a major problem with what I think is quite a simple script, its basically just a ajax same page registration script that is throwing up some php errors. I am not sure if the error lies in the php or js, or both!

Ill post the scripts and then explain the problem

login.php
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.js"></script>
<script type="text/javascript">
$(document).ready(function() {

//if submit button is clicked
$('#signin_submit').click(function () {

//Get the data from all the fields
var username = $('input[name=username]');
var email = $('input[name=email]');
var password = $('input[name=password]');


//Simple validation to make sure user entered something
//If error found, add hightlight class to the text field
if (username.val()=='') {
name.addClass('hightlight');
return false;
} else name.removeClass('hightlight');

if (email.val()=='') {
email.addClass('hightlight');
return false;
} else email.removeClass('hightlight');

if (password.val()=='') {
comment.addClass('hightlight');
return false;
} else password.removeClass('hightlight');

//organize the data properly
var data = 'username=' + username.val() + '&email=' + email.val() + '&password=' + 
password.val();

//disabled all the text fields
$('.text').attr('disabled','true');

//show the loading sign
$('.loading').show();

//start the ajax
$.ajax({
//this is the php file that processes the data and send mail
url: "processreg.php",

//GET method is used
type: "GET",

//pass the data
data: data,

//Do not cache the page
cache: false,

//success
success: function (html) {
//if process.php returned 1/true (send mail success)
if (html==1) {
//hide the form
$('.form').fadeOut('slow');

//show the success message
$('.done').fadeIn('slow');

//if process.php returned 0/false (send mail failed)
} else alert('Sorry, unexpected error. Please try again later.');
}
});

//cancel the submit button default behaviours
return false;
});
});
</script>


<div id="logincontainer">
<div id="topnav" class="topnav">
<a href="login" class="login"><span>Register</span></a>
<a href="login" class="signin"><span>Log In</span></a> 
</div>

 <fieldset id="signin_menu">
<form method="post" id="signin" action="">
<label for="username">Username</label>
    <input id="username" name="username" value="" title="username" tabindex="4" type="text">
      <br>
<label for="password">Password</label>
    <input id="password" name="password" value="" title="password" tabindex="5" type="password">
 <p class="remember">
<input id="signin_submit" value="Sign in" tabindex="6" type="submit">
<input id="remember" name="remember_me" value="1" tabindex="7" type="checkbox">
<label for="remember">Remember me</label>
</p>
<p class="forgot"> <a href="#" id="resend_password_link">Forgot your password?</a> </p>
<p class="forgot-username"> <A id=forgot_username_link title="If you remember your password, try logging in with your email" href="#">Forgot your username?</A> </p>
</form>
</fieldset>
    
     <fieldset id="login_menu">
<form method="post" id="login" action="processreg.php">
<label for="username">Username</label>
    <input id="username" name="username" title="username" type="text">
    <br>
    <label for="email">Email</label>
    <input id="email" name="email" title="email" type="text"><br>
    <label for="password">Password</label>
    <input id="password" name="password"  title="password" type="password">
<input id="submit" value="Register" type="submit">


</p>
</form>
</fieldset>
    
    <div class="loading"></div>
    <div class="done">
<b>Thank you for joining!</b> You can now login. 
</div>

</div>
<script type="text/javascript">

        $(document).ready(function() {



            $(".signin").click(function(e) {          

e.preventDefault();

                $("fieldset#signin_menu").toggle();

$(".signin").toggleClass("menu-open");

            });



$("fieldset#signin_menu").mouseup(function() {

return false

});

$(document).mouseup(function(e) {

if($(e.target).parent("a.signin").length==0) {

$(".signin").removeClass("menu-open");

$("fieldset#signin_menu").hide();

}

});



        });


$(document).ready(function() {



            $(".login").click(function(e) {          

e.preventDefault();

                $("fieldset#login_menu").toggle();

$(".login").toggleClass("menu-open");

            });



$("fieldset#login_menu").mouseup(function() {

return false

});

$(document).mouseup(function(e) {

if($(e.target).parent("a.login").length==0) {

$(".login").removeClass("menu-open");

$("fieldset#login_menu").hide();

}

});



        });

</script>

<script src="javascripts/jquery.tipsy.js" type="text/javascript"></script>

<script type='text/javascript'>

    $(function() {

  $('#forgot_username_link').tipsy({gravity: 'w'});   

    });

  </script>



and processreg.php
<?php
include('connect.php');

//Retrieve form data. 
//GET - user submitted data using AJAX
//POST - in case user does not support javascript, we'll use POST instead
$username = ($_GET['username']) ? $_GET['username'] : $_POST['username'];
$email = ($_GET['email']) ?$_GET['email'] : $_POST['email'];
$password = ($_GET['password']) ?$_GET['password'] : $_POST['password'];


//flag to indicate which method it uses. If POST set it to 1
if ($_POST) $post=1;

//Simple server side validation for POST data, of course, you should validate the email
if (!$username) $errors[count($errors)] = 'Please enter your name.';
if (!$email) $errors[count($errors)] = 'Please enter your email.'; 
if (!$password) $errors[count($errors)] = 'Please enter your required password.'; 

//if the errors array is empty, send the mail
if (!$errors) {



$newpassword= md5($password);

$result="INSERT INTO userbase (username, email, password)
VALUES
('$username','$email','$newpassword')";

//if POST was used, display the message straight away
if ($_POST) {
if (!mysql_query($result)) echo 'Thank you! We have received your message.';
else echo 'Sorry, unexpected error. Please try again later';

//else if GET was used, return the boolean value so that 
//ajax script can react accordingly
//1 means success, 0 means failed
} else {
echo $result;
}

//if the errors array has values
} else {
//display the errors message
for ($i=0; $i<count($errors); $i++) echo $errors[$i] . '<br/>';

exit;
}


?>


The output errors
Quote

Notice: Undefined index: username in C:\wamp\www\buy2earn\processreg.php on line 7

Notice: Undefined index: email in C:\wamp\www\buy2earn\processreg.php on line 8

Notice: Undefined index: password in C:\wamp\www\buy2earn\processreg.php on line 9

Notice: Undefined variable: errors in C:\wamp\www\buy2earn\processreg.php on line 21
Thank you! We have received your message.


Now this is basic basic errors, which I know normally means I have named my form inputs different to the processing script, but in this case they are correct.

I am using the second form in the login script  which is this one:
Code: [Select]
<form method="post" id="login" action="processreg.php">
<label for="username">Username</label>
    <input id="username" name="username" title="username" type="text">
    <br>
    <label for="email">Email</label>
    <input id="email" name="email" title="email" type="text"><br>
    <label for="password">Password</label>
    <input id="password" name="password"  title="password" type="password">
<input id="submit" value="Register" type="submit">

Can anyone explain what's the problem? My js skills are non existent so this came from my collection of saved rar files with no explanations and some very basic editing!

Many Thanks

This topic has been moved to Ajax Help.

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

I have an AJAX request but my problem is that is always returns a status code of 0.  Below I have my JavaScript function.  They send a request to a page called inc_submit.php which just echo's "hi" (as I'm just try to test it). 

Code: [Select]
function submitForm(website_name, website_caption, website_contact, website_email, website_link) {
var url4 = "includes/inc_submit.php?website_name=" + escape(website_name) + "&website_caption=" + escape(website_caption) + "&website_contact=" + escape(website_contact) + "&website_email=" + escape(website_email) + "&website_link=" + escape(website_link);
alert (url4);
request4.open("GET", url4, true);
request4.onreadystatechange = confirmSubmit;
request4.send(null);
}

function confirmSubmit() {
if (request4.readyState == 4) {
if (request4.status == 200) {
var response4 = request4.responseText;
document.getElementById("submit_status").innerHTML = response4;
} else {
alert("Error: status code is " + request4.status);
}
}
}

I'm trying to upload a file using ajax, but I have some problems.
First I'll show the code :

HTML
Code: [Select]
<form id="foto" action="index.php?action=send" method="post" enctype="multipart/form-data">
<fieldset>
<label>Kleur</label>
<input id="Binded" type="text" value="ffffff" />
    <br />
<label>Upload foto</label>
        <input id="file" type="file" name="upload" id="upload"/>
        <a href="index.php?action=foto" id="uploaden">uploaden</a>
</fieldset>
<fieldset id="audioplayer">
<h3>Kies een soundtrack</h3>
<ol id="lijst">
      <li id="een" class="active"><a href="assets/audio/Gayla_Peevey-I_Want_a_Hippopotamus_For_Christmas.mp3">Gayla Peevey - I Want a Hippopotamus For Christmas</a>
      <img class="mute" src="assets/images/mute.png" width="30" height="30" alt="mute"/></li>
      <li id="twee"><a href="assets/audio/SouthFamilyXmas2005-NuttinForChristmas.mp3">South Family - Nuttin for Christmas</a>
      <img class="mute" src="assets/images/mute.png" width="30" height="30" alt="mute"/></li>
      <li id="drie"><a href="assets/audio/southpark_merry_christmas.mp3">South Park - Merry Christmas</a>
      <img class="mute" src="assets/images/mute.png" width="30" height="30" alt="mute"/></li>
      </li>
    </ol>
   
    <audio id="audio" preload="auto" autobuffer autoplay src="assets/audio/Gayla Peevey - I Want a Hippopotamus For Christmas.mp3">
</audio>
   
</fieldset>
<fieldset id="emailen">
<h3>Email een vriend</h3>
<br />
<input type="email" name="email"  placeholder="Email" required="true" />
<input type="submit" name="verstuur" id="verstuur" value="Verstuur" />
</fieldset>
</form>
PHP
Code: [Select]
function getAjaxContent(){

global $smarty;

$dir = "uploads";
        $tempdir = $_FILES['upload']["tmp_name"];
        $realdir = $dir."/".$_FILES["upload"]["name"];
        //$fotoTonen = '<img src="'.$realdir.'" alt="foto upload">';
        //$toonFoto = true;

        if(!is_dir($dir)){
            mkdir($dir);
        }

        move_uploaded_file($tempdir, $realdir);

var_dump($_FILES);

return  $smarty->fetch('kaart-ajax.htm');

}Here I get the error <b>Notice</b>:  Undefined index:  upload in <b>/Applications/MAMP/htdocs/2011-2012/kerstkaart/includes/index.php</b> on line <b>16</b><br /> and the var_dump gives an empty array

AJAX
Code: [Select]
$('input[name=foto]').change(function(event){
   
    $.ajax({
        url:"index.php?action=foto",
        data: $('input[type=file]').val(),
        type: "POST",
        timeout: 3000,
        error: function(jqXHR, textStatus,errorThrown){
            alert("probleem met ajax "+textStatus);
        },
        success: function(data, textStatus, jqXHR){


            alert("jaja "+data);

canvas.width = canvas.width;
context.drawImage(image, 0, 0);
image.src = 'uploads/'+data;
       
        }
      });
   
   
    event.preventDefault();
   
    });
What I try to do here is getting the value of the selected file and redraw my canvas ( HTML5 ) so that the chosen pic is the background.
The file i upload to test is a gif of 4KB, so not that big.

Can anyone help me with this confusing problem ?
Thanks,

Hello,
   First of all ,I have been a regular reader of the forum and it has increased my knowledge in the PHP a lot. 
 Till now i had just been a guest user and used to go through the queries and tips posted here.

Today , for the first time i am posting on the forum

Coming to a problem:
 I have to design a function for a client from travel domain. Where he wants the script/function to go and extract data from an airline website on the available fare for a specific date and destination. The problem is that only a part of fare(Base fare) is visible on the site and you have to select one of the given flight option(s) (after selecting the option through AJAX the full fare is displayed on the same page on the left hand site) to get the complete fare including fare and surcharges.

Now i want my function/script to extract the full fare for all the available flight options. I have written the below piece of code. But its not efffective as it gets only the base fare part of the result page and not the complete fare.. 

The airline booking url is : http://book.spicejet.com/skylights/cgi-bin/skylights.cgi

My code:

//---- Spicejet start
// ENGINE URL http://book.spicejet.com/skylights/cgi-bin/skylights.cgi?page=homecomp

//Taking some sample search data - just to test the script
$event="search" ;
$module="SB" ;
$page="SEARCH" ;
$mode="empty" ;
$travel="1" ;     // ONE WAY OR 2 WAY
$from1="HYD" ;
$to1="DEL" ;
$departDay1="13" ;
$departDay2="";
$departMonth1="201010" ;
$ADULT="1" ;
$CHILD="0" ;
$INFANT="0" ;
$toCity1="DEL" ;
$numberMarkets="1" ;

// the page needs data in POST form
$curlPost = 'event='  . urlencode($event) . '&module=' . urlencode($module) .'&page=' . urlencode($page) .'&mode=' . urlencode($mode) .'&travel=' . urlencode($travel) .'&from1=' . urlencode($from1) .'&to1=' . urlencode($to1) .'&departDay1=' . urlencode($departDay1) .'&departMonth1=' . urlencode($departMonth1) .'&ADULT=' . urlencode($ADULT) .'&CHILD=' . urlencode($CHILD) .'&INFANT=' . urlencode($INFANT) .'&toCity1=' . urlencode($toCity1) .'&numberMarkets=' . urlencode($numberMarkets).'&submitSearch=submitSearch';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'http://book.spicejet.com/skylights/cgi-bin/skylights.cgi');
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 2.0.50727; .NET CLR 1.1.4322)");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, $curlPost);
$data = curl_exec($ch);
curl_close($ch);

echo($data); 



Also one more query Is there something like beautiful soup (As in Python) to parse the data. I want to extract the flight timing and total price from the page and insert into a database.

Thanxs in advance

Hello,

I am trying to implement some code I found and downloaded he
http://www.roscripts.com/Ajax_autosuggest_autocomplete_from_database-154.html

When I try and run this I get no search results back when searching? I have entered data in the database and all connections seem good. Several people in the comments say they have problems, but no solution.

Any one that can find the fault here?

- THANKS


<?php
require_once('db.php');
include('classes/stem.php');
include('classes/cleaner.php');

if( !empty ( $_POST['search'] ) ):

$string = $_POST['search'];
$main_url = 'http://www.roscripts.com/';

$stemmer = new Stemmer;
$stemmed_string = $stemmer->stem ( $string );

$clean_string = new jSearchString();
$stemmed_string = $clean_string->parseString ( $stemmed_string );

$new_string = '';
foreach ( array_unique ( split ( " ",$stemmed_string ) ) as $array => $value )
{
if(strlen($value) >= 3)
{
$new_string .= ''.$value.' ';
}
}

$new_string = substr ( $new_string,0, ( strLen ( $new_string ) -1 ) );

if ( strlen ( $new_string ) > 3 ):

$split_stemmed = split ( " ",$new_string );
        
        mysql_select_db($database); 
$sql = "SELECT DISTINCT COUNT(*) as occurences, title, subtitle FROM articles WHERE (";
             
while ( list ( $key,$val ) = each ( $split_stemmed ) )
{
              if( $val!='' && strlen ( $val ) > 0 )
              {
               $sql .= "((title LIKE '%".$val."%' OR subtitle LIKE '%".$val."%' OR content LIKE '%".$val."%')) OR";
              }
}

$sql=substr ( $sql,0, ( strLen ( $sql )-3 ) );//this will eat the last OR
$sql .= ") GROUP BY title ORDER BY occurences DESC LIMIT 10";

$query = mysql_query($sql) or die ( mysql_error () );
$row_sql = mysql_fetch_assoc ( $query );
$total = mysql_num_rows ( $query );
 
if($total>0):

        echo ' <div class="entry">'."\n";
echo ' <ul>'."\n";
while ( $row = mysql_fetch_assoc ( $query ) ) 
{
echo ' <li>'."\n";
echo ' <a href="'.$main_url.'articles/show/'.$row['id'].'">'.$row['title'].''."\n";
echo ' <em>'.$row['subtitle'].'</em>'."\n";
echo ' <span>Added on 2007-06-03 by roScripts</span></a>'."\n";
echo ' </li>'."\n";
}

echo ' </ul>'."\n";
echo ' </div>'."\n";
endif;
endif;
endif;
?>


The code can be found in attached zip file.

Hi...

I have a problemand I tried to resolved it but still I failed..

I need to add a code in a php file where I'm not the one who code, now I need to add code on that file, and the problem is the one who the owner of code is not here.

I need to add code :

Code: [Select]
$sub_lotcode = substr($lotCode, 9, 4);
   
    $sql = "SELECT k.PCODE, k.kanban, p.Compounds, p.Max_Lot
            FROM kanban_checker k, param_settings p
        WHERE k.kanban = p.Max_Lot AND k.PCODE = '$sub_lotcode' AND p.Compounds = '$sub_lotcode'";
        $result = mysql_query($sql, $con);
         $total = mysql_num_rows($result);
        if ($total <= 0) {
            notify that PCODE reach the maximum        }
        else{
            echo "continue";
        }

here is the code where I need to add this condition:

Code: [Select]
<?php
error_reporting(0);
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);

$lotCode = mysql_real_escape_string($_GET['normal']);
$lotCodeDownGrade = mysql_real_escape_string($_GET['downgrade']);
$terminalNo = mysql_real_escape_string($_GET['n']);
$downMode = mysql_real_escape_string($_GET['down']);
   

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>    

if ($terminalNo == "1") {
    
    if ($lotCode != "") {

      
        $sql = "SELECT BARCODE FROM LEGALCODES WHERE BARCODE='$lotCode'";
        $result = mysql_query($sql, $con);
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            echo "X"; // X - for non existent in the mes table
        }
        else {    
                //do this if code exist in the database:
            //  //code exist in the database
            $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND 
                   TERMINAL_ID='1' AND ACTIVE=TRUE";
            $result = mysql_query($sql, $con);
            $total = mysql_num_rows($result);
            if ($total <= 0) {
                echo "0"; // continue to transact
            }
            else {
            // query the last terminal it was used
                $sql    = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND 
                          ACTIVE=TRUE ORDER BY DATE_ENTRY DESC LIMIT 1";
                
                $result = mysql_query($sql, $con);
                
                $row    = mysql_fetch_array($result);
                $total  = mysql_num_rows($result);
                
          
                echo $row['TERMINAL_ID'] ;  // already used here - me nakita   // GET THE LAST TERMINAL NUMBER ACTIVE ADD 1                                                HERE TO DISPLAY WHICH TERMINAL TO GO
            }    
        }
    }
}   

//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>    

elseif ($terminalNo == "4") {
    
    if ($lotCode != "") {
        $sql = "SELECT BARCODE FROM LEGALCODES WHERE BARCODE='$lotCode'";
        $result = mysql_query($sql, $con);
        $total = mysql_num_rows($result);
        
        if ($total <= 0) {
            echo "X"; // X - for non existent in the mes table
        }
        
        else {
            //if downgrade is checked do this :
            if ($downMode == "true") {
                $advanceTerminal = ((integer)($terminalNo) + 1);
                $advanceTerminal = (string)($advanceTerminal);
                
                $preTerminal = ((integer)($terminalNo) - 1);
                $preTerminal = (string)($preTerminal);

                //query if the lot code exist in advance terminal ..
                $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND                                              TERMINAL_ID='$advanceTerminal' AND ACTIVE=TRUE";
                       $result = mysql_query($sql, $con);
                       $total = mysql_num_rows($result);
                  
                if ($total <= 0) {
                        // check naman kung wala sa naunang terminal
                        $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND                                              TERMINAL_ID='$preTerminal' AND ACTIVE=TRUE";
                        
                        $result = mysql_query($sql, $con);
                        $total = mysql_num_rows($result);
                        
                        if ($total <= 0) {
                            $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND ACTIVE=                                      TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                            $result = mysql_query($sql, $con);
                            $row    = mysql_fetch_array($result);
                            $total  = mysql_num_rows($result);
                            if ($total <= 0) {               // NO RECORDS FOUND GO TO TERMINAL 1   == optional
                               echo "notran";                
                            }     
                            else {
                               echo $row['TERMINAL_ID'] ; 
                            }   
                        }
                        
                        else {
                            $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND                                              TERMINAL_ID='$terminalNo' AND ACTIVE=TRUE";
                            $result = mysql_query($sql, $con);
                            $total = mysql_num_rows($result);
                            if ($total <= 0 || $total >= 0) {
                                echo "G";    
                            }
                        }
                                                
                }
                else {
                        $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND ACTIVE=                                      TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                        $result = mysql_query($sql, $con);
                        $row    = mysql_fetch_array($result);
                        $total  = mysql_num_rows($result);
                        echo $row['TERMINAL_ID'] ; 
                }
            }
            
            else {
            
                //query if the lot code exist in this terminal ..
                $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND                                          TERMINAL_ID='$terminalNo' AND ACTIVE=TRUE";
                $result = mysql_query($sql, $con);
                $total = mysql_num_rows($result);
                
                if ($total <= 0) {  // wala nakita - then tsek if nag exist sa terminal na sinundan
                   $preTerminal = ((integer)($terminalNo) - 1);
                   $preTerminal = (string)($preTerminal);
                   
                   //then tsek if nag exist sa terminal na sinundan
                   $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND                                          TERMINAL_ID='$preTerminal' AND ACTIVE=TRUE";
                   $result = mysql_query($sql, $con);    
                   $total = mysql_num_rows($result);
                   
                   if ($total <= 0) {   // walang nakita sa mga naunang terminal
                       // do this if no previous transaction with pre requisite process
                       // query the last terminal it was used
                       
                       $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND  ACTIVE=                                  TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                       $result = mysql_query($sql, $con);
                       $row = mysql_fetch_array($result);
                       $total = mysql_num_rows($result);
                      // $row = mysql_fetch_array($result); 
                       if ($total <= 0) {               // NO RECORDS FOUND GO TO TERMINAL 1   == optional
                           echo "notran";                
                       }                                            
                       else {                           
                           echo $row['TERMINAL_ID'];    // GET THE LAST TERMINAL NUMBER ACTIVE ADD 1 HERE TO DISPLAY WHICH                                                           TERMINAL TO GO
                       }                                
                   }   
                   else {
                       echo "G";
                   }
                }
                else { //me record na nakita sa terminal na pinag transakan
                     
                    // query the last terminal it was used
                       $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND                                              ACTIVE=TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                    $result = mysql_query($sql, $con);
                    $row    = mysql_fetch_array($result);
                    $total  = mysql_num_rows($result);
       
                    echo $row['TERMINAL_ID'] ;  // already used here - me nakita   // GET THE LAST TERMINAL NUMBER ACTIVE                                                    ADD 1 HERE TO DISPLAY WHICH TERMINAL TO GO
                 
                }
            } // here is the terminator of else in downgrade
        }  
    }
//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>    
    if ($lotCodeDownGrade != "") {
        $sql = "SELECT BARCODE FROM LEGALCODES WHERE BARCODE='$lotCodeDownGrade'";
        $result = mysql_query($sql, $con);
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            echo "X"; // X - for non existent in the mes table
        }
        else {
                //do this if code exist in the database:
            //  //code exist in the database
            $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCodeDownGrade' AND 
                    ACTIVE=TRUE";
            
            $result = mysql_query($sql, $con);
            $total = mysql_num_rows($result);
            if ($total <= 0) {
                echo "0"; // continue to transact
            }
            else {
            // query the last terminal it was used
                $sql    = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCodeDownGrade' AND 
                          ACTIVE=TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                
                $result = mysql_query($sql, $con);
                
                $row    = mysql_fetch_array($result);
                $total  = mysql_num_rows($result);
          
                echo $row['TERMINAL_ID'] ;  // already used here - me nakita   // GET THE LAST TERMINAL NUMBER ACTIVE ADD 1                                              HERE TO DISPLAY WHICH TERMINAL TO GO
            }
        }
    }
}
//>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>    
else {
    if ($lotCode != "") {
        $sql = "SELECT BARCODE FROM LEGALCODES WHERE BARCODE='$lotCode'";
        $result = mysql_query($sql, $con);
        $total = mysql_num_rows($result);
        
        if ($total <= 0) {
            echo "X"; // X - for non existent in the mes table
        }
        
        else {
            //query if the lot code exist in this terminal ..
            $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND 
                    TERMINAL_ID='$terminalNo' AND ACTIVE=TRUE";
            $result = mysql_query($sql, $con);
            $total = mysql_num_rows($result);
            
            if ($total <= 0) {  // wala nakita - then tsek if nag exist sa terminal na sinundan
               $preTerminal = ((integer)($terminalNo) - 1);
               $preTerminal = (string)($preTerminal);
               
               //then tsek if nag exist sa terminal na sinundan
               $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND 
                      TERMINAL_ID='$preTerminal' AND ACTIVE=TRUE";
               
               $result = mysql_query($sql, $con);    
               $total = mysql_num_rows($result);
               if ($total <= 0) {   // walang nakita sa mga naunang terminal
                   // do this if no previous transaction with pre requisite process
                   // query the last terminal it was used
                   
                   $sql = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' 
                          AND ACTIVE=TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                   $result = mysql_query($sql, $con);
                   $row = mysql_fetch_array($result);
                   $total = mysql_num_rows($result);

                   if ($total <= 0) {               // NO RECORDS FOUND GO TO TERMINAL 1   == optional
                       echo "notran";                
                   }                                            
                   else {                           
                       echo $row['TERMINAL_ID'];    // GET THE LAST TERMINAL NUMBER ACTIVE ADD 1 HERE TO DISPLAY WHICH TERMINAL TO GO
                   }                                
               }   
               else {
                   echo "G";
               }
            }
            else { //me record na nakita sa terminal na pinag transakan
                 
                // query the last terminal it was used
                $sql    = "SELECT LOT_CODE, TERMINAL_ID, ACTIVE FROM DEPENDENCY WHERE LOT_CODE='$lotCode' AND ACTIVE=                                  TRUE ORDER BY TERMINAL_ID DESC LIMIT 1";
                $result = mysql_query($sql, $con);
                $row    = mysql_fetch_array($result);
                $total  = mysql_num_rows($result);

                echo $row['TERMINAL_ID'] ;  // already used here - me nakita   // GET THE LAST TERMINAL NUMBER ACTIVE ADD 1 HERE TO DISPLAY WHICH TERMINAL TO GO

            }
        }
    }
}   
mysql_close($con);   
?>

Code: [Select]
function unUsedLotId(txtElemID){

    var txtElemID_Active = txtElemID;
//alert("VV" + txtElemID_Active.value + "VV" );
    responsePHP = "no_reply";
    changeFocus = false;
    var termNo = terminalNo();
    ajaxRequest = remoteRequestObject();
    ajaxRequest.onreadystatechange = function(){
        if (ajaxRequest.readyState==4 && ajaxRequest.status==200) {
             
          //   var result = ajaxRequest.responseText;
               responsePHP = ajaxRequest.responseText;
         
          //alert(responsePHP)
         
          //   if (result=="1") { result = "Already used Tag";}
          //   if (result=="0") { result = "Tag ok";}
          //   if (result=="G") { result = "Tag ok";}   
          //   if (result=="B") { result = "Incomplete Process";}   
          //   var resultStr = (result=="1") ? 'Tag used or incomplete prerequisites' : 'Tag unused';
            if (responsePHP == "failed") {
                txtElemID_Active.disabled = false;
                txtElemID_Active.value = "";
                txtElemID_Active.focus();
                notify("Report to MIS<br /> Please scan again.");
            }
//------------------------------added by rhoda for integration--------------------------------------------------
           /* else if (responsePHP == "C"){
                 notify("CCCC");
                if (txtElemID_Active.disabled) {
                    txtElemID_Active.disabled = false;                 
                }
                txtElemID_Active.value = "";
                txtElemID_Active.focus(); 
            } */
   
//--------------------------------------------------------------------------------       
            else if (responsePHP == "X") {
                //result = "Lot ID invalid.";
                //responsePHP = "Lot ID invalid.";
                notify("Lot ID invalid. Scan Again.");
                if (txtElemID_Active.disabled) {
                    txtElemID_Active.disabled = false;                 
                }
                txtElemID_Active.value = "";
                txtElemID_Active.focus(); 
            }
//--------------------------------------------------------------------------------           
            else if (responsePHP =="0" || responsePHP =="G"){
               
               if (txtElemID_Name == "txtLotCode") {
                   window.LotID = (txtElemID_Active.value)
               }   
               if (txtElemID_Name == "txtLotCodeDownGrade") {
                   window.LotID_Down = (txtElemID_Active.value)
               }
               
               
               strip(txtElemID_Active)
 
               if (termNo == "1") {
                   isSelected('txtLotCode', 'selWeight_MachineID');
               }
               if (termNo == "2" || termNo == "3") {
                   isSelected('txtLotCode', 'txtKitWeight');
               }
               if (termNo == "4" || termNo == "5" || termNo == "6" || termNo == "7") {
 //////////////////////////////// downgrade modification  ///////////////////////////////////////
                   if (termNo == "4") {
                        //alert(termNo)
                        var chkDownGrade  = document.getElementById('chkDownGrade')
                        if (chkDownGrade.checked == 1) {
                          //alert("here")   
                              if (txtElemID_Name == 'txtLotCode') {
                                 isSelected('txtLotCode', 'txtLotCodeDownGrade');
                              }
                             
                              if (txtElemID_Name == 'txtLotCodeDownGrade') {
                                 isSelected('txtLotCodeDownGrade', 'selMachineID');
                              }
                        }
                        else {
                              //alert("here")
                              if (txtElemID_Name == 'txtLotCode') {
                                 isSelected('txtLotCode', 'selMachineID');
                              }
                       
                        }                         
                   }
                   else {
                       
                       isSelected('txtLotCode', 'selMachineID');
                   }
////////////////////////////////////////////////////////////////////////////////////////
               
               
               }
               if (document.getElementById('notice')!== null) {
                   document.getElementsByTagName('body')[0].removeChild(document.getElementById('notice')) //>> clear the box
               }
            }
//--------------------------------------------------------------------------------           
            else if (responsePHP == "notran") {
               var mensahe1 = "Please return to<br /><span style='font-size:30px;'>Chemical Weighing<br /> or Supervisor</span>";
               notify(mensahe1); 
               
               if (txtElemID_Active.disabled) {
                   txtElemID_Active.disabled = false;                 
               }
               txtElemID_Active.value = "";
               txtElemID_Active.focus();
            }
//--------------------------------------------------------------------------------           
            else {
               /*
               responsePHP == "1" || responsePHP == "B") {
               do this if tag is used in this terminal   
               if (responsePHP == "1") {
                  result = "Already used Lot ID";
                  responsePHP = "Already used Lot ID";
                  notify("Already used Lot ID.<br />Scan again.");
               }
               else if (responsePHP == "B") {
                 // result = "Incomplete Transaction Process"; 
                //  responsePHP = "Incomplete Transaction Process";
                  notify("Incomplete Transaction Process.<br />Scan again.");
               }
               */
               var mensahe1 = "Last Process: <span style='font-size:30px;'> Terminal " + responsePHP + "</span><br /><br />";
               var mensahe2 = "Pls. Proceed: <span style='font-size:30px;'> Terminal " + (parseInt(responsePHP) + 1) + "</span>";
               
               notify(mensahe1 + mensahe2);
            //      notify("Incomplete Transaction Process.<br />Scan again.");
           
               if (txtElemID_Active.disabled) {
                   txtElemID_Active.disabled = false;                 
               }
               txtElemID_Active.value = "";
               txtElemID_Active.focus();
            }
 //--------------------------------------------------------------------------------           
        }
    }   

var txtElemID_Name = txtElemID_Active.id;     

if (termNo == "4") {
    var downGrade  = document.getElementById('chkDownGrade').checked;
    var str =  txtElemID_Active.value +  "&n=" + termNo +  "&down=" + downGrade;
}
else {
    var str =  txtElemID_Active.value +  "&n=" + termNo;
}

if (txtElemID_Name == "txtLotCode") {
    //alert(txtElemID_Name)
    var url = "verifyLotId.php?normal=" + str;
}   
if (txtElemID_Name == "txtLotCodeDownGrade") {
    //alert(txtElemID_Name)
    var url = "verifyLotId.php?downgrade=" + str;
}


ajaxRequest.open("GET", url, true);

 // force i.e. not to cache
ajaxRequest.setRequestHeader("If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT");
//--------------------------------------------------
ajaxRequest.send(null);


ajaxTimeOut = window.setTimeout("timeOut('" + txtElemID_Name + "');", 6000);
       
}

This topic has been moved to PHP Regex.

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