MY NODE: Sri Lanka District and City List Sql File
MY NODE: Sri Lanka District and City List Sql File : For a recent project I had to find all the Sri Lankan District and related Cities to populate in two drop downs. The list is not fully compl...
Posts
STORE & RETRIEVE ARRAY ELEMENTS IN MYSQL USING PHP
<?php $link = mysqli_connect("localhost", "my_user", "my_password", "test"); /* check connection */ if (!$link) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } /* set autocommit to off */ mysqli_autocommit($link, FALSE); mysqli_query($link, "CREATE TABLE Language LIKE CountryLanguage"); /* Insert some values */ mysqli_query($link, "INSERT INTO Language VALUES ('DEU', 'Bavarian', 'F', 11.2)"); mysqli_query($link, "INSERT INTO Language VALUES ('DEU', 'Swabian', 'F', 9.4)"); /* commit transaction */ if (!mysqli_commit($link)) { print("Transaction commit failed\n"); exit(); } /* close connection */ mysqli_close($link); ?>
INSERT `BLOB` IMAGES ON YOUR MYSQL DATABASE USING PHP
Code Samples : 1. Create the database and tables 2. index.php 3. showImage.php
RED DROPS' - THE BLOOD BANK
Red Drop is a great on going project of University of Jaffna Team. It pitch on the E-Ground and get lots of fans. An on time solution for need of blood in an emergency time for Sri Lanka. Carry the blood donors by LBS(Location Based System) mobile technology and find them through USSD application. Volunteers who is matched with the details of the needed blood group, System sendan immediate message to their mobiles and protect a person from the critical situation. This idea was pitched on the E-ground at "Yarl IT Hub" and won 2nd Place. Last time this project was pitched and implement to participate in the SLIIT CODEFEST and got a place in TOP 8 finalist in Sri Lanka. Now the world waiting for the NEW INNOVATION OF RED DROPS!