function get_enum($table,$clname){
$Query="SHOW COLUMNS FROM `$table` LIKE '$clname'";
$result = $this->db->query($Query) or die("Get Enum value Query");
if($result){
$row = mysql_fetch_array( $result , MYSQL_NUM );
$regex = "/'(.*?)'/";
preg_match_all( $regex , $row[1], $enum_array );
$enum_fields = $enum_array[1];
return $enum_fields;
}
return false;
}
Html, JAVA,DOTNET,Javascript, PHP, and JQuery Scripts and its issues with solutions
Tuesday, 24 June 2014
How to get Enum Values in Mysql?
Saturday, 21 June 2014
Generate Password in alphanumeric using PHP
$chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
$password = substr( str_shuffle( $chars ), 0, $length );
Friday, 20 June 2014
Dynamically Date Range reset in jQuery UI date picker
Removes the datepicker functionality completely. This will return the element back to its pre-init state. Code : $( "#start_date" ).datepicker( "destroy" ); $( "#end_date" ).datepicker( "destroy" );
Subscribe to:
Comments (Atom)
Feet/Inches to Meters Converter & Lbs to Kgs Converter
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" /> <title>Feet/Inches ⇄...
-
<?php $to = "somebody@example.com, somebodyelse@example.com"; $subject = "HTML email"; $message = " <h...
-
document.onkeydown = myKeyDownHandler; function myKeyDownHandler(event){ alert(event.keyCode) }
-
<?php $date1 = "2015-01-23 00:20"; $date2 = "2015-01-23 05:30"; $seconds = strtotime($date2) - strtotime($date1);...