In our earlier article, we have provided the demo with code for UI Data Base using Google spread sheet as back-end to show user interactive HTML form. Whereas in this article, we use CSV file as database and php as link code to get the required data. we are giving the source code. The following is source code for the given demo interactive sheet.
Three files are required for this script. And the three file source codes are given below.
HTML CODE (link.html)
PHP CODE (link.php)", $data[8]);
$output .= sprintf( "Sachin scored total runs: %d ", $data[4]);
$output .= sprintf( "; Against Balls: %d
", $data[3]); $output .= sprintf( "No Of Fours: %d ", $data[5]); $output .= sprintf( "; & Sixs: %d ", $data[6]); $output .= sprintf( "; Position: %s
", $data[7]); } } echo " SACHIN CRICKET SCORES DETAILS
Where data checked with- Venue:$k
"; echo $output; fclose($handle); ?>
CSV File in following format (link.csv)
Three files are required for this script. And the three file source codes are given below.
- HTML File (link.html): This is the simple form where one can enter query to get the required output. You may design whatever manner you like or make stylish look.
- PHP File (link.php) : This is the back-end script to get the data with regards to the input entered in the html form. You may design this php code, if you require in more friendly manner.
- CSV File (link.csv): This is simple csv file (like excel file)where the total data is stored.
HTML CODE (link.html)
PHP CODE (link.php)
", $data[3]); $output .= sprintf( "No Of Fours: %d ", $data[5]); $output .= sprintf( "; & Sixs: %d ", $data[6]); $output .= sprintf( "; Position: %s
", $data[7]); } } echo " SACHIN CRICKET SCORES DETAILS
Where data checked with- Venue:$k
"; echo $output; fclose($handle); ?>
CSV File in following format (link.csv)
Nakshatra | Lord | Yoni | Guna | Presiding Diety |
---|---|---|---|---|
Ashwini | Ketu | Horse | Deva | Ashwini Kumar |
Bhairini | Venus | Elephant | Manushya | Yama |
Krittika | Sun | Goat | Rakshasa | Agni |
Rohini | Moon | Serpent | Manushya | Brahma |
Mrigasira | Mars | Serpent | Deva | Soma |
Ardra | Rahu | Dog | Manushya | Rudra |
PunarVasu | Jupiter | Cat | Deva | Aditi |
Pushya | Saturn | Goat | Deva | Brihaspati |
No comments:
Click Here To add Comment
Post a comment