PHP
PHP
HTML
HTML
Programming Languages-Other
Programming Languages-Other

php debugging, parsing commer value getting variable numbers

i have in database value that refers to ids of a another table it consists of numbers separates by' ,'
i want to get rid of the' ,' and get each différent numbers in variables
in my code i use
$mots_clefs = $row['mots_clefs'];
but i have
Warning: implode() [function.implode]: Invalid arguments passed in C:\wamp\www\citations\affiche_citations.php on line 12

what can i do?
please help

CREATE TABLE IF NOT EXISTS `citations` (
  `id` int(11) unsigned NOT NULL,
  `auteur` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `texte` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `mots_clefs` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Contenu de la table `citations`
--

INSERT INTO `citations` (`id`, `auteur`, `texte`, `mots_clefs`) VALUES
(1, '1', 'À elle seule,La vie est une citation.', '10,11'),
(0, '1', 'À elle seule,La vie est une citation.', '37,38,39');

Open in new window

php

$query1 = "SELECT * FROM citations";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1))
{
$id=$row['auteur'];
$mots_clefs = $row['mots_clefs'];

$mots_clefs2 = implode(',', $mots_clefs);

$query2 = "SELECT NOM FROM auteurs where id=$id";
$result2 = mysql_query($query2) or die(mysql_error());
$row2 = mysql_fetch_array($result2);

$auteur= $row2[0];
$texte = $row['texte'];
$mots_clefs = $row['mots_clefs'];
      echo $texte ;
      echo "<strong>";
      echo $auteur;
      echo "</strong>";
      echo $mots_clefs;
echo"</br>";

jerrrrryAsked: 2014-04-05

Who is Participating?

Solutions

Advertise Here

LVL 35

Dan CraciunConnect With a Mentor IT ConsultantCommented: 2014-04-06

There's something fishy going on. Try this:

require_once ("fonctions/connec.php");
$query1 = "SELECT texte, mots_clefs, nom
           FROM citations LEFT JOIN auteurs ON citations.auteur = auteurs.id";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1)) {
    $auteur = $row['nom'];
    $texte  = $row['texte'];
    $mots_clefs_ids =  $row['mots_clefs'];
    $mots_clefs = array();
    
    $query2 = "SELECT nom FROM mots_clefs WHERE id IN ($mots_clefs_ids)";
    $result2 = mysql_query($query2) or die(mysql_error());
    while ($row2 = mysql_fetch_array($result2)) {
        $mots_clefs[] = $row2['nom'];
    };
    $mots_clefs = implode(',', $mots_clefs);
   
    echo "$texte<strong>$auteur</strong>$mots_clefs<br />";
}

Open in new window

LVL 35

Dan CraciunIT ConsultantCommented: 2014-04-05

$mots_clefs = $row['mots_clefs'];
This means $mots_clefs is a string, not an array. implode expects an array.

I don't really see where you use $mots_clefs2. You set it as an erroneous value, then forget about it.

PS: Ray will be here momentarily to tell you to switch from mysql to mysqli or PDO.

HTH,
Dan

jerrrrryAuthor Commented: 2014-04-05

so, what can i write instead?
thanks

LVL 35

Dan CraciunIT ConsultantCommented: 2014-04-05

You probably wanted something like:
$query2 = "SELECT NOM FROM auteurs where id IN ($mots_clefs)";

LVL 35

Dan CraciunIT ConsultantCommented: 2014-04-05

This should work, but it's ugly and screams for refactoring. Plus it's missing the connection to the keywords table, you're only outputting the id's of the keywords.

$query1 = "SELECT * FROM citations";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1))
  {
  $auteur_id=$row['auteur'];
  $mots_clefs = $row['mots_clefs'];  
   
  $query2 = "SELECT NOM FROM auteurs where id = $auteur_id";
  $result2 = mysql_query($query2) or die(mysql_error());
  $row2 = mysql_fetch_array($result2);

   $auteur= $row2[0];
   $texte = $row['texte'];
 
      echo $texte ;
      echo "<strong>";
      echo  $auteur; 
      echo "</strong>";
      echo $mots_clefs;   
echo"</br>";
}

Open in new window

jerrrrryAuthor Commented: 2014-04-05

