-
Posts
16,734 -
Joined
-
Last visited
-
Days Won
9
Everything posted by PFMaBiSmAd
-
How did the data get into that table? You likely have a white-space/non-printing character at the start of each value that won't directly match the value you are putting into the query statement.
-
The name='...' attribute of your submit button is 'Save'. You would need to test for that name in your php code - $_POST['Save'] I recommend that you add the following debugging logic to your code so that you can see exactly what post data is being submitted - echo "<pre>"; echo "POST:"; print_r($_POST); echo "</pre>";
-
How do you know it is not running? What error or wrong result do you get? There's nothing technically wrong with what you posted. If the varField is a numerical value it will be converted to a float data type for the comparison. Without sample data, the actual query, and any php code involved, we cannot really help with what is causing the problem.
-
See what var_dump($row); shows?
-
Echoing back HTML tags from MySql database to respect HTML tags?
PFMaBiSmAd replied to galvin's topic in PHP Coding Help
There's nothing specific to storing/retrieving data or php that would prevent what you are doing from working. You likely have some code that is using htmlentities or htmlspecialchars on the data, which converts the < and > into html entities and they are not rendered by the browser. What does a 'view source' in your browser of the non-working <b>Classic Quote from movie</b> show? -
Using Open Source SOftware and PHP settings
PFMaBiSmAd replied to bigoxygen's topic in PHP Installation and Configuration
Your session.save_path setting is not set to a valid folder. -
The error's in line 1 of the sql statement. I would form the query statement in a php variable (and use that variable in the mysql_query() statement) and then echo that variable so that you can see exactly what the query statement is. You most likely have some extra characters in the $obitid value that is breaking the sql syntax. Where is $obitid being set at in the code?
-
I'll bet the error was - ...the right syntax to use near 'condition http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html
-
Image based $_POST along with multiple pages in one php file
PFMaBiSmAd replied to Hyperjase's topic in PHP Coding Help
isset would be used to test if something is set at all, so that you could decide to use an actual value or use a default value or a default choice. Near the start of your code, you would use one of the following - $_GET['step'] = isset($_GET['step']) ? (int)$_GET['step'] : ''; // replace the '' with whatever default value you want when the step is not provided in the URL or $step = isset($_GET['step']) ? (int)$_GET['step'] : ''; // replace the '' with whatever default value you want when the step is not provided in the URL Then you would just use $_GET['step'] (1st code) or $step (2nd code) in your logic. You know the value is set to either the integer value of the actual $_GET['step'] value or it is the default value. In general, you would use a switch/case statement when you are going to test for one of several values and execute specific code depending on the value. -
A thread that receives no responses generally indicates a thread that doesn't contain enough information. Your post is missing your queries, sample or real data, and the excepted output. However, I can tell from what you did post that you are executing two queries, when one should be enough, and you are using do/while loops, which take more code to insure that you have data available the first time through the loops, instead of a normal while(){} loop, which fetches the data it needs at the start of each pass through the loop. Your code also contains far too many opening and closing php tags, making it hard to even see what output you are trying to produce.
-
If by encryption, you mean using md5 (which is actually hashing, not encryption) on the password and then storing the md5 value in a cookie, then NO that is not secure because with the power of today's computers, it is easy to come up with a starting value that produces a specific md5 value that would let someone log in using your log in form.
-
Help - Login Always Says 'Incorrect Password'
PFMaBiSmAd replied to PHP-LEE's topic in PHP Coding Help
You need to set error_reporting to E_ALL. Your existing setting is hiding notice messages and there is a notice that would help you determine why your registration script is not putting the correct password value into your table. Hint: The submitted password is not in a variable named $password. You also need to use a DATE data type for your date column, with a YYYY-MM-DD format. Your existing format cannot be directly used by mysql for greater-then/less-than comparisons, sorting, or in any of the mysql date functions. -
Help - Login Always Says 'Incorrect Password'
PFMaBiSmAd replied to PHP-LEE's topic in PHP Coding Help
Where exactly in your code did you put the echo statements? -
Help - Login Always Says 'Incorrect Password'
PFMaBiSmAd replied to PHP-LEE's topic in PHP Coding Help
That error message is due to the following comparison failing - if ($password == $dbpass){. Why don't you echo both of those variables and see if you can determine why the comparison is failing? -
You should be logging the actual mysql_error() [edit: and the actual query statement] so that you know why the query failed. There's nothing in the visible part of that name that would be a problem. You likely have some white-space/non-printing character before or after that string that either should be trimmed off or filtered out.
-
Have you tried searching the Internet for - php qr code decoder
-
The link you posted in the first post mentions - It is based on a library which build qrcode in various language. The library link goes to a google page with a php source link (which is the link I posted) on it.
-
The qrcode.php file is just the class definition. You would need to include/require it and then call the methods along with outputting the header, followed by the image data. Did you read through the examples at the page where you got the grcode.php file - http://d-project.googlecode.com/svn/trunk/misc/qrcode/php/
-
Modify Header Error - Caused By 'require?
PFMaBiSmAd replied to oliverj777's topic in PHP Coding Help
The error message, that you didn't post all of, tells you where the output is occurring at. You would need to read the error message and find and eliminate that output. This sticky post might help - http://www.phpfreaks.com/forums/index.php?topic=37442.0 -
That's correct - If you tried that and it did not work, you would need to show the code necessary to reproduce the problem for anyone here to help with why it did not work. Edit: And define ''it didn't work". What did happen? A blank page? A php error? A mysql error?
-
mysql_real_escape_string doesn't do anything?
PFMaBiSmAd replied to LLLLLLL's topic in PHP Coding Help
We only see the information you supply in your posts. The code you did post and the 'view source' of the echoed output from that code (you did post the view source output from those 4 lines of code?) could not have produced the query error you stated you were getting. Therefore, something in the rest of your code was not putting that data into your query, but was putting data that had actual quotes, un-escaped ones, into the query. -
mysql_real_escape_string doesn't do anything?
PFMaBiSmAd replied to LLLLLLL's topic in PHP Coding Help
What source? What get array? To get the quickest solution to what your code is doing, post all the code needed to reproduce the problem. For all we know you aren't even using the variables you have shown in the actual query statement. -
mysql_real_escape_string doesn't do anything?
PFMaBiSmAd replied to LLLLLLL's topic in PHP Coding Help
There's nothing to escape because those are not quotes. They are html entities. If you want help with the mysql error, you will need to post the query and the actual msyql error you are getting. -
mysql_real_escape_string doesn't do anything?
PFMaBiSmAd replied to LLLLLLL's topic in PHP Coding Help
What does a 'view source' in your browser show of the echo'ed output from that code? Also, what is the code between that code and your query? What exact error do you get from your query statement? -
Use either one of the following for a 'custom' sort order - ORDER BY FIELD(day,'Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday'),end_time or ORDER BY FIND_IN_SET(day,'Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday'),end_time