unexpected T_STRING in (newbe)

[Québec]

Hi,

I am trying to fill a database mysql with php.

if (!$db){
echo "Error: Could not connect to database. Please try again later.";
exit;
}
mysql_select_db("pierredata");
===================== up tohere is ok
I tried theese two lines and others

INSERT INTO `commentaires`
(`nom`,`courriel`,`sujet`,`commentaire`)VALUES('Mo i2', 'ss@eee.vv',
'Bonjour', 'test');
INSERT INTO `commentaires`
(`nom`,`courriel`,`sujet`,`commentaire`)VALUES(\"M oi2\", \"ss\@eee.vv\",
\"Bonjour\", \"test\");

I get an error

unexpected T_STRING



Jean Pierre


--

--
[url]http://web.jeanpierredaviau.com[/url]

[Rocky]

In article <cX%Zc.55002$681.917031@weber.videotron.net>, [email]Once@WasEno.ugh[/email]
says...

> Hi,
>
> I am trying to fill a database mysql with php.
>
> if (!$db){
> echo "Error: Could not connect to database. Please try again later.";
> exit;
> }
> mysql_select_db("pierredata");
> ===================== up tohere is ok
> I tried theese two lines and others
>
> INSERT INTO `commentaires`
> (`nom`,`courriel`,`sujet`,`commentaire`)VALUES('Mo i2', 'ss@eee.vv',
> 'Bonjour', 'test');
> INSERT INTO `commentaires`
> (`nom`,`courriel`,`sujet`,`commentaire`)VALUES(\"M oi2\", \"ss\@eee.vv\",
> \"Bonjour\", \"test\");
>
> I get an error
>
> unexpected T_STRING
>
>

Assuming you've CREATE-d a TABLE named commentaires with 4
columns/fields ...
Try :
INSERT INTO commentaires VALUES('Moi2','ss@eee.vv','Bonjour','test');

Let's see the TABLE strucure as well.

Rocky
[url]http://www.rockymania.org.uk/[/url]

[Québec]

This line has been generated by the table.
I will try your line
Jean
"Rocky" <admin@rockymania.org.uk> a écrit dans le message de
news:MPG.1ba29ef6825e241098968f@text.news.ntlworld .com...

> In article <cX%Zc.55002$681.917031@weber.videotron.net>, [email]Once@WasEno.ugh[/email]
> says...

> > Hi,
> >
> > I am trying to fill a database mysql with php.
> >
> > if (!$db){
> > echo "Error: Could not connect to database. Please try again

later.";

> > exit;
> > }
> > mysql_select_db("pierredata");
> > ===================== up tohere is ok
> > I tried theese two lines and others
> >
> > INSERT INTO `commentaires`
> > (`nom`,`courriel`,`sujet`,`commentaire`)VALUES('Mo i2', 'ss@eee.vv',
> > 'Bonjour', 'test');
> > INSERT INTO `commentaires`
> > (`nom`,`courriel`,`sujet`,`commentaire`)VALUES(\"M oi2\", \"ss\@eee.vv\",
> > \"Bonjour\", \"test\");
> >
> > I get an error
> >
> > unexpected T_STRING
> >
> >

> Assuming you've CREATE-d a TABLE named commentaires with 4
> columns/fields ...
> Try :
> INSERT INTO commentaires VALUES('Moi2','ss@eee.vv','Bonjour','test');
>
> Let's see the TABLE strucure as well.
>
> Rocky
> [url]http://www.rockymania.org.uk/[/url]

[Québec]

Same problem .

> > Let's see the TABLE strucure as well.

# phpMyAdmin SQL Dump
# version 2.5.3
# [url]http://www.phpmyadmin.net[/url]
#
# Serveur:
# Généré le : Vendredi 03 Septembre 2004 à 15:30
# Version du serveur: 4.0.15
# Version de PHP: 4.3.3
#
# Base de données: `pierredata`
#

# --------------------------------------------------------

#
# Structure de la table `etudiants`
#

CREATE TABLE `etudiants` (
`ID` int(11) NOT NULL auto_increment,
`courriel` char(40) NOT NULL default '',
`passe` char(15) NOT NULL default '',
`nom` char(40) NOT NULL default '',
`peinture` char(20) NOT NULL default '',
`adresse` char(70) NOT NULL default '',
`tel` char(15) NOT NULL default '',
PRIMARY KEY (`ID`)
) TYPE=MyISAM COMMENT='premiere' AUTO_INCREMENT=3 ;

#
# Contenu de la table `etudiants`
#

INSERT INTO `etudiants` VALUES (1, 'foo@foot.ca', 'qWefoo76', 'Jean Pierre
Daviau', '', '12 foo4ave Québec H1B 4N9', '51462');

[Québec]

Sorry,

=====================
# phpMyAdmin SQL Dump
# version 2.5.3
# [url]http://www.phpmyadmin.net[/url]
#
# Serveur: localhost
# Généré le : Vendredi 03 Septembre 2004 à 15:35
# Version du serveur: 4.0.15
# Version de PHP: 4.3.3
#
# Base de données: `pierredata`
#

# --------------------------------------------------------

#
# Structure de la table `commentaires`
#

CREATE TABLE `commentaires` (
`nom` varchar(45) NOT NULL default '',
`courriel` varchar(30) NOT NULL default '',
`sujet` varchar(50) NOT NULL default '',
`commentaire` mediumtext NOT NULL
) TYPE=MyISAM;

#
# Contenu de la table `commentaires`
#

INSERT INTO `commentaires` VALUES ('Jean Pierre Daviau', 'foo@foo.ca',
'Bonjour', 'Un commentaire');

[Rocky]

In article <%J3_c.61015$Vx2.956264@wagner.videotron.net>,
[email]Once@WasEno.ugh[/email] says...

> Sorry,
>
> =====================
> # phpMyAdmin SQL Dump
> # version 2.5.3
> # [url]http://www.phpmyadmin.net[/url]
> #
> # Serveur: localhost
> # Généré le : Vendredi 03 Septembre 2004 à 15:35
> # Version du serveur: 4.0.15
> # Version de PHP: 4.3.3
> #
> # Base de données: `pierredata`
> #
>
> # --------------------------------------------------------
>
> #
> # Structure de la table `commentaires`
> #
>
> CREATE TABLE `commentaires` (
> `nom` varchar(45) NOT NULL default '',
> `courriel` varchar(30) NOT NULL default '',
> `sujet` varchar(50) NOT NULL default '',
> `commentaire` mediumtext NOT NULL
> ) TYPE=MyISAM;
>
> #
> # Contenu de la table `commentaires`
> #
>
> INSERT INTO `commentaires` VALUES ('Jean Pierre Daviau', 'foo@foo.ca',
> 'Bonjour', 'Un commentaire');
>
>

With a DataBase name of pierredata I ran the sql and all worked fine.

Rocky

[Québec]

Thank you. The error must be somewhere else in the code and unrelated to
that line ...

Jean

[Drizzt Do'Urden]

U¿ytkownik "Québec" <Once@WasEno.ugh> napisa³ w wiadomo¶ci
news:cX%Zc.55002$681.917031@weber.videotron.net...

> INSERT INTO `commentaires`
> (`nom`,`courriel`,`sujet`,`commentaire`)VALUES('Mo i2', 'ss@eee.vv',
> 'Bonjour', 'test');
> INSERT INTO `commentaires`
> (`nom`,`courriel`,`sujet`,`commentaire`)VALUES(\"M oi2\", \"ss\@eee.vv\",
> \"Bonjour\", \"test\");
>
> I get an error
>
> unexpected T_STRING

Did You put an sql query directly into PHP code? unexpected T_STRING is
probably 'INSERT' word which is not
an PHP function.:)
Look like really newbie problem :) And all replies too...LOL
Try:
mysql_query("INSERT INTO `commentaires`
(`nom`,`courriel`,`sujet`,`commentaire`)VALUES('Mo i2', 'ss@eee.vv',
'Bonjour', 'test')");
Read about:
[url]http://www.php.net/manual/en/function.mysql-query.php[/url]

Drizzt

[Québec]

I have an autoincrement ID in column 1
I have a Date in column 8
Should this work and the first and last columns taken care by mySql
automatically?

mysql_query("INSERT INTO `etudiants` (`courriel`, `passe`, `nom`, `image`,
`adresse`,`telephone`)VALUES($courrielty , $passe, $nomty, $imagety,
$addressty, $telty)");

Jean

[Drizzt Do'Urden]

U¿ytkownik "Québec" <Once@WasEno.ugh> napisa³ w wiadomo¶ci
news:cj2%c.7078$dd5.769719@weber.videotron.net...

> I have an autoincrement ID in column 1
> I have a Date in column 8
> Should this work and the first and last columns taken care by mySql
> automatically?
>
> mysql_query("INSERT INTO `etudiants` (`courriel`, `passe`, `nom`, `image`,
> `adresse`,`telephone`)VALUES($courrielty , $passe, $nomty, $imagety,
> $addressty, $telty)");
>
> Jean

autoincrement - yes - will be do automatically
Date - no - have to add `Date` to field list and NOW() to values list

Drizzt

[Québec]

> autoincrement - yes - will be do automatically

> Date - no - have to add `Date` to field list and NOW() to values list

I took off the ID and used
mysql_query("INSERT INTO `commentaires`(`nom`, `courriel`, `sujet`,
`commentaire`, `date`) VALUES ($nom, $courriel, $sujet, $commentaire,
NOW())");

The result is printed in a html page before the variables go thrue
addslashes.
nothing is written in the table commentaires
I am using EasyPHP 1.7

Jean

-------------------php ------------

$sujet = $_REQUEST['sujet'];
$nom = $_REQUEST['nom'];
$courriel = $_REQUEST['courriel'];
$commentaire = $_REQUEST['commentaire'];

$empty = array($nom, $courriel, $sujet, $commentaire);
$empty2 = array("nom", "courriel", "sujet", "commentaire");
$j = 0;
$missing = "<p>";

while($j < 4){
if($empty[$j] == "")
$missing = $missing.$empty2[$j]."<br>";
$j++;
}
if($missing != "<p>") {
printf("Formulaire incomplet: %s <br>manquant(s).", $missing);
printf("<p><a
href='http://127.0.0.1/JeanPierreDaviau/feedback.htm'>Complétez le
formulaire.</a>");
exit;
}

$db = mysql_pconnect("localhost", "root", "secret");
if (!$db){
echo "Error: Could not connect to database. Please try again later.";
exit;
}
echo $db."<---<br>";
mysql_select_db("pierredata");
echo "<p>".$nom."<br>".$courriel."<br>".$sujet."<br>".$ commentaire."</p>";
echo "<p>merci de votre attention.</p>";


$nom = addslashes($nom);
$courriel = addslashes($courriel);
$sujet = addslashes($sujet);
$commentaire = addslashes($commentaire);


mysql_query("INSERT INTO `commentaires`(`nom`, `courriel`, `sujet`,
`commentaire`, `date`) VALUES ($nom, $courriel, $sujet, $commentaire,
NOW())");
?>
----------------

[Québec]

I get It!
variables must be in quotes '$name' etc

thanks.

[Unregistered]

U¿ytkownik "Québec" <Once@WasEno.ugh> napisa³ w wiadomo¶ci
news:cX%Zc.55002$681.917031@weber.videotron.net...

Did You put an sql query directly into PHP code? unexpected T_STRING is
probably 'INSERT' word which is not
an PHP function.:)
Look like really newbie problem :) And all replies too...LOL
Try:
mysql_query("INSERT INTO `commentaires`
(`nom`,`courriel`,`sujet`,`commentaire`)VALUES('Mo i2', 'ss@eee.vv',
'Bonjour', 'test')");
Read about:
[url]http://www.php.net/manual/en/function.mysql-query.php[/url]

Drizzt

I had spent hours and hours trying to get my DB to allow records to be added via Web (MySQL and PHP). Many Website searches, reading wikis and tutorials/resources later I was getting closer but still blowing it up on the add part - it would connect just fine. Your instructions above had all the answers to my syntax problems - Thanks!