infact i will make a third query getting info in a mots_clefs table
but i need to get the $mots_clefs data without the , and each one alone

$query3 = "SELECT NOM FROM `mots_clefs` where id='$motclef'";

CREATE TABLE IF NOT EXISTS `mots_clefs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Nom` varchar(80) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

--
-- Contenu de la table `mots_clefs`
--

INSERT INTO `mots_clefs` (`id`, `Nom`) VALUES
(1, 'vie'),
(33, ' test2'),
(34, 'test3'),
(35, 'test1'),
(36, 'test2'),
(37, 'test1'),
(38, 'test2'),
(39, 'test3');

Open in new window

LVL 111

Ray PaseurCommented: 2014-04-05

Good news. Even if you are new to PHP, you can still look up every PHP function on the PHP.net web site. Examples include these functions. You must read and understand this stuff if you want to write PHP code, no excuses. If your script spits out a message, the first line of defense is to look up the function and make sure your script is using it in a way that makes sense.
http://php.net/implode
http://php.net/explode

And Dan's right. You're going to need to switch from MySQL to MySQLi or PDO. Better to do it now on your own schedule than wait and find your scripts spitting out deprecated messages.

jerrrrryAuthor Commented: 2014-04-05

$pizza = "piece1,piece2,piece3,piece4,piece5,piece6";
$pieces = explode(",", $mots_clefs);
echo $pieces[0]; // piece1
echo $pieces[1]; // piece2

is it possible to tell php to consider this string like $mots_clefs = $row['mots_clefs'];

(that is '37,38,39') to a array?
thanks?

LVL 35

Dan CraciunIT ConsultantCommented: 2014-04-05

Here's a still ugly code that should work with all 3 tables (and only 2 queries):

$query1 = "SELECT citations.id, auteur, texte, mots_clefs, nom 
           FROM citations LEFT JOIN auteurs ON citation.auteur = auteur.id";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1)) {
    $auteur = $row['nom'];
    $texte  = $row['texte'];
    $mots_clefs_ids =  $row['mots_clefs'];
    $mots_clefs = array();
    
    $query2 = "SELECT nom FROM mots_clefs WHERE id IN ($mots_clefs_ids)";
    $result2 = mysql_query($query2) or die(mysql_error());
    while ($row2 = mysql_fetch_array($result2);) {
        $mots_clefs[] = $row2['nom'];
    };
    $mots_clefs = implode(',', $mots_clefs);
    echo "$texte<strong>$auteur</strong>$mots_clefs<br />";
}

Open in new window

LVL 35

Dan CraciunIT ConsultantCommented: 2014-04-05

i need to get the $mots_clefs data without the , and each one alone

No, you don't. You need that data to stay just the way it is, so you can use it in the IN clause:

SELECT nom FROM mots_clefs WHERE id IN (37,38,39)

Open in new window

LVL 111

Ray PaseurCommented: 2014-04-05

Really, you gotta look this stuff up and try to get an understanding. Here is a code fragment from an earlier post annotated with comments.

/**
 * IN THE FOLLOWING INSTRUCTION WE WILL TAKE A LITERAL STRING
 * AND ASSIGN IT TO A VARIABLE NAMED $pizza
 */
$pizza  = "piece1,piece2,piece3,piece4,piece5,piece6";

/**
 * IN THE FOLLOWING INSTRUCTION WE WILL TAKE AN UNDEFINED VARIABLE
 * AND USE IT AS AN ARGUMENT TO A FUNCTION CALL.  $pizza IS NOT THE SAME
 * VARIABLE AS $mots_clefs AND $mots_clefs IS UNDEFINED, SO explode() WILL
 * ISSUE A NOTICE AND THE VALUE ASSIGNED TO $pieces WILL BE MEANINGLESS
 */
 $pieces = explode(",", $mots_clefs);

Open in new window

jerrrrryAuthor Commented: 2014-04-06

sorry i made a mistake with $pizza
this is better $pieces = explode(",", $pizza);

i tried this

