Pikachu2000
-
Posts
11,377 -
Joined
-
Last visited
-
Days Won
11
Everything posted by Pikachu2000
-
Contrary to what you were told in the other thread, I would not use this approach for something this simple*, that remains essentially static. There's no reason you can't do this with php. *unless your goal is to do it without a page refresh.
-
How To Combine Executable Start With Menu Change?
Pikachu2000 replied to yshua's topic in Applications
Just put the information on the site that the application is windows-only and that you do not issue refunds and be done with it. If you really feel the need to make absolutely certain the person knows the terms, put a "I understand the app is Windows-only, and agree to the terms" checkbox and make it mandatory. You can't always stop stupid people from doing stupid things. -
Magic quotes adds slashes, not quotes. The code above removes the slashes inserted by magic quotes.
-
Parse Error While Trying To Verify Unique Email.
Pikachu2000 replied to BrettHartel's topic in PHP Coding Help
I hope you changed your database password in addition to editing it out of your post. Google indexes these pages usually within a couple minutes. If you haven't changed it yet, go do it right now. -
To limit the number of results returned, you would add a LIMIT clause to your query.
-
It relies on a setting in php that should be turned off, and remain off. You need to explicitly assign the value from the form to $email in your if( empty($email) ) { conditional, or use the form value directly in it.
-
The code on phpeasystep.com is ten years out of date. Avoid that site and it's lousy tutorials.
-
Look at where your SELECT queries are. Look at where your UPDATE query is. Do you think maybe the order of operations has something to do with the problem?
-
Have To Know If Windows Or Mac, Etc., Clicked My Site
Pikachu2000 replied to yshua's topic in Applications
Make it clear that the program will only run on Windows, and that you don't issue refunds. That just opens the door for people to download it, install it on their Windows machine, and say "o, I didnt no it wuz fer windos! Munny bak, PLZ?" Then they have the program, and you don't have their money. -
Swap the quotes so the entire query string is enclosed in double-quotes, but the variables within it are in single-quotes. More information here: http://us1.php.net/manual/en/language.types.string.php
-
Variables are not interpolated in a single-quoted string in PHP. Echo the query string and you'll see what I mean.
-
True, but all of that is pretty much irrelevant when the query string is in single quotes . . .
-
I'm sure it is just because you're new. echo $sql; and look at the query string you get. If you don't understand why you see what you see, just say so . . .
-
It's actually a not a bad idea to use the hyphens, it removes any ambiguity when you have a problem and start echoing data to debug things like this. Have you echoed the query string to make sure it contains the values you'd expect it to contain? If that's the actual code, I can tell already that it doesn't . . .
-
Is this what you mean? <script type="text/javascript"> document.write("Total Hits :" + sessionStorage.<?php echo $counter; ?>); </script>
-
Is the database field a DATE data type?
-
That error indicates your query failed to execute. echo mysql_error to see why.
-
Add this line to your script and see if you get an error: $notvalid = $_SESSION['notvalid']; It should produce an 'undefined index' error. If it doesn't, we need to figure out why.
-
In your php.ini file, find the error handling section and make sure the following lines are in it, and appear only once without a leading semicolon: error_reporting = -1 display_errors = On Then restart Apache and see if you get any errors when you run the script. If you find more than one php.ini file, put phpinfo(); die(); in a script and run it. You can also verify your settings that way.
-
And do you have error_reporting at E_ALL, or preferably -1, and display_errors set to On?
-
You aren't actually comparing the length of the value entered in $_POST[$field}. You'd need strlen for that.
-
Instead of the alias, try the longhand version of it in the WHERE. SELECT *, STR_TO_DATE(invDetails.invoiceDate,'%m/%d/%y') as newDate FROM stores AS store INNER JOIN invoice_details AS invDetails ON store.sCustNum = invDetails.sCustNum WHERE store.sSalesman = 508 AND store.BillToId = 7161 AND STR_TO_DATE(invDetails.invoiceDate,'%m/%d/%y') BETWEEN '2012-01-01' AND '2012-12-31' GROUP BY store.sCustNum
-
I'm pretty sure you can't use the field alias in the WHERE clause.
-
Clearly, help was given. If you chose to ignore it and do something else, then that's your prerogative.
-
That code should be giving you an 'undefined index' notice when you first call it. If it isn't, you don't have error reporting set up at a high enough level for developing.