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

Other php-forum

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Page doesn't expand for content
Hi. I've been testing a query I made. It's here http://lapr1.6te.net/inquerito.php
The page doesn

code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page.

The pro

Online Event Ticket Sales
Has anyone wrote a script for online tickets sales?

I have been googling and found lots of th

2 decima places & How to reload my page
Hello There,

How do i put full-stop (.) after second figure from behind? ie if i have 123456

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

help with this code please?
Hello,

I am trying to build a remote upload script for my image hosting site.

I am usi

php multiple action on submit
I have a form which says:

<form enctype='multipart/form-data' method='post' action='pr

returning data from an ssh2_exec()
here's what i got.


$conn = ssh2_connect($this->_host);
ssh2_auth_password($c

rookie looking for help coding a CSS form with PHP
I'm trying to figure out how to add PHP code to my xhtml form so that it is a working form embedded