May 27, 2013

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

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>

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.

March 9, 2013

Running a Zend Framework Project on a shared server

Question by 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 by 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]
October 9, 2012

Load php_oauth.dll into local server

Question by 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 by 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.

March 11, 2012

How to login in MySQL with a Non Root user

Question by 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 by 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.

  1. Find the phpmyadmin installation or project file
  2. Open the file called config.inc.php
  3. 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';
    
June 4, 2010

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

Question by 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 by 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

...

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