<?php
require_once ("fonctions/connec.php");
$query1 = "SELECT citations.id, auteur, texte, mots_clefs, nom 
           FROM citations LEFT JOIN auteurs ON citation.auteur = auteur.id";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1)) {
    $auteur = $row['nom'];
    $texte  = $row['texte'];
    $mots_clefs_ids =  $row['mots_clefs'];
   $mots_clefs = array();
    
    $query2 = "SELECT Nom FROM mots_clefs WHERE id IN ($mots_clefs_ids)";
    $result2 = mysql_query($query2) or die(mysql_error());
    while ($row2 = mysql_fetch_array($result2);) {
        $mots_clefs[] = $row2['nom'];
    };
   
    echo "$texte<strong>$auteur</strong>$mots_clefs<br />";
}


?>

Open in new window

but i get this
Parse error: parse error in C:\wamp\www\citations\affiche_citations.php on line 14 ????
thanks for helping me

LVL 111

Ray PaseurCommented: 2014-04-06

In this line 14:

while ($row2 = mysql_fetch_array($result2);) {

The semi-colon is out of place. Omit it.

And really, get yourself some quality time with this book. You can spend a month here or a year of trial and error. Save your time!
http://www.amazon.com/PHP-MySQL-Web-Development-Edition/dp/0321833899

jerrrrryAuthor Commented: 2014-04-06

i laughed a bit because i will have to wait a while for the book...
there was a missing s on auteur so i add it but a don't have what i want still....

require_once ("fonctions/connec.php");
$query1 = "SELECT citations.id, auteur, texte, mots_clefs
           FROM citations LEFT JOIN auteurs ON citations.auteur = auteurs.id";
$result1 = mysql_query($query1) or die(mysql_error());
while($row = mysql_fetch_array($result1)) {
    $auteur = $row['auteur'];
    $texte  = $row['texte'];
    $mots_clefs_ids =  $row['mots_clefs'];
   $mots_clefs = array();
    
    $query2 = "SELECT Nom FROM mots_clefs WHERE id IN ($mots_clefs_ids)";
    $result2 = mysql_query($query2) or die(mysql_error());
    while ($row2 = mysql_fetch_array($result2)) {
        $mots_clefs[] = $row2['nom'];
    };
   
    echo "$texte<strong>$auteur</strong>$mots_clefs<br />";
}

Open in new window

i have this error
Notice: Undefined index: nom in C:\wamp\www\citations\affiche_citations.php on line 15

Notice: Undefined index: nom in C:\wamp\www\citations\affiche_citations.php on line 15
¿ elle seule,La vie est une citation.1Array

Notice: Undefined index: nom in C:\wamp\www\citations\affiche_citations.php on line 15

Notice: Undefined index: nom in C:\wamp\www\citations\affiche_citations.php on line 15

Notice: Undefined index: nom in C:\wamp\www\citations\affiche_citations.php on line 15
¿ elle seule,La vie est une citation.1Array
sql.txt

LVL 111

Ray PaseurCommented: 2014-04-06

This Nom is capitalized:

$query2 = "SELECT Nom FROM mots_clefs WHERE id IN ($mots_clefs_ids)";

This nom is not capitalized:

$mots_clefs[] = $row2['nom'];

In PHP, variables are case-sensitive. So are table and column names in MySQL. These are the sorts of things that you'll learn when you start some structured study of PHP and MySQL. You will be amazed how quickly the stumbling blocks can turn into stepping stones as you start the practice exercises in a well-developed curriculum.

Anyway, we seem to be wandering now. Have we answered your original question?

jerrrrryAuthor Commented: 2014-04-06

no you have not answered yet the question, because i don't have the correct answer
i should have¿ elle seule,La vie est une citation. Jorge Luis BORGES keyword1 keyword2
¿ elle seule,La vie est une citation. Jorge Luis BORGES test1 test2
i have
¿ elle seule,La vie est une citation.1Array
¿ elle seule,La vie est une citation.1Array

i know there is accent issue we talked about with latin characters, not a problem here now i ll fix it later

LVL 35

Dan CraciunIT ConsultantCommented: 2014-04-06

You forgot this line:

$mots_clefs = implode(',', $mots_clefs);

Open in new window

Without it you're echoing an array instead of a string...

jerrrrryAuthor Commented: 2014-04-06

then i have this
¿ elle seule,La vie est une citation.Jorge Luis BORGESArray
¿ elle seule,La vie est une citation.Jorge Luis BORGESArray
?

LVL 111

Ray PaseurConnect With a Mentor Commented: 2014-04-06

Hopefully by now you understand why you do not want more than one data element in any column. All of this is unnecessary and confusing if the data base tables are designed correctly.

Here is an annotated bit of code explaining line-by-line what's going on. I'll sign off now. Best of luck with your project and please, please give yourself some much-needed quality time with that book!

/**
 * Using the while() iterator, retrieve data from the $result2 resource
 * with the fetch_array() function (which retrieves twice as much data as
 * you need, making it the least efficient way to retrieve the data). A
 * better choice would be fetch_object().
 *
 * Each iteration will load data into an array named $row2, then the next
 * instruction will be executed, inside the control structure.
 */
while ($row2 = mysql_fetch_array($result2)) {

/**
 * As each $row2 array is created, go into the array and find the value 
 * of the variable at the index named 'nom' and copy this value into an
 * array named $mots_clefs.  Because of the empty square bracket notation 
 * after $mots_clefs PHP knows (1) this is an array and (2) the variable
 * from $row['nom'] is to be appended to the array in a new numbered element.
 */
    $mots_clefs[] = $row2['nom'];

/**
 * This is the end of the control structure created by the while() iterator.
 * The semicolon is superfluous and should be removed to avoid confusion.
 */
};

/**
 * This echo statement writes the contents of three variables and some
 * string literals to the browser output stream.  Because some of the 
 * variables are strings the contents of the variable will be sent.  But 
 * PHP does not know what you want to print when you use an array with 
 * echo, so it just prints the word "Array" and ignores the data.
 */
echo "$texte<strong>$auteur</strong>$mots_clefs<br />";

/**
 * This is likely what you want just before the echo statement.  It will 
 * take the $mots_clefs array and turn it into a string variable, with each 
 * of the elements of the array separated by commas in the resulting string.
 * PHP will overwrite the $mots_clefs array variable with the new string.
 */
$mots_clefs = implode(',', $mots_clefs);

Open in new window

jerrrrryAuthor Commented: 2014-04-10

100points for ray for the explaination
400 points for the solution

now there is still http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/Q_28387674.html to achieve

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Already a member? Login.

All Courses

From novice to tech pro — start learning today.

By:

Ken Mayer

Course of the Month6 days, 19 hours left to enroll

Certification
Monitoring and Operating a Private Cloud with System Center 2012 R2

Premium

Premium members can enroll in this course at no extra cost.
Learn More

273 lessons
By:

Thomas Zucker-Scharff

How to Prepare for and Navigate a Ransomware Attack

Premium

Premium members can enroll in this course at no extra cost.
Learn More

36 lessons
By:

Ben Brumm

Introduction to Oracle SQL

Premium

Premium members can enroll in this course at no extra cost.
Learn More

67 lessons
By:

Habib Z

Learn how to use and implement OSPF in various network designs

Premium

Premium members can enroll in this course at no extra cost.
Learn More

10 lessons
By:

Paul Kent

Programming for You: Introduction to C++

Premium

Premium members can enroll in this course at no extra cost.
Learn More

17 lessons
By:

Rodney Barnhardt

Migrating and Managing Backup Exec 2014

Premium

Premium members can enroll in this course at no extra cost.
Learn More

3 lessons
By:

Phil Phillips

Networking in Amazon Web Services

Premium

Premium members can enroll in this course at no extra cost.
Learn More

5 lessons
By:

Sergio ZAP

Test Your Applications on Mobile, Desktop and Web

Premium

Premium members can enroll in this course at no extra cost.
Learn More

10 lessons
By:

Habib Z

Practical Implementation of How to Filter routes from the Routers

Premium

Premium members can enroll in this course at no extra cost.
Learn More

5 lessons
By:

Tracy Preston

Certification
Certified Penetration Testing Engineer (CPTE) Training

Premium

Premium members can enroll in this course at no extra cost.
Learn More

15 lessons

Expand your skills with this month's free Premium course.

php debugging, parsing commer value getting variable numbers

Who is Participating?

Already a member? Login.