PHP - Php Explode

I'm trying to add options to products.

Currently, I have them in this format: Leather reinforced hilt,5.00::Stabbing tip,3.00::Logo,10.00

Code: [Select]
$option_results = mysql_query("SELECT product_options FROM products WHERE product_id='".$product."'");
   while($option_row = mysql_fetch_array($option_results)){
         $option = explode("::", $option_row[0]);
         $option_part = explode(",", $option[0]);
         $option_part[0] = $option_name;
         $option_part[1] = $option_price;
         echo "<li><a href=\"#\">".$option_name.", Add $".$option_price."</a></li>";
    }

I would like the output to be:

<li><a href="#">Leather reinforced hilt, Add $5.00</a></li>
<li><a href="#">Stabbing tip, Add $3.00</a></li>
<li><a href="#">Logo, Add $10.00</a></li>

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

I store date data in MySql in this format DD-MM-YYYY , and now I need to explode this format when get information from database to get this:
$day = DD , $month = MM , $year = YYYY.

$result =  $db->query("SELECT 
user_birthday  
FROM users 
WHERE user_id = " . mysql_real_escape_string($_SESSION['user_id']) . " 
LIMIT 1");
$row = mysql_fetch_assoc($result);

$birthday = $row['user_birthday'];
and I get this date format: 12-07-1980

How to explode this 3 values in day, month, year?

I am in need of a alimit on the explode() fucntion but reading through the php explode manual on php.net there doesn't seem to be one that is right for me.

Basically I'm making a command system for a php chat and it has a command called ban.
I have code that find out if it is a command or a normal string, I also have code that starts to break up the command into segments that can be places in the database.

I want to split up "ban user lengthID "Reason why you were banned"" using explode($string, " ") but I notice that that will also break up the "reason why you are banned".

How do I get it to split up the command but NOT thereason why you were banned string?

Confusing I know, Please ask any questions that would help me explain it better Thanks in advance!

Hi,

I have a database that is going to contain recepies and ingredients tables. The recipe table is going to store the ingredients like this:

1,5,6,8

This refers to the table ingredients id.

I now want to explode these vaules and count them up so they can be outputted like this:

sugar (2)
honey(1)
flour (3)

I have no idea of how to count all of the exploded id's and ouput them like above

Code: [Select]
$newrating = round($imageinfo['rating'],2);
this outputs:

4.49

in my db rating is

4.4884   


all i need is the 4.... would i use some type of preg_replace or something just to grab the first 1 before the decimal? (all  i need is the first number before the decimal)

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.

Ok so what I have is a list of 32,000 IDs in a separate file called 32kIDs.txt and it has a list of roughly 32,000 user IDs for facebook which look like 100000233850312;1521225383;100000282767638;1252335882;1804268242

They're all separated by a semi-colon. What I need this script to do is echo each and every ID on screen, echoing each ID on a new line. I have been using the explode function but having trouble with it since I'm very new to PHP and don't have much experience yet.

Here is my current code:

<?PHP
$iFile = "32kIDs.txt";
$login = file($iFile, FILE_SKIP_EMPTY_LINES);
if(!is_file($iFile)) echo "The 32k add list couldn't be found...".sleep(999999);
foreach($login as $line_num => $line)
{
$login = explode(" ", htmlspecialchars(str_replace(";"," ",$line)));
 echo $login[0]."\n";
}
sleep(20);
?>

So I bet there are going to be things in there that I don't even need and thing's I'm missing, if anyone can help it would be much appreciated. And I'd like to keep the code short, I could just put in:
echo $login[0]."\n";
echo $login[1]."\n";
echo $login[2]."\n";
echo $login[3]."\n";

all the way up to echo $login[32246]."\n"; but yeah I don't like the thought of a 32k+ line script.

Anyways...

Lets say I have a URL of http://mydomain.com/somename/

I need a function to grab USERNAME

However I need it to work if someone uses http://www.mydomain.com/USERNAME/

OR

With or without the trailing / after USERNAME

I can't see to figure anything out which accounts for the many different variables that a person could type it.

And yet another way is that the URL could be http://www.mydomain.com/USERNAME/SOME-CAT/SOME-POST/


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

I have a script that connects to another server to pull data... When it pulls the data it comes back in the following format:

Code: [Select]
t1.sh t2.sh t3.sh test.sh

However using the code bellow does not separate it like it should, it should put one file per line but I think I did something wrong...

Code: [Select]
// Pulls the output from the server:
$var_test = $ssh->exec('./test.sh');
// Explodes it...
$var_test2 = explode(" ", $var_test);
// Echos it one per line...
foreach ($var_test2 as $variable) {
echo '<br>'.$variable;
}

Need some help with something I have not done before.
I have a dynamic checkbox set up to accept userinput then post $optionsname,$optionsprice.

Code: [Select]
echo "<li><input type=\"checkbox\" name=\"optionslist[]\" value=\"$optionsname,$optionsprice\" /> $optionsname - $ $optionsprice - $optionsdisc</li>";
So far no problem
Code: [Select]
$showoptions=$_POST['optionslist'];
  if(empty($showoptions))
  {
    echo("You didn't select any options.");
  }
  else
  {
    $N = count($showoptions);
    echo("<strong>You selected $N options:</strong> ");
    for($i=0; $i < $N; $i++)
    {
      echo("<li>".$showoptions[$i] . "</li>");
    }
  }
Can someone tell me how to explode $showoptions into $optionsname,$optionsprice again.

Thanks for any help in advanced.

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

I tried to do this:

explode(" ",$cp['size'])[0]


and it isn't working obviously. The reason I want it in one line is its in the middle of a big string and I'd like to keep all the code in one area. Is their a right way to do that other than setting it to a variable first?

Hello,
I've been working on some stuff, and get the information parsed like this:
Code: [Select]
Value1,Value2,Value3 0.68,4377.54,11069.02So I'm trying to explode it and insert the latest numbers into the database. I'm using:

$value = explode(",", $variable);
$secondsplit = explode(" ", $value[2]);
mysql_query("INSERT INTO table(row) VALUES('".mysql_real_escape_string($secondsplit[1])."')");

The problem is that it has something like an enter in the database, or a space. But I can't figure out how to get rid of that problem. Does anyone know what's wrong?

Regards,
NLCJ