Hi,
No need to use the database connectivity code in every functions. Connect one time and send that connect object through function parameter.
Use the db connectivity code in a separate file. Whenever you want, you can just include once that connectivity file in the top of the file and then send the connect variable/object to function parameter.
Example:
db_connect.php:
$hostname = "host";
$username = "user";
$password = "pwd";
$dbname = "dbname";
$connect = mysql_connect($hostname, $username, $password) or die("Could not connect MySQL server...");
mysql_select_db($dbname, $connect) or die("Could not select Database...");
You can use require_once("db_connect.php"); in your php file where you need the database connectivity. In that file, you call that common functions and send that $connect variable to function parameter.
If you don't get the above idea, please inform me. I will try to give you better solution.
Thanks.
Regards
Udayakumar Sarangapani
Sr. PHP Developer
CompIndia Infotech Pvt. Ltd.
Chennai.
----- Original Message ----
From: Vijaya Lakshmi <nanna_vijayalaxmi_vsp@xxxxxxxxxxx>
To: php <php-objects@xxxxxxxxxxxxxxx>
Sent: Wednesday, 26 December, 2007 2:20:23 PM
Subject: Regarding functions in php
Hi All ,
I need small help regarding functions.I wrote a code for retrieving values from database using functions.We are having nearly 20 functions in our application. But when I called each function,I have given connection details as a parameter or mentioned in the each function .So that loading time of the page is so long i.e. the page is displaying nearly 5-6 minutes.But I have to display the page with 5-6 secs.
Here is sample application what i was written
Samplefun.php:
<?php
$db->connect( "localhost" ,"root"," ","vijaya" );
include('Functions. php');
$url="www.scienceda ily.com";
$rating=Getrating( $url);
echo $rating; echo"<br/>";
$assignedval= GetAssignedvalue ($url,$rating) ;
echo $assignedval;
?>
Functions.php:
<?php
function Getrating($url)
{
$db = new mysqli();
$db->connect( "localhost" ,"root"," vijaya"," vijaya");
$stmt=$db->prepare( "call rating('$url' )") ;
// mysqli_stmt_ bind_param( $stmt, "s", $url);
mysqli_stmt_ execute($ stmt);
$result=$stmt- >bind_result( $rating);
mysqli_stmt_ fetch($stmt) ;
$stmt->close( );
return $rating;
}
function GetAssignedvalue( $url,$rating)
{
$stmt1=$db-> prepare( "call Get_Assigned_ value('$url' ,$rating) ") ;
//mysqli_stmt_ bind_param( $stmt1, "sd", $url,$district) ;
// mysqli_stmt_ bind_param( $stmt1, "d", $district);
mysqli_stmt_ execute($ stmt1);
$result=$stmt1- >bind_result( $values);
mysqli_stmt_ bind_result( $stmt1, $values);
mysqli_stmt_ fetch($stmt1) ;
//echo"<br/> ";
//echo $values;
$stmt1->close( );
return $values;
}
?>
IF we wrote code like above we got following exeception:
[Wed Dec 26 14:09:45 2007] [error] [client 127.0.0.1] PHP Notice: Undefined variable: db in F:\\Softwares\ \php\\htdocs\ \samples\ \function_ 26.php on line 5
[Wed Dec 26 14:09:45 2007] [error] [client 127.0.0.1] PHP Fatal error: Call to a member function connect() on a non-object in F:\\Softwares\ \php\\htdocs\ \samples\ \function_ 26.php on line 5
[Wed Dec 26 14:13:51 2007] [error] [client 127.0.0.1] PHP Notice: Undefined variable: db in F:\\Softwares\ \php\\htdocs\ \samples\ \function_ 26.php on line 21
[Wed Dec 26 14:13:51 2007] [error] [client 127.0.0.1] PHP Fatal error: Call to a member function prepare() on a non-object in F:\\Softwares\ \php\\htdocs\ \samples\ \function_ 26.php on line 21
Please help us regarding error problem
------------ --------- --------- ---
Why delete messages? Unlimited storage is just a click away.
[Non-text portions of this message have been removed]
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
Chat on a cool, new interface. No download required. Go to http://in.messenger.yahoo.com/webmessengerpromo.php
[Non-text portions of this message have been removed]
