[Problem With Postcode In Database]

Thank you for your help. In code I deleted my -, and changed the TABLE `customers` `zip` mediumint(5) unsigned zerofill NOT NULL on `zip` int(5) unsigned zerofill NOT NULL. I'm getting to the base of zip code 21150 in the format, and I'm happy with this solution.

 

Regards

[Problem With Postcode In Database]

hello,

 

I made the second draft of the book, but I was a little mistake to be solved. I have a problem with the postal code, after completing the contact form on the site, the database I get a bad zip code, when I type in a ZIP code sample form 21-150 (in Poland we have a code of 5 digits) in the database shows me 00000. I'm Polish and I had to change the code included with the book. What can be wrong? please help.

 

checkout.php:

 

if (preg_match ('/^(^\d{2}-\d{3})$/', $_POST['zip'])) {

$z = $_POST['zip'];

} else {

$shipping_errors['zip'] = 'Podaj kod pocztowy!';

}

 

billing.php

 

if (preg_match ('/^(^\d{2}-\d{3})$/', $_POST['cc_zip'])) {

$cc_zip = $_POST['cc_zip'];

} else {

$billing_errors['cc_zip'] = 'Wpisz kod pocztowy!';

}

 

 

 

TABLE `customers` in Mysql

 

`id` int(10) unsigned NOT NULL AUTO_INCREMENT,

`email` varchar(80) NOT NULL,

`first_name` varchar(20) NOT NULL,

`last_name` varchar(40) NOT NULL,

`address1` varchar(80) NOT NULL,

`address2` varchar(80) DEFAULT NULL,

`city` varchar(60) NOT NULL,

`state` char(2) NOT NULL,

`zip` mediumint(5) unsigned zerofill NOT NULL,

`phone` int(10) NOT NULL,

`date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`),

KEY `email` (`email`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

[Administrative Pages]

Ok thanks for the quick response, I will now modify .htaccess

[Administrative Pages]

I rejoiced too soon :/, I installed "apache_2.2.11-win32-x86-openssl-0.9.8i" and run the page without database filled the main page and administrative pages appeared, and then I thought I was glad that the problem disappeared and I wrote here. Hehe when I filled out the database here we go again. Now I really don't know what to do. Do you have any idea?

 

Very rarely speak English, and there still such a compliment from an important person. Thank you.

[Administrative Pages]

Larry thank you very much for your interest in the case, and that you spent your precious time on my problem. I installed "apache_2.2.11-win32-x86-openssl-0.9.8i" and the problem disappeared. What a joy overwhelmed me when after 5 days of fighting with this problem I saw a administrative pages. Thanks Larry for a very helpful book and I'm sorry for my English.

All the best, David.

[Administrative Pages]

Ok I understand, I apologize for the inappropriate request. I was a little irritated, and can therefore asked you to do so. I can't access to the admin pages over HTTP. After typing in the browser "http://localhost/admin/index.php" automatically turns me on "https" and I get "Website not available".

 

I'll try to install "apache_2.2.11-win32-x86-openssl-0.9.8i" and do it all over again. Thanks for the quick reply.

[Administrative Pages]

Hello. First of all, thank you for your book, it's really great. The second project done already but I still have a payment system, I left it at the end. I'm Polish and I'm sorry for my English. I bought your book in Poland. And unfortunately for any help from publishers, I can't count. So I'm writing here. I have a problem with the administrative pages. Admin page does not appear, I get an error message: "Website is not available" screen below:

 

www.picshot.pl/public/view/full/213960

 

I don't know what to do, for five days I want to fix it but I can not all the same. I use "apache_2.2.11-win32-x86-no_ssl", "mysql-essential-5.1.56-win32 ',' php-5.2.2-Win32".

 

I thought it should "Apache no_ssl" and file "htaccess" I deleted my line

 

"RewriteCond% {HTTPS} off

RewriteRule ^ (checkout \. Php | billing \. Php | final \. Php | admin / (. *)) $ Https://% {HTTP_HOST} / $ 1 [R = 301, L] "

 

But it did't help. I'm doing this project in order to learn something at this stage so I can bypass the security. I think that my code is good, I checked it many times but I could be wrong. I don't know where the problem is. I sincerely request Mr. Larry, Can you see my code? If you have time, of course. Below I include a link to download my site:

 

 

 

Regards Dawid