Skip to main content

Posts

Showing posts from November, 2013

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!