I used some images in my PHP scripts. I typed the perfect names of images (eg chair.jpg) in my PHP script. Though in my web root directory, the images are stored by the same name, in output, I didn’t find the images.

Later I found that, the image was named like “checked.PNG” in my web root. But in my program, it was “checked.png”.
For having lower case in my code [png] but main image was in upper case [PNG], I didn’t find the image in output screen after loading.

This scenario doesn’t happen always. It varies! I found output the other time though the extension was different [one was in upper case and the other in lower case]

I was working with a form where I need to insert some form variables in my MySQL database. Inserting data into database is not any problematic issue. But as I had to insert dynamic data contained by the form variables, I faced a little problem. The solution is very very simple!

//variables will contain the data stored in the form variable id, hod, status
$soid = $_POST['id']; 
$employeeid = $_POST['hod'];	
$statusto = $_POST['status'];
	
// the is the SQL query to insert into database

$sql = "INSERT INTO `service_order`.`change_log` (`service_order_id`, `employee_id`, `changed_to`) VALUES ('".$soid."', '".$employeeid."', '".$statusto."')";

the most important thing is — putting the dot(.) and double quotation(“) and single quotation(‘) around the variables $soid, $employeeid and $satusto

For not using these three symbols properly, I found errors in my program

I was working with a search module where I needed to work upon the user “date” inputs. The form inputs of dates were string type like “2011-05-06″. I had to confirm few things:
– if both of the input fields [said as $var6 and $var7] are blank or not.
– if first one [$var6] is filled only
– if second date [$var7] is filled only
– user can give two dates in any order. BUT MYSQL ‘BETWEEN’ command [which I used to compare two dates] expects the first argument as early number and second one as big number. so I had to swap two numbers in proper order
here goes some additional needless info,
$var6 = @$_GET['date_1'] ;
$var7 = @$_GET['date_2'] ;
$wh = “WHERE”; //initializing variable
$cond6 = “”; // initializing variable
Read the full post »

I was trying to pull some values from Database using PHP. My DB is MySQL. Suddenly I found the error:

mysql_num_rows() expects parameter 1 to be resource, boolean given in

I was trying to find out the problem. I went through the forum post in Daniweb after googling

Finally I fixed it. What was TROLLING is just a [ ' ' ] sign

My query which was giving error:

$query = "select * from service_order where account_manager_id = $var AND primary_connection_media= $var2";

When I fixed the error by putting ” around the variables, the query is:

$query = "select * from service_order where account_manager_id = '$var' AND primary_connection_media= '$var2'";