PHP debugging tips

BETWEEN operator is not working in MYSQL:

1. Check the field type it must be datetime
2. please check that in between first date must be less than second date

2.mysql_real_escape_string not working with trim:
please check that trim must be inside the mysql_real_escape_string

Problem in posting form
nested form

Everything is fine but script is unable to run

try to change short php tags to standard php tags

i.e. <? to <?php and <?= to <?php echo
 change some apache server not support short tags

My script is not going in the given if condition even if condition satisfy

if it is comparison then check for proper assignment sign.
It may possible that you have used = instead of ==

Commands out of sync; You can't run this command now

close the connection and then make same connection again

style padding is not working in html

check you have also given align ="" attribute to td.
align and padding not work simultaneously

First my script was working finely but now suddenly it stops working:

1. check the folders name. It may be possilbe that inclusion path have been changed asyou have rename some folder.
2. check whether you have checked database name, or table name, or change the coloumn type , size,

All is fine but multiple selected value of checkbox array return empty array

1. Don't use mysql_real_escape_strings with array field while retrieving this value from form.
2. Have you used name as array while fetching the POSTED value.
e.g.: country as country[]

strpos not working

It is a different function so be careful while using it.
Point to be noted:
1. This functions returned value can be compared by "===" operator and not with "==" as usual we do normally.
2. All function return a definite value but this is not true for this function:
it may return: either "0" or "false" or ""
so you have apply validation for all these three cases in case of false condition of this function.


Unable to upload file

1. Have you define enctype in form tag
2.Folder permission of the folder in which file has been uploaded must be "777"
3.File size of the file to be upload must be within the upload limit

Did not find any bug but phpmyadmin is showing error in query

1. Please check that wether table name and field name must be different.
2. Coloumn name should not have the name which are reserved keyword for mysql (e.g many people used desc for description but desc is reserved keyword for DESCENDING ORDER in mysql)

 Switch case is giving wrong result
 
  1. Are you sure you have use break after all cases.

I could not understand why Everything is ok but only Partial value is inserted in the database table ?

  Have you check the field length of this field in database table. It may be possible that you have defined less field length.


I have made a php function to in which mysql query has been used, everything is ok but query is not executed.

You cannot access database connection variable directly in a function.Please check either you used "global  $conn" or
Have used database connection variable as a function parameter.