Below is the Simple PHP and MYSQL Search Program. Use below database queries: CREATE TABLE IF NOT EXISTS user (id int(10) NOT NULL AUTO_INCREMENT,Name varchar(20) NOT NULL,PRIMARY KEY (id)); INSERT INTO user (id, Name) VALUES (‘1’, ‘vicky’), (‘2’, ‘vivek’); Below is the sample program:
Author: viveik
Get Traffic From Facebook by Using Simple SEO Tricks
Selecting the best URL (Facebook Username) for the Facebook page. Using the “About” text box to place keyword dense prose at the top of the Page. Using the “Info” tab to include more important keywords, text, and high priority links on the Page. Create “Static FBML(Facebook’s mark-up language)” boxes and tabs to place lengthy content […]
Using For Loop Looping through Alphabets letters
Using For Loop Looping through letters is possible for($i = ‘S’; $i != ‘AC’; $i++) {echo $i.’ ‘;} Note: $i <= ‘AC’ it only works with $i != ‘AC’ Output : S T U V W X Y Z AA AB
How to Customize and Edit Your Blogger Template
Blogger is free blog publishing service from Google just like wordpress and the best thing about blogger blogs are the articles gets indexed in the Google search engine very fast and this article is all about customizing the blogger template, I am going to show how to customize blogger template by taking the default blogger […]
Decimal(5,3) in Mysql is always 99.999
The maximum value for decimal(5,3) is 99.999, it means 5 digits with 3 digits after decimal, and whenever you try to insert or update more than 99.999 value it is automatically capped to 9.99 in mysql. This Try decimal(5, 2) Decimal(5,3) is used for financial values or less than 100% values. If you want to […]
How to Validate Emails Using Filters in PHP
Using PHP Filters we can fully validate an email id and this filter option requires PHP 5 version. Below is the code for validating emails in PHP using filters, along with using explode and foreach loop and then inserting the correct emails in the mysql database. Multiple emails validation. Validate Emails Using Filters in PHP
How to Get MySql Query Result as an Email
If you are working on a big mysql query and want to get the mysql query as email when it finishes use the below trick. Go to mysql command:Set pager directive: mysql> pager mail -s “subject” emailme@domain.comPAGER set to ‘mail’ -s “subject” emailme@domain.com The trick uses pager directive to redirect the query output result to […]
How to Create document using VB Script
To create a document using VB script you need a text editor and use the below code. VB script must be ended by using .vbs VB script runs only on Internet Explorer browser. <script type=”text/vbscript”>Set word = CreateObject(“Word.Application”)Set ActiveDocument = word.Documents.Add()ActiveDocument.TypeText “My first document”ActiveDocument.TypeParagraph()ActiveDocument.SaveAs(“c:sample.doc”)</body></script>
How to Set up BonitaSoft BPM with Tomcat and Mysql
Before setting up Bonitqasoft you need following: 1. Latest version of Bonita Open Solution Tomcat and Mysql Bundle.2. Java 1.6 version and set JRE_HOME and set JAVA_HOME system variables.3. Mysql database. Follow below steps to configure BonitaSoft with Tomcat and Mysql : 1. Create two databases named bonita_history and bonita_journal. Commands: Create database bonita_history;Create database bonita_journal; Step 2. Create user […]
Jquery Datepicker UI options and set default date on Load
Below Jquery UI is to select between two dates from and to.To show Default date in Jquery Datepicker UI use defaultDate: “+1d” see below in codeTo set number of months use numberOfMonths: 1To set Default date on Jquery load using Datepicker see in below code*** See code and live example below. From to