|
My hosting provider told me I was using too much memory (the CPU usage and bandwidth are ok though) with my .php pages. I have a client app making HTTP requests to the PHP pages which in turn query a MySQL database.
The rough structure of the PHP page is as shown below:
===
global $db_conn;
$db_conn = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD)
or die(db_err('Unable to connect to database server'));
db_select_db(DB_NAME)
or die(db_err('Unable to select database'));
// DB queries, etc.
// ...
===
From reading the docs for mysql_connect() it would appear the connection should be closed automatically when the script finishes.
Do I need to add an explicit close? I was thinking of adding the below:
mysql_close($db_conn);
$db_conn = NULL;
Should the above do the trick? Is there something else I need to do?
Thanks 
|
|
|
|
|
Your high memory usage is probably coused by bad queries or bad database design which couses the MySQL server to do more work.
I am almost 100% sure that the problem is not in the MySql_Connect().
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi everyone
I am trying to launch an application in the client's machine, here is what I did using ActiveX and Javascript (Only works for IE)
Does anyone know a way to do it without ActiveX so that it would work in other browser.
Thank you very much
Victor
|
|
|
|
|
You can't do that without ActiveX. Maybe with Java.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi,
I would like to allow my registered users to create their own personal page(s) that they can style and use as they like. Their webpage would be www.mysite.com/johnFrank where johnFrank would be the user and his/her webpage. The only example I could think of that would be similar would be myspace. The only part that would be like myspace would be allowing the user to have their own webpage.
here are some other examples: http://www.authorsden.com/judyakennedy, http://www.fanstory.com/selectprofi...p?userid=146629
thanks,
john
|
|
|
|
|
Hey Mate,
Well look the only logical way i could see you doing this:
Use PHP to customise the page dependent on the users custom settings (not in actually coding)
Call database "customisation"
Get user "johnFrank"
Get column "box1"
If box1= latest news then
call latest "news.xml"
parse
etc.
Also allow users to make their our custom css sheets (help them out with a wizard)
If your site supports PHP then why not set a cookie that customises your home page (http://www.mysit.com/) to their current user settings. 3 secs extra load but it will make your site even more interactive and usefull.
Sorry for the lack of actuall script but i'm on borrowed time as is.
From Brad
|
|
|
|
|
I want to clear the contents of a specific session variables in ASP. Can anyone suggest me how to go about in doing this? It is very urgent.
Thanks,
Riz
|
|
|
|
|
Session["variablename"]=null;
Navi
|
|
|
|
|
What exactly do you mean by "to clear" in this case?
To clear a string, you can replace it by string.Empty or null. To clear a numeric value, you can replace it by a zero value.
If you want to remove the key from the session variables collection, use the Session.Remove method.
---
b { font-weight: normal; }
|
|
|
|
|
hi! i want to browse client's computer in java script. actually i want a directory browser to browse client browser.
sam
|
|
|
|
|
Do you want to browse the clients hard disk. If it is so then I don't think so it is possible.
Best Regards,
Apurva Kaushal
|
|
|
|
|
You are correct. You can't access client's hard drive.
--------------------------------------------------------
My portfolio & development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi,
I want to print a webpage directly with out Print dialog box.
Is it possible, Pls Help me. Any Javascript function for it other than window.print().
By Binu Varghese
|
|
|
|
|
|
thanks
But I didn't get the solution for my problem. I want to print webpages at clientside with out prompting Print dialogbox. I can print the web form using window.print(). when i using this , it will populate a Print dialogBox. I want to avoid this and print directly.
Pls Help once again
|
|
|
|
|
Hello!
I have a major problem and I hope you can help me.
I have a multipart/form-data where I am browsing a picture file and then submitting it to upload.asp file. My animated progress bar is not getting displayed in upload.asp file because server is trying to complete the asp codes first and then it is displaying the html content.
How can I show an animated image or a text message in the upload.asp file during uploading process?
Thank You!
Bedri.
|
|
|
|
|
Hello
I think what you need is to flush the response object, using Response.Flush() after adding the animated stuff. This will output the html to the browser, while you can continue to do more processing on the server side.
Kind Regards,
John Petersen
|
|
|
|
|
Thank you very much John. It worked out!... thanks..
|
|
|
|
|
Hello,
How do you test if the web service is available? Is this simply doing a
try {...} catch(System.Net.WebException) {...)
in every block of code where I try to access the web service?
Thank you for your help,
~Rafferty
|
|
|
|
|
Hi,
Do you want to test whether the webservice is available or to know whether the available webservice is running??
When you want to test whether the avilable webservice is running:
1) It will throw a runtime exception as soon as you instantiate the Websevice in your implementation page.
When you want to test whether the webservice is available:
1) It will not allow to connect to the particular URL if it is not avaialbel from the WebReference dialog box.
Regards
Mohan
|
|
|
|
|
hello guys.
i want to test my web application (it's search and the stringth of the server)
so anyone know a good book or site to learn from; how to attach server or search engine..etc
Faris Madi
Nothing Comes Easy (N.C.E.)
|
|
|
|
|
Hi guys,
I would like to inquire how to get the webpage/url address in real time from the back button. As we can see, when we push (down) pull down button in the back button, we can view the previous webpage visited. Is there a way to retrieve the url address in the back button without clicking on a link or a button using javascript?
your help would really be much appreciated.
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif) Christina
|
|
|
|
|
The window.history property is an array of URL strings which reflect the entries in the History object
the previous property contains the complete URL of the previous element in the History list, and is the equivalent of the URL the user would go to if they selected Back in the Go menu.
Syntax: history.previous
Navi
|
|
|
|
|
Hi,
I am a software engineer...and i am very new too.Many of friends have their website for blogs.
I have the wish to create one website for me..How should id do?
I will make it by using HTML.
But i need the things where i register my website?
Cost of registration?Or any free webhosting?
I need the details of this and procedures to create the website also.Pls anybody help me..
-- modified at 8:38 Monday 28th August, 2006
Anu
|
|
|
|
|
If you are looking for a blog, wordpress, blogger etc... are there at your disposal and for using blogs, you are not needed to be an expert in the web technologies.
-Sarath.
The more you can dream the more you can do - Michael Korda"
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
