PHP - Explode Nightmare

Hey guys,

Been developing a bespoke "helpdesk" system for work and, while it works well on the whole, I am having major problems with base64 encoded email bodies.

Admittedly, this might be due to my misunderstanding of imap body parts. It seems in my current setup, the system thinks that all mails are either "type" 0 or 4. As a result, base64 emails don't get decoded and display as an unreadable long string.

Here is what my code for the body decoding looks like just now - can provide more on request.

$from=$overview[0]->from; 
    $subject=$overview[0]->subject; 
    $subdb=mysql_real_escape_string($subject); 

    $lookingfor=explode("~#",$body); 

    $result=$from; 

    $find=strrpos($ir, $lookingfor[1]); 

    $findreplystream=mysql_query("SELECT * FROM tickets WHERE ticket_md5='$lookingfor[1]'") or die(''.mysql_error().''); 

    $stream=mysql_fetch_array($findreplystream); 

    $now=time(); 

    if($structure->encoding == 0){ 
     
        $arr1=array("=A3", "=80"); 
        $arr2=array("£", "€"); 
        $newcontent=$explodeunder[0]; 
        define("CHARSET", "ISO-8859-1"); 

        $dbcontenta=str_replace($arr1, $arr2, $newcontent); 
        $r=mb_detect_encoding($dbcontenta); 

        if($r=="UTF-8"){ 

            $dbcontents=mb_convert_encoding($dbcontenta, "ISO-8859-1", "UTF-8"); 
            $dbcontent1=addslashes($dbcontents); 
            $dbcontent2=strip_tags($dbcontent1); 

            } 

        elseif($r=="ASCII"){ 

            $dbcontentb=mb_convert_encoding($dbcontenta, "UTF-8", "ASCII"); 
            $dbcontents=mb_convert_encoding($dbcontentb, "ISO-8859-1", "UTF-8"); 
            $dbcontent1=addslashes($dbcontents); 
            $dbcontentf=strip_tags($dbcontent1); 
            $dbcontent2=quoted_printable_decode($dbcontentf); 
             }  

    } elseif($structure->encoding  == 4) { 

    $dbcontent=$explodeunder[0]; 

    $dbcontentf=quoted_printable_decode($dbcontent); 
    $dbcontent2=mb_convert_encoding($dbcontentf, "ISO-8859-1", "UTF-8"); 
    } 

    elseif($structure->encoding == 3) { 

    $dbcontent2=imap_base64($explodeunder[0]); 

    } elseif($structure->encoding == 1){ 

        $dbcontent3=imap_8bit($explodeunder[0]); 
        $dbcontent2=quoted_printable_decode($dbcontent3); 
    } 


Can anyone advise me with this?

I'd be greatful for any assistance at all, as it's causing me nightmares!

All the best

OK, I have been having issues with this query for some time now, I (finaly) have the query working absoloutly fine when run directly in the database, however, when I try and run it through a PHP page I just get a completly empty result set back.  I have done a print_r($row) and there is nothing, absoloutly nothing.  I have ran the SQL that comes from  print_r($sql) in the database and it's completly fine as well.  I was getting an error previously because I had missed the "IS" out before NOT NULL for the PadPrefix, so it is parsing the SQL to some level (I now have no errors showing either). 

I am wondering if there is something I am missing that is needed for when the SQL is creating cached tables and/or using a counter?

Here's the code, any and all suggestions welcome, Cheers
<?php
@SESSION_START();
require_once 'connect.php';
$bp = $_SESSION['bp'];
if ($_SESSION['id'] < 99){
$tbl_top = '<table><tr><th>SheetID</th></tr>';
$WHERE = " = '$bp'";
}
else{
$tbl_top = '<table><tr><th>SheetID</th><th>Prefix</th></tr>';
$WHERE = "IS NOT NULL";
}
$sql = "DECLARE @badSheets TABLE (ID int, batchMax int) ".
"DECLARE @list TABLE (maxsheet int, lastsheet int) ".
"DECLARE @sheet int ".
"DECLARE @batch int ".       
"DECLARE @endBatch int ".
"declare @batchIndex int ".
"INSERT INTO @list (maxsheet, lastsheet) ". 
"SELECT sheetList.maxsheet, padlist.lastSheet ".
" FROM( ".
" SELECT sheet.padID, MAX(sheet.SheetID) as maxsheet FROM jim.dbo.sheet as sheet ". 
" INNER JOIN jim.dbo.files as files on sheet.sheetID = files.sheetid ".
" where sheet.sheetid > 100000 ".
" group by sheet.padID) ".
"AS sheetList ".
"INNER JOIN( ".
 "SELECT pads.padID, pads.padID+(count(pads.padID)-1) as lastSheet ".
 "From jim.dbo.sheet as pads ".
 "Group By pads.PadID) ". 
