Register for your free account! | Forgot your password?

Go Back   elitepvpers > Coders Den > Web Development
You last visited: Today at 12:51

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



PDO -> Query falsch?

Discussion on PDO -> Query falsch? within the Web Development forum part of the Coders Den category.

Reply
 
Old   #1
 
elite*gold: 300
Join Date: Apr 2013
Posts: 3,234
Received Thanks: 1,205
PDO -> Query falsch?

Hey, könnt ihr mir evtl. sagen was an dieser Query falsch ist?

PHP Code:
$statement $pdo->prepare("INSERT INTO ticketsystem.tickets(ticketid, reporter, reportdate, lastreplier, title, message) VAUES (?, ?, ?, ?, ?, ?)");
        
$statement->execute(array($result[0]+1$reporterdate('Y-m-d H:i:s'), 'customer'$title$description)); 
PHP sagt mir diesen Error:

Quote:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VAUES ('1', 'test', '2013-01-01', 'test', 'testtitel', 'test')' at line 1' in /var/www/ticketsystem/pages/newTicket.php:25 Stack trace: #0 /var/www/ticketsystem/pages/newTicket.php(25): PDOStatement->execute(Array) #1 /var/www/ticketsystem/pages/contentLoader.php(7): include('/var/www/ticket...') #2 /var/www/ticketsystem/frontend/main.php(28): include('/var/www/ticket...') #3 /var/www/ticketsystem/index.php(7): include('/var/www/ticket...') #4 {main} thrown in /var/www/ticketsystem/pages/newTicket.php on line 25
#Saiirex is offline  
Old 03/13/2016, 12:50   #2
dotCom
 
Devsome's Avatar
 
elite*gold: 12400
The Black Market: 104/0/0
Join Date: Mar 2009
Posts: 15,881
Received Thanks: 4,386
Schreib VAUES mal in VALUES , sollte dann klappen.
Devsome is offline  
Thanks
2 Users
Reply


Similar Threads Similar Threads
Query falsch kann einer verbessern ?
11/27/2011 - Metin2 Private Server - 6 Replies
Ich will neue Waffen einfügen aber die query ist falsch kann einer mir die verbessern ? INSERT INTO `item_proto`...
Query » Was ist daran falsch ?!
07/02/2011 - Metin2 Private Server - 2 Replies
Hey Leute, ich habe wieder eine Falsche Query: Und der Fehler lautet:
Query » Was ist daran falsch ?!
07/02/2011 - Metin2 Private Server - 2 Replies
Hey Leute, habe mir gestern eine Query für mein Item entworfen. Als ich fertig war, wollte ich sie einfügen, doch dann kam diese Fehlermeldung: Die Query sieht so aus:
[PHP] Mysql Query - Richtig oder Falsch ?
09/22/2010 - Web Development - 4 Replies
Hi, Ich würde gern euch Fragen ob mein Php Script funktionieren würde. < Anfänger :P <?php $con = mysql_connect("x","x","x& quot;); if (!$con) { die('Could not connect: ' . mysql_error());



All times are GMT +2. The time now is 12:51.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.