What is SQL syntax? The SQL syntax is quite an easy one to grasp. Most of the actions you need to perform are done with a SQL statement. SQL is followed by unique set of rules and guidelines called Syntax. This tutorial gives you a quick start with SQL by listing all the basic SQL Syntax. Keep in Mind That …
Continue ReadingWhat is RDBMS? RDBMS stands for Relational Database Management System. RDBMS data is structured in database tables, fields and records. Each RDBMS table consists of database table rows. Each database table row consists of one or more database table fields. RDBMS store the data into collection of tables, which might be related by common fields (database table columns). RDBMS also …
Continue ReadingWhat is SQL? SQL pronounced “ess-que-el”(stands for Structured Query Language) or SQL is pronounced as “S-Q-L” or “see-quill”. SQL is an ANSI and ISO standard, and is the de facto standard database query language. A variety of established database products support SQL. SQL is used to communicate with a database. SQL defines many keywords, which can be divided into several …
Continue ReadingAbout SQL tutorial My SQL Tutorial free is educational blog which will teach you how to program and use SQL. My sql tutorial explains the most important SQL clauses, keywords and functions, as well as general SQL and relational database management systems concepts. I will explain introduction to SQL language and RDBMS (Relational Database Management Systems). How to use SQL …
Continue ReadingCan not work Cancel button in Jquery fancybox parent.jQuery.fancybox.close() is a function add to Onclick. Hope it will work. <input type=button name=”cancel” value=”Cancel” onClick=”parent.jQuery.fancybox.close()”>
Continue ReadingFunction ereg_replace() is deprecated : Example : print $input.”<hr>”.ereg_replace(‘/&/’, ‘:::’, $input); Replace print $input.”<hr>”.preg_replace(‘/&/’, ‘:::’, $input); Another example : $anwar = ereg_replace(‘^A-Za-z0-9_’, ”, $ anwar ); Replace to $ anwar = preg_replace(‘/^A-Za-z0-9_/’, ”, $ anwar );
Continue ReadingHow to remove header line in TCPDF Use the SetPrintHeader(false) and SetPrintFooter(false) methods before calling AddPage(). Like this: $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, ‘LETTER’, true, ‘UTF-8’, false); $pdf->SetPrintHeader(false); $pdf->SetPrintFooter(false); $pdf->AddPage();
Continue ReadingHow to minus in array php code $A = array(5,10,10); $B = array(1,1,1); $a=array(); for($i=0; $i<=2; $i++){ $a$i= $A$i- $B$i; echo”<br>”.$a$i; } Output: 4 9 9
Continue ReadingIncoming and Outgoing Mail Server Settings for Hotmail, Yahoo! Mail, GMail, MSN, AOL and more AOL: IMAP: imap.aol.com Port 143 SMTP: smtp.aol.com SSL: NO ATT World Net: POP3: ipostoffice.worldnet.att.net Port 995 SMTP: imailhost.worldnet.att.net Port 465 SSL REQUIRED for Incoming and Outgoing Cox: NOTE: With Cox you can only use their SMTP servers while on their network. Central POP3: pop.central.cox.net SMTP: …
Continue ReadingCharacters Character Description Example Any character except \^$.|?*+() All characters except the listed special characters match a single instance of themselves. { and } are literal characters, unless they’re part of a valid regular expression token (e.g. the {n} quantifier). a matches a \ (backslash) followed by any of \^$.|?*+(){} A backslash escapes special characters to suppress their special meaning. …
Continue Reading