"AS padList ".
"ON (sheetList.padID = padList.padID) ".
"WHERE maxsheet != lastSheet ".
"DECLARE bad_batch CURSOR FOR ".
"SELECT DISTINCT maxsheet FROM @list ORDER BY MaxSheet ".
"OPEN bad_batch ".
"FETCH NEXT FROM bad_batch ".
"INTO @batchIndex ".
"WHILE @@FETCH_STATUS = 0 ".
 "BEGIN ".
  "SELECT @batch = lastSheet FROM @List where maxsheet= @batchIndex ".
  "SELECT @sheet = maxSheet FROM @List where maxsheet= @batchIndex ".
  "WHILE (@sheet <= @batch) ".
    "BEGIN ".
    "INSERT INTO @badsheets(ID, batchMax) VALUES (@sheet, @batch) ".
    "SET @sheet = (@sheet + 1) ".
    "END ".
  "Fetch Next FROM bad_batch INTO @batchIndex ".
  "END ".
"close bad_batch ".
"deallocate bad_batch ".
"SELECT sheetID, padprefix ". 
"FROM JIM.dbo.sheet AS sheet LEFT OUTER JOIN jim.dbo.pad AS pads ".
   "ON sheet.padID = pads.padID ".
   "WHERE ( ".
"(padprefix $WHERE) ".
"AND (sheet.sheetID > 100000) ".
"AND (sheet.SheetID NOT IN (SELECT SheetID FROM jim.dbo.files)) ". 
"AND (sheet.sheetID NOT IN (SELECT ID FROM @badSheets)) ".
")";
$result = sqlsrv_query($sqlConnect, $sql) or die("error running : $sql <br><br>".print_r( sqlsrv_errors(), true));
echo "<table border=\"1\">";
echo $tbl_top;
WHILE ($row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){
  if ($_SESSION['id'] < 99){
  $tbl_content = "<tr><td>{$row['sheetID']}</td></tr>";
  echo $tbl_content;
  }
  else{
   $tbl_content = "<tr><td>{$row['sheetID']}</td><td>{$row['padPrefix']}</td></tr>";
   echo $tbl_content;
  }
  
  echo $tbl_content;
  }
echo "</table>";
?>

I have the " or the ' all wrong.  Can someone tell me how to do the quoation marks correctly so I dont get a syntax error:

as can be seen, the date 10/5/14 is not a variable but I want to convert it to a format that can go into a DATE field.

Code: [Select]
$query = "update table set expir_date = date("Y-m-d", 10/5/14) where id = '$id' ";

Hey guys so Ive been messing with a number of .ini files (im sure this isnt a good thing) because Ive been trying to write a script that uploads files as big as 1GB and in doing so Ive edited the my suhosin.ini because in looking at my php_info() it said that all my pot max, get max, request etc were all undesirably low. Anyways I edited the file and then restarted apache but the changes that I made in suhosin.ini arent being displayed when i go to my php_info(). Cant anyone tell me if I missed a step and how do I get the server to recognize the changes as I believe it is these settings that are buggering up my upload script.
-SB

Hi all,

Experimenting with this instant search buzz only I cant seem to replicate the function!
I think my PHP may be cocking up but Ive been staring for too long to see anything.

Could anybody take a quick glance and see if they can see anything?

Code: [Select]
<?php
if(!empty($_GET['q'])) {
    search();
}

