php skills: November 2012

Wednesday, 21 November 2012

Create Stored Procedure With Php Mysql

Here we will discus, how to use procedure with mysql and php.

Procedure is so much beneficial for long join query, it will save the time when you load your page.procedures are same as functions .

=>firstly we Create simple stored procedure into our database

create PROCEDURE testProc()
begin
select field1 from table;
end ;

=>Now we can use the testProc procedure into our php code

<?php $rs=mysql_query('call testProc()'); ?>

Note:Remeber one thing that after using procedure your database connection will automatically closed.

=>Now we will create parameterize procedure into our database

CREATE PROCEDURE get_users(IN var1 INT,OUT var2 VARCHAR(100),OUT var3 VARCHAR(100))
BEGIN
SELECT first_name, last_name
INTO var2, var3
FROM users
WHERE users_id = var1;
END

=>Now we can use the get_users procedure into our php code
<?php
$rs = mysql_query( ‘CALL get_user(1, @first, @last)’ );
$rs = mysql_query( ‘SELECT @first, @last’ );
while($row = mysql_fetch_assoc($rs))
{
var_dump($row);
}

?>

Note: Customize this code according to your requirement

Tuesday, 20 November 2012

How to call ajax with javascript

How to call ajax with javascript
   its so simple just call javascript function onclick or onchange or onblur or onhover,
   on which event you want to call the function its depend on you.

create callajax.php

<html>
<head>

<script>

function callajax()
{
stateval=document.getElementById('state').value;
if(Window.XMLHTTP)
{
xmlhttp=new ActiveXObject('Microsoft.XMLHTTP');
}
else
{
xmlhttp=new XMLHttpRequest();
}
xmlhttp.onreadystatechange=function(){
if(xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('citytd').innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open('GET','ajax.php?state_id='+stateval,true);
xmlhttp.send()
}
</script>
</head>
<body>
<table>
<tr>
<td>name</td><td><select name="state" id="state" onchange="callajax()">
<option>select state</option>
<option value="1" >Alaska</option>
<option value="2" >Alabama</option>
<option value="3" >California</option>
<option value="4" >Florida</option>
</select>
</td></tr>
<tr> <td>address</td><td id="citytd"><select name="city" id="city"><option>Select City from here</option></select></td>
</tr>

</table>

</body>
</html>

Now below code is ajax.php, where you will execute your code and display on call ajax.php

ajax.php



<select><option>apol</option><option>ajax</option></select>

Note: You can customize your code according to your requirement