santhosh_89
-
Posts
4 -
Joined
-
Last visited
santhosh_89's Achievements
Newbie (1/5)
0
Reputation
-
php and postgreSQL database with pictures
santhosh_89 replied to imposhandiknowiam's topic in PostgreSQL
Hello dear, You should have stored the pictures file in a directory,This path will be stored in database,If you want to show the image in interface,you should connect with database, Then fetch that file path,assigned to image tag,Thats all,Now you can see the image, are u expecting this or some other else, -
Hello , I will give a module to connect with database, function database_connect () { # the pg_connect function will connect the database using the user name # and password . $pg=pg_connect("host=192.168.8.20 user=santhosh password=santhosh_89 dbname=santhoshkumar"); # check the connection using the ping function if it fails # return the 0 if (!pg_ping($pg)){ return 0; } # else return the database connection else{ return $pg; } }
-
If your are taking the bank transaction,you would use lock,rollback,commit,.. This will help you lot.
-
Better you can use explain analyse in postgres,It will give the output clearly.