berbagisolusi
MySQL
PHP Report : iReport (JasperReport) with PHP JavaBridge
NOW! Professional Reporting can embeding in PHP source, that report will be helping Reporting data from Mysql and handle paper size dan page number. iReport will helping design and setting print data. A. AppServer AppServ 2.5.10 Apache 2.2.8 PHP 5.2.6 MySQL 5.0.51b phpMyAdmin-2.10.3 Download Sourceforge.net : http://prdownloads.sourceforge.net/appserv/appserv-win32-2.5.10.exe?download MD5SUM : 279c0c39866fbecb8a3904969fd5d0f4 B. iReport Download from http://sourceforge.net/projects/ireport/files/iReport%20(classic)/ (test using iReport 0.5.0 … Continue reading
connecting MySQL using VB.NET
1. Connector/NET In early 2004 MySQL AB hired Reggie Burnett of ByteFX and acquired his ByteFX .NET data provider for MySQL. The provider was renamed Connector/NET and not only is it provided free under the terms of the GNU Public License, but it is one of the most feature-rich and best performing .NET providers for … Continue reading
MySQL String Function
Table 11.7. String Operators Name Description ASCII() Return numeric value of left-most character BIN() Return a string representation of the argument BIT_LENGTH() Return length of argument in bits CHAR_LENGTH() Return number of characters in argument CHAR() Return the character for each integer passed CHARACTER_LENGTH() A synonym for CHAR_LENGTH() CONCAT_WS() Return concatenate with separator CONCAT() Return concatenated string … Continue reading
MySQL Date and Time Functions (dateformat)
11.7. Date and Time Functions This section describes the functions that can be used to manipulate temporal values. See Section 10.3, “Date and Time Types”, for a description of the range of values each date and time type has and the valid formats in which values may be specified. Table 11.13. Date/Time Functions Name Description ADDDATE() Add time values … Continue reading
Password Function in SQL Server
Like Mysql, SQL Server have any function for password encrypte. In mysql we can see like MD5,PASSWORD,HASH and any other type of function make text encrypte. You can see any example and comparing that function : In a recent SQL Server port of the Actions module for Drupal 5, I ran into the following MySQL … Continue reading
Web Statistic
berbagisolusi 