function search() {
    $con = mysql_connect('localhost','login', 'pass');
    mysql_select_db('db', $con);

    $q = htmlspecialchars($_GET['q'],ENT_QUOTES);

    $sql = mysql_query("
        SELECT
            post_title as post
        FROM wp_posts
        WHERE post_title LIKE '%{$q}%' OR post_title LIKE '%{$q}%'
        ");

    
    $results=array();
    while($v = mysql_fetch_object($sql)){
        $results[] = array(
          'title'=>$v->title,
          'post'=>$v->post
        );
    }

  
    echo json_encode($results);
}
?>

Hi all, im trying to shorten this string which cnotains about 1000 characters, to say 250
Code: [Select]
<?php echo $row_Best_Sellers['experience_name']; ?>
Ive tried using the below to no avail, can anybody give me some advice?

Code: [Select]
<?PHP
$small = some_function($row_Best_Sellers['experience_description']);
echo $small;

function some_function($string){
     $string = substr($string,0,100);
     $string = substr($string,0,strrpos($string," "));
     return $string;
}
?>

Hi, I am currently trying to build an Artist's website, the artist wanted a CMS that was completely customized to the site (so no Wordpress, Joomla, Drupel, etc) - because of this I am having to create a CMS completely from scratch.   The problem I am having is with the database connection (hence the topic title), other sites that I have built with this same code work fine - however this particular site does not seem to want to play ball. It keeps giving me this error:  

SQLSTATE[HY000] [1045] Access denied for user 'web113-janesart'@'10.0.44.113' (using password: YES)

  I have tried obvious things such as spelling mistakes, wrong password/username/db name, nothing seems to get rid of this error.   Any help on what else this could be would be appreciated.

Hi all,

I posted a similar question before and got some of the way but still need a little help.

I have a product database with a description column where there are strings broken into lines. I need to find a way to explode() by line break. Currently explode("/n") doesn't work - it only returns one array item. Can anyone help me out?

Thanks!

Hello

Ive got a text area and i want to seperate each link that is placed inside the text area,.

Is there a way using php exlode or somthing to reconise that the link has finished? Each of the links in the text area are on a new line.

Thanks in advance.

Hi, I have an array for prices :

forfait="158|Group Session,95|Group half session,45|Private Course,90|zumba course" which is used in a dropdown list where it shows as Group Session (158$) Group half session (95$) etc...

The prices need to be used as an 'amount' field on the gift certificate as the descriptions must show as a 'label' on the gift certificate.

So, I need to ' explode ' both the prices and the descriptions separately.

I can 'explode' de prices using $tmp_forfait=explode("|", $value) and I get 158 95 45 and 90

But, how do I get the descriptions separately, without the prices meaning I need to 'explode' the digits and '|' ...
Anyone can help me with that cope please?
Thank you

i want to explode a text field on the fly ?
for example
city,region.country
and to turn it
to
city_id,region_id,country_id

1.textfield from autocomplete
2.get post variable
3.explode
4 get ids
i played around with some ajax  with php
Code: [Select]
<html>
<body>
<input name="searchField" id="searchField" type="text" value="<?php echo $_POST['searchField'];?>"/>
<script type="text/javascript">
function Ajax(){
var xmlHttp;
try{
xmlHttp=new XMLHttpRequest();// Firefox, Opera 8.0+, Safari
}catch (e){
try{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); // Internet Explorer
}catch (e){
    try{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}catch (e){
alert("No AJAX!?");
return false;
}
}
}
xmlHttp.onreadystatechange=function(){
document.getElementById('ReloadThis').innerHTML=xmlHttp.responseText;
var t=setTimeout('Ajax()',1000);
clearTimeout(t);
}

var searchfieldvalue=encodeURIComponent(document.getElementById("searchField").value)
xmlHttp.open("GET","getid.php?searchField="+searchFieldvalue+"",true);
xmlHttp.send(null);
}
window.onload=function(){
var t= setTimeout('Ajax()',1000);


}

</script>

<?php


/*explode searchField and generate ids
$searchField=$_POST['searchField'];
$p = explode(" , ", $searchField, 3);
$cityname=mysql_real_escape_string($p['0']);
$regionname=mysql_real_escape_string($p['1']);
$countryname=mysql_real_escape_string($p['2']);
*/
?>


<div id="ReloadThis">Default text</div>
</body>
</html>

//getid
<?php  
 $p=array();
 $p = explode(" , ", $_GET['searchField'], 3);
 echo $cityname=$p['0'];
echo $regionname=$p['1'];
 echo $countryname=$p['2'];

echo'<input type="hidden" name="place" id="place" value="'.$cityname.'"/>
<input type="hidden" name="region" id="region" value="'.$regionname.'"/>
<input type="hidden" name="country" id="country" value="'.$countryname.'"/>';

here ill add function to get city_id() etc

?>

hi,

now i have something like this:

$pizza  = "piece1 piece2 piece3 piece4";
$one_word = explode(" ", $pizza);

but i want to get 2 words together, like that:

$two_words[0]='piece1 piece2';
$two_words[1]='piece3 piece4';
$two_words[2]='piece2 piece3';
$two_words[3]='piece1 piece4';

if it's impossible with explode, then it's fine if you use some other function, i don't care as long as it works.

thank you, tastro

With a database of synonyms, how do I compare a fragment of a texarea sentence split by the php explode function to return only five synonyms out of say 100 synonyms of the same word for each fragment.

