Hi You have follow PHP design pattern, so just make a new file with your db connection using global variable than use the global variable inside function to get the mysql results Thanks, Muthukumar Selvarasu, Project Manager (Web Development), Webmasters Ltd. _____ From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Vijaya Lakshmi Sent: Wednesday, December 26, 2007 11:34 PM To: php-objects@xxxxxxxxxxxxxxx Subject: Re: Regarding functions in php Hi, thank you very much for your message.I tried sample application by using your suggestions.but got following error message [Wed Dec 26 17:01:24 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\\samplefun_26.php on line 10 Once check it out sample application which was posted .Give us a sample application by usin stored procedures in functions Udaya kumar <udayakumaar@ <mailto:udayakumaar%40yahoo.com> yahoo.com> wrote: 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_ <mailto:nanna_vijayalaxmi_vsp%40yahoo.co.in> vsp@xxxxxxxxxxx> To: php <php-objects@ <mailto:php-objects%40yahoogroups.com> yahoogroups.com> 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;paddin g-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 <http://in.messenger.yahoo.com/webmessengerpromo.php> yahoo.com/webmessengerpromo.php [Non-text portions of this message have been removed] --------------------------------- Get the freedom to save as many mails as you wish. Click here to know how. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
