Error querying database.

Posted on 16th Feb 2014 07:03 pm by admin

I get the above error when trying to insert some values to a datatable.
Here's the code :

Code: $dbc = mysqli_connect('127.0.0.1:3306', 'root', 'xxxx', 'aliendatabase')
or die('Error connecting to MySQL server.');

$query = "INSERT INTO aliens_abduction (first_name, last_name, " .
"when_it_happened, how_long, how_many, alien_description, " .
"what_they_did, fang_spotted, other, email) " .
"VALUES ('myFirstName', 'myLastName', '5 years ago', '2 years', '7 aliens', " .
"green eyes', 'we talked', " .
"'yes', 'none@gmail.com')";

$result = mysqli_query($dbc, $query)
or die('Error querying database.');

mysqli_close($dbc);

Any ideas on what am I doing wrong?
Thank you very much

Your Answer:

Login to answer

Other forums

xApp Analytics in BI 7.0
Dear all,

I am trying to implement xApp Analytics in BI 7.0. After I installed the analyt

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

Random Number Generation And Probability
Hello, I am working on a function which has to insert data into a SQL table.

we have to suppl

images aren't rendering
I'm trying to call a JPG file from within PHP (in an effort to hide the actual JPG folder). The imag

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from

Cache PHP Objects/Classes?
Does anyone have ideas about caching PHP objects using something like: http://memcached.org/

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

Applet JTextField Size Problem
Hello,

I recently started making an applet to calculate certain values for airplanes. However

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

RSS poster script?
I have found a script that posts RSS's for me on a site that I'm building. However I would like to a