Error: Unknown column 'Date' in 'field list'

Question 1

Manju’s Question:

I am working on a blood bank data base but i am repeatedly getting a Error: Unknown column ‘Date’ in ‘field list’.there is no spelling error in either php or mysql so here is my php code

<?php
    $con=mysqli_connect("localhost","root","","bloodbank");
    // Check connection
   if (mysqli_connect_errno())
   {
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }

   $sql="INSERT INTO users       (First,Last,Date,Email,Contact,Bloodgroup,Gender,address,City,username,password)
    VALUES
    ('$_POST[first]','$_POST[last]','$_POST[dob]','$_POST[email]','$_POST[contact]','$_POST[bg]',
'$_POST[sex]','$_POST[address]','$_POST[city]','$_POST[username]','$_POST[password]')";

    if (!mysqli_query($con,$sql))
    {
    die('Error: ' . mysqli_error($con));
    }
    echo "1 record added";

    mysqli_close($con);
    ?></code>

Answer

Starx

Basic explanation would be that Your query does not matches with your table structure

INSERT INTO users(First,Last,Date
                             ^ // Right here you are using it

Check your table structure using tools like phpMyAdmin and if the field does exist, Date is a reserved word so that might be creating the problem.

Question 2

Question by Mikey

Mikey

I’m trying to upload my ZF Project to shared hosting

On my XAMPP, ZF’s index page is located (and I access my page) at http://localhost/ZFprojectname/public

On the shared hosting in the root directory I have installed Joomla.

I want to access my ZF in the manner of http://mywebsite.com/booking/

so in this case, when going to http://mywebsite.com/booking/ I should be accessing ZF’s public folder (as far as I understand).

And, I’d like to put my ZFproject in public_html/somefolderName/

How would you do it?

Answer

Answer by Starx

Starx

Shared hosting do not support defining Document Root path so you can use .htaccess to forward the request to public folder instead.

Create a .htaccess file inside the booking directory with the following rule.

RewriteEngine On

RewriteRule ^.htaccess$ - [F]

RewriteCond %{REQUEST_URI} =""
RewriteRule ^.*$ /public/index.php [NC,L]

RewriteCond %{REQUEST_URI} !^/public/.*$
RewriteRule ^(.*)$ /public/$1

RewriteCond %{REQUEST_FILENAME} -f
RewriteRule ^.*$ - [NC,L]

RewriteRule ^public/.*$ /public/index.php [NC,L]

Question 3

Question by Nich

Nich

I’m facing problem to load the php_oauth.dll extension for my xampp. I downloaded the php_oauth.dll and added extension=php_oauth.dll in php.ini , but when i restart my apache, it cannot start the server anymore.

I’m using window 7 ,64bits.
Initially, I download the file from
http://downloads.php.net/pierre/

but i found that it was 32bits file , so I’m searching fo 64bit and found out
http://www.mediafire.com/php-win64-extensions

unfortunately,I still cannot load the oauth. Any solution to solve it? I look through many article, but it seems like dont have it, anyone can provide ,so that, others that using win 64bit can follow

Thank you!

Answer

Answer by Starx

Starx

This looks to be like a path problem. Make sure the extension is store in the correct extension directory.

The settings of this can be found inside php.ini as something like

extension_dir = C:phpextensions

By default this is ext folder inside PHP installation.

Or, follow the instruction from PHP manual while installing extensions, if you are not sure what you are doing.

Question 4

Question by sandbox

sandbox

I have setup 2 user Uone and Utwo in Mysql. But when I open localhost/phpmyadmin it logins with root user. What URL is used to login with Uone or Utwo user. I am running Mysql from XAMPP.

Answer

Answer by Starx

Starx

IF you had installed phpmyadmin separately, you would be asked for username and password in the startup.

Since you have a pre-installed version of phpmyadmin. You can do the following to do so.

Find the phpmyadmin installation or project file
Open the file called config.inc.php

Inside you will find details to change the username and password ...

$cfg['Servers'][$i]['user']          = 'Uone';
$cfg['Servers'][$i]['password']      = 'cbb74bc'; // use here your password
$cfg['Servers'][$i]['auth_type']     = 'config';

Question 5

Question by n_openid

n_openid

I am using xampp on Windows Vista. I want to run a php script once every x minutes.

Is there any way in xampp to help facilitate this, or is using the Windows Task Scheduler the only way?

Answer

Answer by Starx

Starx

in windows task schedular is the only way i think
in linux you can use cron

Question 6

Question by Starx

Starx

I know that softwares like WAMP, XAMPP save a lot of difficult configuration time. But, besides this, Is this a good idea? I, on the other would like to stick to traditional method and install each component seperately and use them.

Answer

Answer by Starx

Starx

Of course it’s a good idea. Easy configuration means, saved time. Saved time means, projects complete fast. Fast completion of projects means more projects and More projects mean more money. 🙂 lol

Tag: xampp

Error: Unknown column 'Date' in 'field list'

Manju’s Question:

Running a Zend Framework Project on a shared server

Question by Mikey

Answer by Starx

Load php_oauth.dll into local server

Question by Nich

Answer by Starx

How to login in MySQL with a Non Root user

Question by sandbox

Answer by Starx

Schedule php script in xampp

Question by n_openid

Answer by Starx

Is using AMP software like WAMP, MAMP, XAMPP a good idea?

Question by Starx

Answer by Starx

Please fill the form - I will response as fast as I can!