@showman, If I were in your shoes, to think of security and flexibility, I will upload the file to my server for the first instance, then when the verification of the initial form data has returned true. I will just link to the uploaded file as an attachment to the email.
Yes I agree with pritaeas, using mysql keywords as raw text renders your sql statement invalid. For my personal preference I usually like using column names nested in back ticks. Try this.
I agree perfectly with pritaeas. I will advice you to go and learn the basis of php and programming. But since you are a beginner, I thought of refreshing myself with your problem. I have commented it very well for you to understand. Try it and I hope it solved your problem.
<?php
//this is the set of numbers
$numbers = 1432;
//getting the number of characters(length) of the set of numbers
$num_length = strlen($numbers);
//Will be using substr so setting the offset to zero
$i = 0;
//intialising the sum variable.
$sum = 0;
//executing the loop
while ($i < $num_length) {
//adding up numbers till the last one
$sum += substr($numbers, $i, 1);
//incrementing $i(offset) each time the a number is added
$i++;
}
//outputting the total results.
echo $sum;
?>
In your question you said, in the console this appears : Uncaught SyntaxError: missing ) after argument list page.php:64, but the codes you have posted ends on line 52. Can you please show all your codes?
@Trabelsi, I should not be talking for everyone but it seems you have not specified the exact problem you are having. Please specify the exact difficulty you are having. It's like you just posting your codes but there's no question. We are all willing to help one way or the other if the question is clear.
I totally agree with jkon, OOP is OOP in your style. But there are a few things you should also know which will help in your life of programming. This include errors you made in both PHP and HTML. (NOTE: reference XHTML, PHP5 and My Personal Interests).
The inclusion of the class in the same file as other php and html codes does not encourage the idea of OOP. Usually create a file to contain only the Class or group of classes, then you include them on the page they will be needed. You can also use spl_autoload to load your classes without having to include them one by one.
In your if statement, the codes should have been in parenthesis which shows that if the condition is correct run this specific codes.
HTML attributes should have their values placed in double quotation marks. You did some right and left a massive number of them. I recommend you to do that if you want your projects to be of the W3C standards.
You could have made your codes shorter and more readable by making the width and length arguments or parameters of the methods of the class. (Personal Preference).
Indenting of codes is a good practice if you want to become an elite programmer. Always indent your codes to produce neat work.
I don't know how you understand labels and their ids. The label id must be equal to the input field's id. (The field you want to address the …
Yes, I agree with pritaes, when executing sql in phpmyadmin and when there is an error it shows the place where the error is occuring.
Example
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13' at line 1
First of all, why are you using two database connection layers in one script; mysql and mysqli. Please, I encorage you to use mysqli since mysql is deprecated.
Also I think you should be precise of the form method you are using so that you don't just use $_GET or $_POST.
But to your question, it seems you are updating the table against a field called req_code. I will advise you to update your database tables using primary keys (usually id's are used as primary keys in the database).
In your example, it can be possible that, that req_code is the same across all fields in the database. But for id's (primary key), it can never be the same.
So if you don't have an id or primary key field, you go ahead and create one and then update your rows where id = userid.
Yh I agree with todyITguy, learning it will be of great help but if you are in need seriously you can use these ajax codes;
<script type="text/javascript">
function load () {
var xmlhttp = new XMLHttpRequest ();
xmlhttp.onreadystatechange = function () {
if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
document.getElementById('ajax').innerHTML = xmlhttp.responseText;
}
}
xmlhttp.open ('GET', 'your_php_file.php', true);
xmlhttp.send ();
}
</script>
Here, you can change the php file url to a get method by getting the values of the input fields you will use for the query. Here you will use something like
To clarify things when you were encrypting the password during registration, I hope you stored the salt which was added to the password during the encryption in the database.
You have made many mistakes of which include 1. Setting Form action to POST but using GET in PHP 2. Did not initialize mysqli connection 3. Were not sorting output by any column but instead you used a function.
Try these codes and make changes to it so it matches with your credentials
Your are still using ORDER BY DATE instead of p_date. Also you can save you fetch_assoc to an array and use fetch assoc to ouput the data which will be relevantly fast than echoing every thing bit by bit when dealing with huge amount of data.
