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

Need help with cin setw
I made a program here is my code:

#include
#include
#i

Insert Failing.
Hey,
I am making a Sign up page for a website, but the insert query into the Database does not se

Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

what business processes?
Hi,

A general question. What business processes (like OTC - Order to Cach, P2P, R2R etc)

unexpected T_SL without a shift left token
Nothing too see here, I'm an idiot and resolved the problem.

Setting a default timezone?
I have read about how to change the timezone in PHPMYADMIN, but it changes back, it doesn't STAY the

Parse multirow HTML table
Hello all,
I have a site I am working on. Its a sports site and I am trying to add stats to a DB

single values into sql field
i have a form which i want the user to able to select multiple answers. But i want the answers to be

PHP template help
Ok, I don't know if anyone can help me but I am using PHP templates to make a site. I am a newbie an