So, only thing you have to do is to select records from the database and put them in the forms ( value="..." ). After submit you update the database with the new values.
Example :
<?php
// connect to SQL server and select DB
// ..
// your query will select to edit record by id if you have one
$query = "SELECT name, phone, mail from table where id='$id' ";
$result = mysql_query($query, $link);
$row = mysql_fetch_array($result);
?><form action="edit.php" method="POST">
<input type="text" name="name" value="<?php echo $row['name']; ?>">
<input type="text" name="phone" value="<?php echo $row['phone']; ?>">
<input type="text" name="mail" value="<?php echo $row['mail']; ?>">
<input type="hidden" name="id" value="<?php echo $id; ?>">
<input type="submit" name="submit" value="Edit">
</form>
edit.php
<?php
// connect to DB server and select DB
....
// validate form data
// ...
$query = "UPDATE table SET name='$_POST[name]', phone='$_POST[phone]', name='$_POST[mail]' WHERE id='$_POST[id]' ";
// ...
?>
Remember that header() must be called before any actual output is sent, either by normal HTML tags, blank lines in a file, or from PHP. It is a very common error to read code with include(), or require(), functions, or another file access function, and have spaces or empty lines that are output before header() is called. The same problem exists when using a single PHP/HTML file.
Why do they make computers harder to use and program than they need to be? Here are some examples:
- Why do most spreadsheets and programming languages do trigonometric functions in radians, when most people use degrees?
This is Math, trgometric functions use radians, it is standart.
- In the 1980s, kids all over were programming computers. With the change to Windows, this suddenly stopped, as Microsoft made programming a lot harder to do. Why?
Computer became very complex, therefore languages become harder to learn and use -> that's why people stop programming.
- Why have all of the easy-to-use programming languages been replaced with the hard-to-use C derivatives?
Same answer as above.
- Why are they making HTML harder to use by taking away features and not replacing them?
HTML is simple language, if you consider it as hard to learn maybe programming is not for you.
- Why do the operating systems get more complicated and take up more memory? They aren't any more useful.
No one makes you use OS like eating memory monsters like MS product or heavy UNIX OS.
The little boy asks his father - "Daddy, how was I born?"
Dad responds, "Ah, my son, I guess one day you will need to find out anyway! Well, you see, your Mom and I first got together in a chat room. Then I set up a date via e-mail with your Mom and we met at a cyber-cafe. We sneaked into a secluded room, where your mother agreed to a download from my hard drive. As soon as I was ready to upload, we discovered that neither one of us had used a firewall, and since it was too late to hit the delete button, nine months later a blessed little Popup appeared and said:
<?
class dummy {
var $variable;
var $variable2 = 1;
var $variable3 = 2;
function sum($one, $two) {
$val = $one + $two;
return $val;
}
function sum2() {
$val = $this->sum($this->variable2, $this->variable3);
return $val;
}
}
?>
The "$this" variable is a reserved variable in object-oriented PHP programming (translation - don't use it in your classes!) that actually does the inheritance. "$this->sum()" is basically interpreted as, "in this class, perform the sum() function." Like "$this->sum()", "$this->variable2" is interpreted as "in this class, use the value of 'variable2'." Likewise with $this->variable3. Note: all calls to native class functions or variables are done in this manner. Starting with "$this->" and followed by the name of the function or variable you wish to use. I can't stress the importance of that enough.
You can then import it into a MySQL table by running:
load data local infile 'file.csv' into table table fields terminated by ',' enclosed by '"' lines terminated by '\n' (field1, field2, field3)
The fields here are the actual tblUniq table fields that the data needs to sit in. The enclosed by and lines terminated by are optional and can help if you have columns enclosed with double-quotes such as Excel exports, etc.
You have to remove any blank spaces before the php code.
The problem is that many editors seem to add additional blanks (spaces) and/or empty lines at the end of a file when you edit it. This so-called whitespace is then sent to the browser when the file is loaded and interferes with the header of a page that tries to send to the browser, often causing problems such as login problems.
I'm learning now CakePHP and I'm writing basic login script. So when I log ( validate username and password ) I want to print a message and after 5 seconds to redirect to index.
I use $this->flash('Login successfull', '/users/index', 5); but won't work ;(
