Codez Blog

Today we will learn a few interesting things about SQL Query Optimization.
How to get query execution time and executed query number?
Follow the code given below:
function timer()
{
$time = explode(‘ ‘, microtime());
return $time[0]+$time[1];
}
$beginning = timer();
$timer_queries += round(timer()-$beginning,6);

The sql query becomes faster if you use the actual columns names in SELECT statement instead of than ‘*’.
For Example: Write [...]

To create a pie chart, use the following code:
<script type=”text/javascript” src=”https://www.google.com/jsapi”></script>
<script type=”text/javascript”>
google.load(‘visualization’, ‘1.0′, {‘packages’:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
var data = new google.visualization.DataTable();
data.addColumn(’string’, ‘Topping’);
data.addColumn(‘number’, ‘Slices’);
data.addRows([
['Correct Answer', <?php echo $correct_answer_chart; ?>],
['Incorrect Answer', <?php echo $incorrect_answer_chart; ?>],
['Pending Ansewr', <?php echo $pending_answer_chart; ?>],
['Skiped Ansewr', <?php echo $skiped_answer_chart; ?>]
]);
var options = {‘title’:’Result’,
‘width’:600,
‘height’:300,
colors: ['#00CD00', '#e0440e', '#e5e599', '#cccccc']
};
var chart = new google.visualization.PieChart(document.getElementById(‘chart_div’));
chart.draw(data, options);
}
</script>
The above [...]

About CKEditor : CKEditor is a text editor to be used inside web pages.By CKEditor we can change font style,font color and other features found on desktop editing applications like Microsoft Word.By CKEditor we can also upload images but it is touhg if we only use CKEditor.Therefore we need to know about [...]

Currently I am working in PHP thumbnail generator, which basically creates thumbnail image of original image and store it in a particular folder. This functionality is very useful because some time we need to show thumbnail image to the user. Every time when we upload image we don’t want to try the actual height, width [...]

This is a PowerPoint presentation regarding the structure and functionality of SQL. To know about the SQL in detail please click on the link below and download the ppt.
http://blog.codez.in/post-files/SQL.pptx

###1:
This week I will show you how to generate dynamic <li> under <ul> contains country and when the < li> will selected a dynamic class generate:
<?php
ini_set(‘display_errors’,1);
[...]

There is a advantage in Ajax form validation, because the validation is completed without page reloading.I also learnt how to retrieve the multiple checkbox values in which input names are the same.It was very interesting for me to create a table of two column which displayed the from database. The code is very simple.