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

I need desperate help with this php code integrated with flash please
Can someone please help me with this php code which I have been stuck on for weeks . I am trying to

Display data returned from Ajaxservices!!
I have a question about displaying results using ajax. I have part of the code below.
$.ajax({

my login script page is not working on remote computers
hi my login is working on my computer, but when i tried 2 computers from 2 different locations, they

Google Map
I have done Google Map Integration for one my project. But for that we need the "latitude and l

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

Create multiple (n) arrays
Hi there,

I have the following need:

I have 2 arrays (coming from a databases)

opening a window with after form submission
I know this this forum has nothing to do with JS, but i'm trying to use it with my php script.
<

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

Impact of movement type 412 E on MAP
Hi

Usage of movement type 412 E is causing huge change in MAP .

Is there any r