Web Development

Hmm....

Hmm.. I wonder...could this have something to do with it all?
What I did change yesterday, was to make sure the spaces gets sent, BUT, these are changed %20

Could it by any chance be that the null results I am getting, is simply because when it is written to the database, it gets written as "Foxy%20Hollow".
If so, do you have any suggestions on how to get arount this?
Because as far as I know, it will either gets sent as "FoxyHollow" or "Foxy%20Hollow".
(I course make it so that it will be "Foxy<any char>Hollow" aswell, could I in the register.php change the <any char> before sending it to the database? And in that case, how?)

When I look in the phpMyAdmin interface, I see them as it should be, with blanks, not %20.. I havn't actually checked in the console yet.

---------- Post updated at 12:00 PM ---------- Previous update was at 11:40 AM ----------

I have to apologize again to anyone that have tried to helo me so far.. to see exactly what was going in to the database, I checked the logs of http-access....
All entries have (up untill now) gotten entered as "%20Venue%20Name" so all of them had a blank space in front of them.. no wonder I never found them when trying WHERE venue = 'Foxy Hollow".. it didn't exist.

Problem solved, thank you!

---------- Post updated at 12:35 PM ---------- Previous update was at 12:34 PM ----------

Ok, one more problem.. (hope you guys arn't fed up with me yet)

I have managed to strip it all diwn, as I said earlier, from "%20Venue%20Name" to "Venue%20Name". But, I just detected something else...

If the registered venue name is for example "Foxy Hollow" (Foxy%20%20%20Hollow) I get the same kind of error, it can't be found as I only get "Foxy%20Hollow" outputed in my dropdown menu.

Is there a way to already at the point of inserting the values in the database, reduce the blanks. So that if I get a value like "This%20Venue%20%20Name%20Is%20%20%20Long" in the $_POST[venue] variable in register.php, it can get reduced to "This%20Venue%20Name%20Is%20Long". I guess the answer is str_replace. If I knew how many blanks there were, I wouldn't have any problems with this. But I have no way of knowing the exact amount of blanks will be used in the name, so I have no clue of how to use str_replace for this.

I mean, str_replace(' ', ' '); would only convert two blanks into one, right?

I recommend you use preg_replace() with a regular expression to remove any leading, trailing and "more than one space in the middle" of your string. This is really easy to do with one PHP preg_replace() statement. Or you could use more than one preg_replace() if easier for you at first, breaking the problem down into parts first.

Thank you Neo.

A few minutes after I send the post, I got a friend online who suggested this:

which seems to work pretty good

Ofcourse, this doesn't remove leading and trailing spaces, but I managed to fix that in the code that is actually sending the http-request. Unfortunately that coding language is quite limited and won't remove the extra spaces in between words on an very efficient way.

trim() will remove leading and trailing spaces.

PS: I suggest you do a bit of your own research before posting. For example, at a minimum look at the PHP man pages of the commands you are using!

Also, this:


should be

... for faster execution time.

I will leave it to you as an exercise to Google the net and find out why.

And please, do more of your own research before asking questions

If you get in the habit of looking at your log files when trouble shooting a problem, and also reading, at a minimum, the man pages of the PHP commands you are using, you will find that you actually will save more time v. less time.

Edit: I closed this thread because it is not related to MySQL; it is related to poor string formatting. If you wish to work on PHP string formatting, please start a new thread on a specific issue. Thanks.