PHP guys (or gals!) - quick question

[thunder99]

I have data in a mysql table in the format:

description title:description text;description title2:description text2;
etc

Is there any way I put this into an array (or something simillar) to print it out and format it nicely?

[fris]

http://www.php.net/explode

[StariaDaniel]

first explode the string on every ;, next explode every array element on :

http://de.php.net/manual/en/function.explode.php

e.g.:

$tmp = 'description title:description text;description title2:description text2';
$tmp2 = explode(';',$tmp);

returns:

$tmp2[0] = 'description title:description text';
$tmp2[1] = 'description title2:description text2';

now you could do something like:
$tmp3 = array();
foreach($tmp2 AS $value){
$tmp3[] = explode(':',$value);
}

and you get

$tmp3[0] = array(
0 => 'description title',
1 => 'description text'
);
$tmp3[1] = array(
0 => 'description title2',
1 => 'description text2'
);

[frank7799]

You can use a query and put the result into an array. There is an example below. You will need html where the variables are integrated in the "while" loop.

PHP Code:

$query = "select description,title from ".MYSQLTABLE." where (site = '$site') $order";
$result = mysql_query($query);

    $number = mysql_numrows($result);
    
    $i = 1;
    while ($i <= $number)
    {
 
      $row   = mysql_fetch_array($result);
      $title = stripslashes($row["title"]);
      $description = stripslashes(nl2br($row["description"]));

      $i++;
     } 


[CurrentlySober]

U smell of wee-wee

[irbobo]

PHP Code:

<?
$str = "description title:description text;description title2:description text2;";

function data_to_array($str)
{
    foreach( explode(';',$str) as $value )
        if( !empty($value) && strstr($value, ':') )
            $newarray[] =  array( 'title'=>current(explode(':', $value)), 'description'=>end(explode(':', $value)) );
        
    return $newarray;
}

print_r(data_to_array($str));
?>

output is:

Array
(
    [0] => Array
        (
            [title] => description title
            [description] => description text
        )

    [1] => Array
        (
            [title] => description title2
            [description] => description text2
        )

)

[irbobo]

in reference to my above post:

<?
	$mydata = data_to_array($str);
	
	foreach($mydata as $data)
	{
		echo $data['title']."<br />";
		echo $data['description']."<br />";
		echo "<hr />";
	}
?>

[irbobo]

another thing if your PHP is set to super strict you may want to return $newarray as @$newarray to avoid tripping a warning if there is no data sent to the function.

[thunder99]

Thanks fris, StariaDaniel, m4yadult & irbobo. That works!

[irbobo]

just procrastinating

[gornyhuy]

Originally Posted by irbobo

just procrastinating

Same here. Fuck but I'm unmotivated and over tasked today.