student Table (consider this table already in database - school and having the following data) --------------- s_no | name --------------- 1 | Regin 2 | Beschi 3 | Siva 4 | Karthik ----------------
then the code to display data: $con = mysql_connect("localhost","root",""); //local //for server - mysql_connect("hostname/ip","username","password") if($con) mysql_select_db("school",$con); //database name
$sql = "select * from student"; $rsd = mysql_query($sql); $total_students = mysql_num_rows($rsd); //total number of records in student table while($rs = mysql_fetch_array($rsd)) { echo $rs['s_no']." - ".$rs['name']; echo " "; }
Want to know how to change the alert box title in javascript... the answer is: we cant change the title of js alert box.
however, we can use popup boxes, that look like alert boxes with custom title.... but there is a chance - some browsers will block that. Or we can use vbscript msgBox, but cant get the result in FF. Or we can use custom designs like this: http://www.acejs.com/scriptsfolder/121015/121015.html
BUT it is not working like exactly as a alert box. (following codes will get executed though we dont click the ok button)
My opinion: Its better not to use any other custom alert boxes.
Projects using login may have the problem of expiring sessions in short time. How to increase the session timeout in PHP?
use this as first line - before session_start ini_set('session.cookie_lifetime',(3600*2));
In some servers it may not work.... BUT using .htaccess file it is working very fine. Just place these lines in the .htaccess file and put the file in your root directory. php_value session.cookie_lifetime 3600 php_value session.gc_maxlifetime 3600
and note these parameters are in seconds. Then how to check the current session timeout? use this: printf("cookie: %s, gc: %s", ini_get('session.cookie_lifetime'), ini_get('session.gc_maxlifetime'));
How to play mp3 files in a web page - as streaming using some players available for free?...
First, lets try with windows media player. Try this code... <object id="MediaPlayer" height=46 classid="CLSID:22D6f312-B0F6-11D0-94AB-0080C74C7E95" standby="Loading Windows Media Player components..." type="application/x-oleobject" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,7,1112"> <param name="filename" value="Bheema1.mp3"> <param name="Showcontrols" value="True"> <param name="autoStart" value="True"> <embed type="application/x-mplayer2" src="http://www.mix26.com/demo/Bheema1.mp3" name="MediaPlayer"></embed> </object>
will Show this media player:
This one is from google... Google audio player. <embed type="application/x-shockwave-flash" src="http://www.google.com/reader/ui/3247397568-audio-player.swf?audioUrl=http://www.mix26.com/demo/om_zaraare.mp3" width="400" height="27" allowscriptaccess="never" quality="best" bgcolor="#ffffff" wmode="window" flashvars="playerMode=embedded" />
will Show:
This is from yahoo... <embed src='http://webjay.org/flash/dark_player' width='400' height='40' wmode='transparent' flashVars='playlist_url=http://www.mix26.com/demo/marudhaani.mp3&rounded_corner=1&skin_color_1=0,0,0,0&skin_color_2=0,0,0,0' type='application/x-shockwave-flash' pluginspage='http://www.adobe.com/go/getflashplayer'/>
will Show:
And this one is very cute... Add just a line (javascript) in your page and get the player...
To generate random no.s we can use rand() function... try, echo ran() ; //will generate random no between 0 and32768 echo rand(5,200); //a random no between 5 and 200 To generate alpha numeric random no - uniqid()... try, echo uniqid(rand(), true); you can get a number like: 274134886dbd37292e8.16885304 (32 digit)
To generate alpha numeric passwords for user accounts use this: $password = substr (MD5(uniqid(rand(),1)), 3, 10); //10 digit random alpha numeric password
if you use any doctype in our page, then some unwanted padding/margin will appear with images / tables / td s will be added automatically in your page....
You want to remove them...? Then add this css code in to your page
Some may have this problem. Always the flash object looks like placed in front of all the objects. So if we want to put a div in front of flash/ over flash we cant.
But there s a solution... The normal flash object.... <object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="519" height="255"> <param name="movie" value="center_flash.swf"> <param name="quality" value="High"> <embed src="center_flash.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="519" height="255" quality="High"> </object>
To make it back of all elemnts add <param name="wmode" value="transparent">
So the actual code we want is... <object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" id="obj1" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" border="0" width="519" height="255"> <param name="movie" value="center_flash.swf"> <param name="quality" value="High"> <param name="wmode" value="transparent"> <embed src="center_flash.swf" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj1" width="519" height="255" quality="High"> </object>
<html> <head> <meta http-equiv="Content-Language" content="en-us"> <title>Check Test</title> <script language="javascript"> function valBox() { var x = document.chkForm; var i, flg = 0;
The following code can be used to convert the number format into indian currency format (Indian rupees, INR) using PHP.
<?php ob_start(); //Currency format conversion - Indian Rupee $n = "1000000"; $len = strlen($n); //lenght of the no $num = substr($n,$len-3,3); //get the last 3 digits $n = $n/1000; //omit the last 3 digits already stored in $num while($n > 0) //loop the process - further get digits 2 by 2 { $len = strlen($n); $num = substr($n,$len-2,2).",".$num; $n = round($n/100); } echo "Rs.".$num; ?>
We can find the no days between two dates using PHP.... There are 2 methods:
1) Split the date and subtract $date1 = "2008-05-18"; $arr = explode('-',$date1); //split the date $date2 = $arr[2]; //stores 18 $cur_date = date("d"); // current date echo "Difference: "; echo $cur_date-$date2;
2) Convert dates into timestamp, subtract and then convert as we want $date1 = "2008-04-18"; $to_day = date("Y-m-d"); //current date $day_diff = (strtotime($to_day)-strtotime($date1))/86400; //60*60*24=86400 echo $day_diff;
//change the divider(864000 to get ur corresponding difference $hour_difference = (strtotime($to_day)-strtotime($date1))/3600; //60*60=3600 $week_diff = (strtotime($to_day)-strtotime($date1))/604800; //60*60*24*7=604800
<script type="text/javascript"> function check_boxes() { for (i=0; i<document.test.checkgroup.length; i++){ if (document.test.checkgroup[i].checked==true) alert("Checkbox at index "+i+" is checked!") } } </script>
<? session_start(); ob_start(); echo '1 '.date("d-m-Y H:i:s"); // Default server time zone
putenv("TZ=Asia/Calcutta"); //change your server time zone - this one is for India - works in PHP 4 // also you can try: date_default_timezone_set('Asia/Shanghai'); - since PHP 5.1.0
1. Speed. There is a difference between the two, but speed-wise it should be irrelevant which one you use. echo is marginally faster since it doesn't set a return value if you really want to get down to the nitty gritty.
2. Expression. print() behaves like a function in that you can do: $ret = print "Hello World"; And $ret will be 1. That means that print can be used as part of a more complex expression where echo cannot. An example from the PHP Manual:
$b ? print "true" : print "false";
print is also part of the precedence table which it needs to be if it is to be used within a complex expression. It is just about at the bottom of the precedence list though. Only "," AND, OR and XOR are lower.
3. Parameter(s). The grammar is: echo expression [, expression[, expression] ... ] But echo ( expression, expression ) is not valid. This would be valid: echo ("howdy"),("partner"); the same as: echo "howdy","partner"; (Putting the brackets in that simple example serves no purpose since there is no operator precedence issue with a single term like that.)
So, echo without parentheses can take multiple parameters, which get concatenated:
echo "and a ", 1, 2, 3; // comma-separated without parentheses echo ("and a 123"); // just one parameter with parentheses
To send HTML mail in php use the following code... $to = 'some@example.com'; $subject = Testing Html Mail; $message = ' // HTML code here '; // To send HTML mail, the Content-type header must be set $headers = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; // Additional headers $headers .= 'To: Somebody ,' . "\r\n"; $headers .= 'From: Me ' . "\r\n"; // Mail it mail($to, $subject, $message, $headers);