Mam gotową stronę ze starym skryptem wyglądowo jest ok ale nie funkcjonuje zapisywanie do bazy.
Nie bardzo wiem gdzie szukać przyczyny po za tym że index jest w html
jest to formularz ,który ma tylko zapisać lub wypisać z bazy.
<!DOCTYPE html> <!--[if lt IE 7]> <html class="no-js lt-ie9 lt-ie8 lt-ie7"> <![endif]--> <!--[if IE 7]> <html class="no-js lt-ie9 lt-ie8"> <![endif]--> <!--[if IE 8]> <html class="no-js lt-ie9"> <![endif]--> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="description" content=""> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Place favicon.ico and apple-touch-icon.png in the root directory --> <link rel="stylesheet" href="css/normalize.css"> <link rel="stylesheet" href="css/main.css"> <link href='http://fonts.googleapis.com/css?family=Open+Sans:400,300,700,800' rel='stylesheet' type='text/css'> <link href="//netdna.bootstrapcdn.com/font-awesome/4.1.0/css/font-awesome.min.css" rel="stylesheet"> </head> <body> <!--[if lt IE 7]> <p class="browsehappy">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p> <![endif]--> <!-- Add your site or application content here --> <form id="subscribe-form" class="subscribe-form hide"> <hr> <div class="form-message hide"> Dzięki teraz zgłoś się po LODA !</div> <div class="form-content"> <div class="group"> <div class="input-prefix"> <input id="email" name="email" class="form-control" type="email" placeholder="Your email"> </div> </div> <div class="group"> <div class="input-prefix"> <input id="name" name="name" class="form-control" type="text" placeholder="Your name"> </div> </div> <div class="group group-submit"> </div> </div> <div class="form-footer"> </div> <input type="hidden" name="action" value="subscribe"> </form> <form id="unsubscribe-form" class="subscribe-form hide"> <hr> <div class="form-message hide"> You've been unsubscribed.</div> <div class="form-content"> <div class="group"> <div class="input-prefix"> <input id="unsubscribe_email" name="unsubscribe_email" class="form-control" type="email" placeholder="Your email"> </div> </div> <div class="group"> <div> <input id="confirm" type="checkbox" name="confirm" value="T"> </div> </div> <div class="group group-submit"> </div> </div> <div class="form-footer"> </div> <input type="hidden" name="action" value="unsubscribe"> </form> </body> </html>
CREATE TABLE IF NOT EXISTS `subscription_form` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(250) NOT NULL, `name` varchar(250) NOT NULL, `date_subscribe` datetime NOT NULL, `date_unsubscribe` datetime NOT NULL, `status` char(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
# CONFIG if ($subscribe){ ); }else{ ); } // Connect to database $connection = mysql_connect(_DB_HOST, _DB_USER, _DB_PASS) or die ('Unable to connect to MySQL server.<br ><br >Please make sure your MySQL login details are correct.'); foreach ($fields AS $field){ } } $is_valid = true; $err_message = ''; foreach ($field['valid'] AS $valid) { switch ($valid) { case 'require': $err_message = 'Field required'; break; case 'email': $is_valid = $is_valid && preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/i", $value); $err_message = 'Email required'; break; default: break; } } } if (!$is_valid){ $err_message = $field['err_message']; } } } if ($subscribe){ 'email' => "'".$get['email']."'", 'name' => "'".$get['name']."'", 'date_subscribe' => 'NOW()', 'status' => "'T'", ); $sql = "REPLACE INTO subscription_form (`".implode("`, `", array_keys($data))."`) VALUES(".implode(", ", array_values($data)).")"; }else{ $sql = "UPDATE subscription_form SET date_unsubscribe = NOW(), status = 'F' WHERE email = '".$get['unsubscribe_email']."'"; } $sql_result = mysql_query ($sql, $connection ) or die ('request "Could not execute SQL query" '.$sql); } }else{ }