|
I use PHP5/MYSQL5
------------------
I need you to help, i have a serious problem when i look up records from database number of 18939 records in ComboBox ({value}). My webpages open so slow maybe 2 minutes or more,
How can i make it faster than when there are many record like this.
Please help me now.
Thank you in advanced.
Hy Chanhan
|
|
|
|
|
You need to filter your recordset to include less results. Nobody, will look at a Combobox with 18000 items in it!
Maybe you can use several comboboxes to categorize the results, so the last combobox will have just a few items.
Example:
combobox 1: States
combobox 2: Counties
combobox 3: Towns
combobox 4: Cool Places
Do you get my meaning?
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
In ASP you can use an application variable to cache the result of a database query. Then when a page loads you grab the variable instead of hitting the database, speeding things up and using less resources at the same time. PHP most likely has something similar. A search on google for "php application variable" resulted:
http://www.leosingleton.com/projects/code/phpapp/[^]
|
|
|
|
|
Hello,
I am having a little problem with my function to encrypt the query strings....
<br />
Function encryptMenu(HTMLstring)<br />
<br />
Dim objRegExp : Set objRegExp = New RegExp<br />
Dim expressionMatch, expressionMatched, strTemp<br />
<br />
With objRegExp<br />
.Pattern = "(\?)[(\w\.\&*)+(\=)[\w\d ]*"<br />
.IgnoreCase = True<br />
.Global = True<br />
End With<br />
<br />
Set expressionMatch = objRegExp.Execute(HTMLstring)<br />
<br />
If expressionMatch.Count > 0 Then<br />
For Each expressionMatched in expressionMatch<br />
<br />
strTemp = Right(expressionMatched.value, (Len(expressionMatched.value)-1))<br />
'Alert strTemp<br />
HTMLString = Replace(HTMLString, strTemp, EncryptQS(QSCleanup(strTemp), Salt()))<br />
<br />
Next<br />
'Alert HTMLString<br />
encryptMenu = HTMLString<br />
<br />
Else<br />
'Response.Write "" & objRegExp.Pattern & " was not found in the string: " & StringToSearch & "."<br />
End If<br />
<br />
Set objRegExp = Nothing<br />
Set expressionMatch = Nothing<br />
<br />
End Function<br />
<br />
' Perform the necessary cleanup to the QueryString.<br />
Function QSCleanup(QS)<br />
QSCleanup = Replace(QS, "&", "&")<br />
End Function<br />
Now, I correctly pick out the query string (everything after the "?"), and for most entries it works fine....However, I have a couple of them that even though I pick out the query string, it doesnt replace the whole thing...for example:
noretrieve=true&rptid=jax212&dbcode=2&leasepro_id=1000018528&udb_id=100001.8528&usertype=V
becomes...
noretrieve=true&rptid=jax212&ENC_QfsJ/OaMUZ1cHMjPnUEM4o8C2+tdI/173ET767CvDXE4CEHmTyc5eWNTwinaV+/lI0K5idTSH32yKg+myuvdjA==
it should just be ...
ENC_QfsJ/OaMUZ1cHMjPnUEM4o8C2+tdI/173ET767CvDXE4CEHmTyc5eWNTwinaV+/lI0K5idTSH32yKg+myuvdjA==
Anybody have an idea as to why this is happening?
Thanks!
|
|
|
|
|
Your pattern looks mighty strange. What is it that you are trying to match, really?
---
b { font-weight: normal; }
|
|
|
|
|
the pattern: "(\?)[(\w\.\&*)+(\=)[\w\d ]*"
has been changed to: "(\?)[(\w\.\-\&*)+(\=)[\w\.\-\ ]*"
What im trying (and I DO) match is the query string (from the ? to the end of it, which may be a "'")...the reason there are so many other things is that the query string may contain & (not &) as well as "." and "-"...the problem doesnt seem to be with the regular expression, but with the replacement part
if I change my code to this then everything works out fine...
<br />
For Each expressionMatched in expressionMatch<br />
strTemp = Right(expressionMatched.value, (Len(expressionMatched.value)-1))<br />
HTMLString = Replace(HTMLString, expressionMatched.value, "?" & EncryptQS(QSCleanup(strTemp), Salt()))<br />
Next<br />
|
|
|
|
|
if i want to push a keywords in the search engine of google for example.
for example: the user search for "car" keyword.
i want for my website to be in one of the results of the "car" keyword (not necessary to be on top ten of the search results)
and the hoster of my website doesn't provide this functionality.
what should i do?
Faris Madi
Nothing Comes Easy (N.C.E.)
|
|
|
|
|
If you want your site to show up in a Google for the keyword "car" then of course the content of your site must contain the word "car". Otherwise you can use Google Adwords and pay for inclusion.
|
|
|
|
|
hi all,
i want to create a movable strip of companies current prices of stock exchange in my website like BSE-india has.for this is there any permission require or simply create it in our website.please help me out for that,how will i create the movable strip.
Thanks
nitin Dalal
nitin
|
|
|
|
|
Try the html 'marquee' tag
http://www.htmlcodetutorial.com/_MARQUEE.html[^]
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for - in order to get to the job you need to pay for the clothes and the car, and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
|
|
|
|
|
_ I want to create a online chat website. According to my search on the Internet, they use Java (in form of applet) or Macromedia Flash (Shockwave?).
_ I don't know are there other ways of doing it. I don't ask you how to do it, I just need you to tell me a trend to do it, what technology I should use (Flash, ASP .NET, Sun Java,... - the easiest, most convenient way). Thanks for your attention!!!
|
|
|
|
|
I need to validate whether the input string contains any special characters other than alphabets and numbers.
TIA,
Sam.
|
|
|
|
|
Please don't cross post.
---
b { font-weight: normal; }
|
|
|
|
|
How about this pattern:
^[\p{L}\p{Zs}\p{Lu}\p{Ll}]$
/\ |_ E X E GG
|
|
|
|
|
How to resize when used fullscreen=yes feature with window.open()??
jagmit
|
|
|
|
|
Hi
Is there any way to hide an option item in a select box.
|
|
|
|
|
I don't think you can hide it, but you can disable it with the "disable" attribute, which greys it out and makes it unselectable. If you want it hidden, I think your only option is not adding it to the select.
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
for me, you can take it's attribute such as : "text"
I think it will make your options to be hidden
i love Image
|
|
|
|
|
Nice! Didn't know you could do that.
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
Hi All,
I have one excel file which is well formated with Images and cell merging kind of things. I want to Put Details in that file which is feeded by users using ASP page.
for examle : Online_excel.xsl
Online_form.asp(customer interaction file) ----> ----> fill_online_excel.asp(this file fills data inexcel file and saves it--HOW ????????) -------> send_online_excel.asp(Send that excel file in mail -->
or I can combine last two files :: fil_online_excel.asp and send_online_excel.asp if possible but how to fil data in excel and save it
|
|
|
|
|
Anyone know a way to get a client's email address (provided they have configured it) using javascript of vbscript? I've visited sites that do this, so I know it is possible.
This is on an intranet, so the client will always be MSIE.
TIA,
Barry Brevik
|
|
|
|
|
Yet another javascript for Collapsible
I have tried to make it Object oriented.
You can see the demo online here:
http://ashishware.com/OOPDemos.shtml
Following is link to non-object oriented version.
http://ashishware.com/CollapsiblePanel.shtml
I have tested it with FireFox and IE. Can anyone
tell me if they work with Safari aswell ??
Thanks in advance.
|
|
|
|
|
Me and some friends are opening up a new digital artist community and we have some pretty good ideas. But we have stumbled upon some little problems:
o we are going to charge through a company similar to paypal for subscriptions. is this actually a good idea? because - you know - such companies ask the payee to register before payment can be affected. will this impact sales?
o how can one affect payment from one user of the system to another? this will probably require some hardcore coding (which isn't a problem) but we'd like to know the overall concept of how it's done... obviously, if it is possible for you to tell us
That's all, I guess,
Thanks a lot for your help =)
In life truth does not matter. What really matters is what others believe to be the truth. (The Up and Comer - Book)
|
|
|
|
|
Your payment company should be able to provide you with samples of how to code this (I believe paypal do).
|
|
|
|
|
PayPal is a good way for payment (IPN).
|
|
|
|