This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.

12345

Monday, 17 September 2012

csv export and import script using php

03:25  softe9gineer  No comments

Code bellow will be helpfull for you for importing and exporting csv files. Copy the code bellow and save it as "import_export_csv.php" then open it in your host e.g. 'localhost' and start importing, exporting csv files. <?php //don't forget to include your database connectivity.  include('db_connection.php');  if ($REQUEST_METHOD=="POST"...

Read More

using google map lookup address by postal code

01:24  softe9gineer  No comments

           <?php     // First, we need to take their postcode and get the lat/lng pair:     $postcode = 'SL1 2PH';     // Sanitize their postcode:     $search_code = urlencode($postcode);     $url = 'http://maps.googleapis.com/maps/api/geocode/json?address='...

Read More

Monday, 14 May 2012

How to write a php script for file downloading

11:57  softe9gineer  No comments

In this tutorials you will learn how to write a php script for file downloading.If you want to see how to upload a file into a server click here. <?php  // Give the path here where your file is located and make a hyper link like <a href='www.yoursite.com?fname=youpic.jpg'>Download image</a>//$_GET['fname']; will...

Read More

Wednesday, 9 May 2012

Upload image into folder and save its name into database

12:07  softe9gineer  17 comments

This tutorial tell you how to Upload image into folder and save its name into database. You should follow these two steps: Creat a database named 'olympic' and a table named 'acc_images'. CREATE TABLE IF NOT EXISTS `acc_images` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `acc_id` int(11) unsigned NOT NULL, `image` varchar(255) NOT NULL, `status`...

Read More

Tuesday, 8 May 2012

Create a comma separated csv from sql query

09:18  softe9gineer  No comments

<?php $select = "SELECT * FROM Your_table"; $export = mysql_query ( $select ) or die ( "Sql error : " . mysql_error( ) ); $fields = mysql_num_fields ( $export ); for ( $i = 0; $i < $fields; $i++ ) {     $header .= '"'.mysql_field_name( $export , $i ).'"';  if($i != $fields-1)  $header .= ","; } while( $row = mysql_fetch_row(...

Read More

Sunday, 6 May 2012

Make a Sign in form and store data in session

13:17  softe9gineer  No comments

This tutorial tell you how to match username and password entered by user with stored records in database. Then store username in session variable. You can see sing up form here You should follow these two points: Creat a database named 'olympic' and a table named 'user'. CREATE TABLE IF NOT EXISTS `user` ( `username` varchar(255) NOT NULL, `email`...

Read More

How to save form data in database and send activation key

12:18  softe9gineer  No comments

In this tutorial you will learn how to save signup form data in database and send activation key to user's email. I am not including validation code here if you want to validate your form submission code click here to see. For looking the sign in form click here You should follow these two points: Creat a database named 'olympic' and a table named...

Read More

Sunday, 15 April 2012

PHP Validation for complete SignUp form

04:58  softe9gineer  2 comments

For PHP validation I am using the same regular expression rules as I have used and described in detail during java script validation for complete signup form. Below is complete PHP validation code. Copy and paste it in your text editor and save it with PHP extension (e.g. validation.php). Then open it in localhost server you will see it working well....

Read More

Wednesday, 28 March 2012

how to update value using join between two tables in mysql

09:56  softe9gineer  No comments

This example may be help full for you. UPDATE xcart_products INNER JOIN xcart_extra_field_valuesON xcart_extra_field_values.productid = xcart_products.productidSET xcart_products.forsale = 'N' WHERE xcart_extra_field_values.value = 'article' and xcart_extra_field_values.fieldid=1...

Read More

Thursday, 1 March 2012

Complete code with html sign up form and validation:

14:04  softe9gineer  2 comments

Copy and past given code in notepad and save it with .html for demo. Click here for detail  <head> <script type="text/javascript"> function validation_for_signup() {                ...

Read More

Javascript Validation for complete SignUp form

13:46  softe9gineer  No comments

  Using client side JavaScript validation is an efficient way to validate the user input in web forms. Form validation is the process of checking that a form has...

Read More