Explode database array PHP

Question

I'm trying to breakdown a paragraph, retrieved from a database array, into separate words. Is this the right way to go about doing it because it is currently giving an error saying explode() expects 2 parameters, so it must not be picking up the $row array.

function words() {
        $query = mysql_query("SELECT text FROM table WHERE textID = 1");
        while($row = mysql_fetch_array($query)) {
            $e[] = explode(" ", $row);
            foreach($e as $r) {
                echo $r;
            }
        }
    }

noob · Accepted Answer · 2012-04-29 10:26:05Z

3

function words() {
        $query = mysql_query("SELECT text FROM table WHERE textID = 1");
        while($row = mysql_fetch_array($query)) {
            $e[] = explode(" ", $row[0]);
            foreach($e as $r) {
                echo $r;
            }
        }
    }

$row is array. Choose first element to explode. Read documentation for Explode.

edited Apr 29, 2012 at 10:26

noob

9,2224 gold badges40 silver badges65 bronze badges

answered Apr 29, 2012 at 10:10

Denis Ermolin

5,5746 gold badges29 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ashley Over a year ago

I missed that part. Thank you very much.

Lock · Accepted Answer · 2012-04-29 10:29:52Z

0

function words() { 
        $query = mysql_query("SELECT text FROM table WHERE textID = 1"); 
        while($row = mysql_fetch_array($query)) { 
            $e[] = explode(" ", $row[0]); 
            foreach($e as $r) { 
                echo $r; 
            } 
        } 
    }

answered Apr 29, 2012 at 10:29

Lock

5,53217 gold badges71 silver badges116 bronze badges

2 Comments

Denis Ermolin Over a year ago

mysql_fetch_assoc will return to you array with "text" field

Lock Over a year ago

Oops didnt notice that he is using mysql_fetch_array.

Your Common Sense · Accepted Answer · 2012-04-29 10:39:45Z

You are using wrong functions architecture here.
You don't need words() function at all. explode is enough.
While you strongly need a function to get data from mysql, which is apparently unrelated to your explode needs.
Also note that a function should never do any output but retirn values only (save for the functions intended for the output only).

So, the function could be

function dbgetvar($query){
  $res = mysql_query($query);
  if (!$res) {
    trigger_error("dbget: ".mysql_error()." in ".$query);
    return FALSE;
  }
  $row = mysql_fetch_row($res);
  if (!$row) return NULL;
  return $row[0];
}

And your code become as simple as

$text  = dbgetvar("SELECT text FROM table WHERE textID = 1");
$words = explode(" ",$text);
foreach ($words as $w) echo $w;

X10nD · Accepted Answer · 2012-04-29 10:44:47Z

-1

function words() {
        $query = mysql_query("SELECT text FROM table WHERE textID = 1");
        while($row = mysql_fetch_array($query)) {
            $e = explode(" ", $row);
            foreach($e[0] as $r) {
                echo $r;
            }
            }
    }

The $row is populated entirely with the field value therefore $e[0] is the right variable.

answered Apr 29, 2012 at 10:44

X10nD

22.1k46 gold badges113 silver badges154 bronze badges

Collectives™ on Stack Overflow

Explode database array PHP

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related