TommyLox
-
Posts
6 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Downloads
Gallery
Store
Posts posted by TommyLox
-
-
Correction - the subsequent tutorial was 'SQL_insert_statement' (not SQL_basic_introduction).
So, my issue is that I cannot follow the steps in the 'SQL_insert_statement.mov' as Stefan did not explain how setup the killer(1) table, i.e how to specify auto_increment. Please help as I cannot carry on with the tutorials until I successfully setup tables as Stefan/phpMyAdmin requires.
-
I am new to PHP and MySQL and whilst following Stefan's tutorial, I finished watching 'SQL_basics-introduction' where Stefan shows the database 'killer', but he doesn't create a table as he didnt fill in the options, so the tutorial ends as killer(0).
Then I go to the next tutorial, SQL-basic_introduction, and a table has been created: killer(1), but I do not know how to replicate this! The tutorial did not explain how to set 'auto-increment', so when I follow the tutorial like so: INSERT INTO people (name) VALUES ("Tommy"), phpMyAdmin gives me an error message: #1062 - Duplicate entry '0' for key 'id'.
I cannot proceed with the tutorials until I can replicate the setup of that table as Stefan has, can anyone fill this gap for me please? Step by step instructions would be much appreciated!
-
I am new to PHP and MySQL and whilst following Stefan's tutorial, I finished watching 'SQL_basics-introduction' where Stefan shows the database 'killer', but he doesn't create a table as he didnt fill in the options, so the tutorial ends as killer(0).
Then I go to the next tutorial, SQL-basic_introduction, and a table has been created: killer(1), but I do not know how to replicate this! The tutorial did not explain how to set 'auto-increment', so when I follow the tutorial like so: INSERT INTO people (name) VALUES ("Tommy"), phpMyAdmin gives me an error message: #1062 - Duplicate entry '0' for key 'id'.
I cannot proceed with the tutorials until I can replicate the setup of that table as Stefan has, can anyone fill this gap for me please? Step by step instructions would be much appreciated!
-
MAMP setup
in PHP
Thanks Ben and Wickham. I agree that it's fiddly (!), so I will resist testing the mail function through MAMP for now and test that functionality on my web host.
-
MAMP setup
in PHP
Hi - I'm can't seem to be able to receive emails when I complete and submit my forms. I followed the tutorials to the letter, so I guess the issue is doen to my MAMP configuration? My form_response.php code block is:
<?php
$name_first = $_POST['name_first'];
$email = $_POST['email'];
$football_team = $_POST['football_team'];
$best_player = $_POST['best_player'];
$comments = $_POST['comments'];
print "First name: {$name_first} with an email of: {$email}. Your
favourite football team is: {$football_team} and you feel the best
player is {$best_player}. We also take note of your comments:
{$comments}";
$email_message = "First Name: {$name_first} with an email of: {$email}";
mail('tomanderson83@gmail.com','Form Response ', $email_message);
?>
I am unsure how to fix this and receive the email, please help! Thanks a million!!
Table setup in phpMyAdmin
in PHP
Posted
Appreciated Ben. I eventually figured it out - the tutorials I had were indexed 1-9, so I assumed they'd be in order, but I was wrong..! No biggie, but thank you nonetheless.