RE: [PHP-DB] Php-MySQL general function for insert, update,delete, count query

I wrote this one and use it in a lot of places <? //conn.php //check if a current session is in place and the user is correctly logged in //also check the calling page / domain to ensure the call only comes from //this domain -- this check may take a little configuration to get the //correct host name //echo "server is : ".$_SERVER['SERVER_NAME']; //use this the first time to get the host name...then comment it out or delete to complete the security check //if (($_SERVER['SERVER_NAME']!="www.fishinweather.com")){ if (($_SERVER['SERVER_NAME']!="localhost")){ echo "piss off, hackers!"; die(); } function connect($sql) { $username = "*****"; $pwd = "****"; $host = "localhost"; $dbname = "test"; /* $username = "fishinwe_alton"; $pwd = "cooperaz"; $host = "localhost"; $dbname = "fishinwe_fishinweather"; */ if (!($conn=mysql_connect($host, $username, $pwd))) { printf("error connecting to DB. "); exit; } $db=mysql_select_db($dbname,$conn) or die("Unable to connect to database1".mysql_error()); $result = mysql_query($sql, $conn); if (!$result){ echo "database query failed: ". mysql_error(); }else{ return $result; }//end if }//end function ?> bastien

From: "Rasim ÞEN" <rasimsen@hotmail.com> Reply-To: "Rasim ÞEN" <rasimsen@hotmail.com> To: php-db@lists.php.net Subject: [PHP-DB] Php-MySQL general function for insert, update,delete, count query Date: Sat, 25 Jun 2005 17:52:31 +0300 Hi friends, I am using one perfect function for my queries for PHP+Oracle pages, this is below ========================== function sorgu($sql) { global $baglanti;

        $stmt=ociparse($baglanti,$sql);
        $sonuc=ociexecute($stmt,OCI_DEFAULT);

        $erra=OCIError();
        $e=$erra['message'];

        $sorgutipi=ocistatementtype($stmt);
        $kayit_dizi=array();
        $kayit_sayisi=-1;
        if($sonuc)
        {
                if($sorgutipi=="SELECT")
                {
                        $kayit_sayisi =

OCIFetchStatement($stmt,$kayit_dizi,0,-1,OCI_FETCHSTATEMENT_BY_ROW);

                }
                else
                {
                        $kayit_sayisi = ocirowcount($stmt);
                }
        }
        return array($sonuc,$kayit_sayisi,$kayit_dizi);

} ============================== I am using it for every kind of oracle db query. So my all queries under my control. Now I am looking for one function with PHP+MySQL Anybody know like short function as above php+oracle function? I am using some function sets they are using much database queries. I want to use min. query and connection. Thanks alot. Rasim rasimsen@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php