The Sql statement is queried to return 5 results
Code: [Select]
<?php
 if (isset($_GET['submit'])) {
$sentence = $_GET['sentence'];
 
// break $sentence using the space character as the delimiter
$words = explode(' ', $sentence);
 
//tell the amount of words using the size of the array
echo 'The sentence has ' . count($words) . ' words.<br />';
 
// loop through and print all the words
for ($i = 0; $i < count($words); $i++)
{
    echo "Piece $i = $words[$i] <br />";

//echo 'Word ' . $i . ' - ' . $words[$i] . '<br />';

//$words=$_GET['words'];
$sel="select * from synonyms where synonym LIKE '%$words[$i]%' limit 3";
$data=mysqli_query($dbc,$sel);
$num= mysqli_num_rows($data);


if (!$data) {
die('<p>Error Retrieving<br/>'.
'Error: ' .mysql_error() . '</p>');}

$datalist=mysqli_fetch_assoc($data);
$synonym=$datalist['synonym'];

?> I intend to use a 2 texareas: 
 1. Code: [Select]
<textarea name="split_sentence"><?php echo "sentence" ?></textarea>   the 1st <texarea> has the original sentence to be split by the explode function.
2. Code: [Select]
<textarea name="split_sentence2"><?php echo ("$words[$i] {{$synonym}}?></textarea> the second <texarea> should take the explode fragments compare it with the query above and return five synonyms per word on a SINGLE <textarea> tag.

3. Besides, I keep getting this offset error on the 2nd <texarea> refering to the $words[Si] array element in the 2nd <textarea>
Below is the full code:
Code: [Select]
`<?php 
//session_start();
  // Define database connection constants
  define('DB_HOST', 'localhost');
  define('DB_USER', 'root');
  define('DB_PASSWORD', '');
  define('DB_NAME', 'moby_thesaurus');

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>compare_words</title>

</head>

<body>
<table><p> PLEASE ENTER INITIAL SENTENCE </p>
<form name="sentences" method="get" action="" >
    <tr>
        <td>           
            <textarea name="sentence" id="elm1"></textarea>
            </td>
        </tr>
        <tr>
        <td>           
            <input name="submit" type="submit" value="Create_Spinable Content" />
            </td>
        </tr>
    </form>
</table>
<?php
 if (isset($_GET['submit'])) {
$sentence = $_GET['sentence'];
 
// break $sentence using the space character as the delimiter
$words = explode(' ', $sentence);
 
//tell the amount of words using the size of the array
echo 'The sentence has ' . count($words) . ' words.<br />';
 
// loop through and print all the words
for ($i = 0; $i < count($words); $i++)
{
    echo "Piece $i = $words[$i] <br />";


//echo 'Word ' . $i . ' - ' . $words[$i] . '<br />';

//$words=$_GET['words'];
$sel="select * from synonyms where synonym LIKE '%$words[$i]%' limit 3";
$data=mysqli_query($dbc,$sel);
$num= mysqli_num_rows($data);


if (!$data) {
die('<p>Error Retrieving<br/>'.
'Error: ' .mysql_error() . '</p>');}

$datalist=mysqli_fetch_assoc($data);
$synonym=$datalist['synonym'];

?>
<table><p> SPINABLE CONTENT </p>
<form name="sentences" method="get" action="" >

<tr>
        <td>           
             <?php
  if ($datalist=mysqli_fetch_array($data)) {
do{
?>
            <textarea cols="80" id="editor1" name="sentence" rows="10"><?php echo ("$words[$i] {{$synonym}}||{{$synonym}}||{{$synonym}}"); ?></textarea>
                <?php

}
while ($datalist=mysqli_fetch_array($data));
echo("</table>&nbsp;</p>");
}
?>
<?php
}
 }
?>
            </td>
        </tr>
        <tr>
        <td>           
            <input name="submit" type="submit" value="Spin This Now" />
            </td>
        </tr>
    </form>
</table>

</body>
</html>
Please any suggestions would be highly appreciated.

how to take a word in php or explode based on luas Bangunan :xxx
For example I have string
$string =" Kondisi Properti : Bagus Dilengkapi Perabotan : Unfurnished Sertifikat : Lainnya Daya Listrik : 2200 Watt Kamar Tidur : 3/1 Kamar Mandi : 2/1 Luas Bangunan : 92 m² Luas Tanah : 126 m² Jumlah Lantai : -
Kondisi Properti : Bagus Sekali Dilengkapi Perabotan : Unfurnished Sertifikat : SHM - Sertifikat Hak Milik Daya Listrik : 6600 Watt Saluran Telepon : 1 Garasi : 3 Kamar Tidur : 4/1 Kamar Mandi : 3/1 Luas Bangunan : 300 m² Luas Tanah : 228 m² Jumlah Lantai : 2.5 "; eg I want to take every "Luas bangunan: xxx"
Thanks

Hi all!

This is probably fairly simple for someone who is used to dealing with arrays. I have an array of data(Parsed from an XML document) containing a string I would like to further split into another array.

The string is along the lines of:
"<name>":<value>,"ID":20251,"ID2":2300,"ID3":2000

How can I split the above into:
Array[<NAME>] => <VALUE>

Notes:
<name> changes often. depending on the query, it may have different <name> values.

I have been trying to do it with preg_split and got to:
Array ( => "<NAME>":<VALUE> [1] => "ID":20251)

but I need to split it further at ":". I tried a foreach, but I failed miserably.

Can anyone point me in the direction of better practice for arrays/preg_split? I have looked into the PHP documentation, but it is not enough for me.

Thanks in advance