Re: Regarding functions in php

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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_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]
 
 
     
                               

       
---------------------------------
 Chat on a cool, new interface. No download required. Click here.

[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux