{"id":1432,"date":"2018-01-19T19:22:50","date_gmt":"2018-01-19T19:22:50","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/check-data-page-2\/"},"modified":"2018-01-19T19:24:47","modified_gmt":"2018-01-19T19:24:47","slug":"check-data-page-2","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/check-data-page-2\/","title":{"rendered":"Check Data Page 2"},"content":{"rendered":"
\n
\n
By Spencer P<\/div>\n
on November 3, 2000<\/div>\n<\/p><\/div>\n
\n

Verify That Your Input Is Correct<\/h2>\n
\nNever trust the input you receive from someone else. You want your data to
\nhave perfect integrity, within the limits that you establish. If you
\nwrite a routine that saves someone’s address to your
\ndatabase, don’t trust your routine to magically fix user error. Only you can make that happen.<\/div>\n
\nLets write some quick code to save those addresses:<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>function\u00a0<\/span>saveAddress<\/span>(<\/span>$dbh<\/span>,<\/span>$firstName<\/span>,<\/span>$lastName<\/span>,<\/span>$streetAddress<\/span>,<\/span>$city<\/span>,<\/span>$zip<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$stmt<\/span>=<\/span>OCIPrepare<\/span>(<\/span>$dbh<\/span>,<\/span>\"
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Insert\u00a0into\u00a0addressBook
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(firstName,lastName,streetAddress,city,zip)
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0values
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0('$firstName','$lastName','$streetAddress','$city','$zip')\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0<\/span>OCIExecute<\/span>(<\/span>$stmt<\/span>);\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
}
\n
\u00a0\u00a0\u00a0\u00a0
\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nSo what happens if someone leaves the ZIP code out?
\nWhat if they put “pr0nd00d” as their ZIP code? Do not trust your input.
\nSome might argue that these checks should be done before this function.
\nWell, what if your co-worker, Billy Bob, reuses this function? Now he
\nhas to do the checks too. And don’t trust he’ll do it, either. Billy
\nBob is a lazy man, and not too smart in the first place.<\/div>\n
\nSo let’s define a function to make sure the ZIP code is right. After
\nall, my zip code is not “I like cheese.”<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>function\u00a0<\/span>validZipCode<\/span>(<\/span>$zip<\/span>)\u00a0{\u00a0
\n
\u00a0\u00a0\u00a0\u00a0return(<\/span>ereg<\/span>(<\/span>\"^[[:digit:]]{5}(-[[:digit:]]{4})?$\"<\/span>,<\/span>$zip<\/span>));\u00a0
\n
}
\n
\u00a0\u00a0\u00a0\u00a0
\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nThe validZipCode() function takes a zip code and does a regular
\nexpression match against it. If it $zip begins with 5 digits, with an optional
\ndash and 4 digit extension, return 1. Else return 0. Now, l
\nets integrate
\nit with our current function.<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>function\u00a0<\/span>saveAddress<\/span>(<\/span>$dbh<\/span>,<\/span>$firstName<\/span>,<\/span>$lastName<\/span>,<\/span>$streetAddress<\/span>,<\/span>$city<\/span>,<\/span>$zip<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0if(!<\/span>validZipCode<\/span>(<\/span>$zip<\/span>))
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0return(<\/span>0<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$stmt<\/span>=<\/span>OCIPrepare<\/span>(<\/span>$dbh<\/span>,<\/span>\"
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Insert\u00a0into\u00a0addressBook
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0(firstName,lastName,streetAddress,city,zip)
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0values
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0('$firstName','$lastName','$streetAddress','$city','$zip')\"<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0<\/span>OCIExecute<\/span>(<\/span>$stmt<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0Return(<\/span>1<\/span>);
\n
}<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nNow our current function requires a valid ZIP code. It won’t accept a
\nblank one, nor a non-USA one. (Note that our function doesn’t simply
\nrequire a non-blank string — that would be A Bad Thing(tm)<\/b>.) If
\na ZIP isn’t passed, our function returns a 0. But wait…we can reword
\nthe logic so that when valid ZipCode() returns a 0, an array or string
\ncan be returned with a more descriptive error.<\/div>\n
\n<\/p>\n

<?php<\/p>\n

<\/span>If(!<\/span>validZipCode<\/span>(<\/span>$zip<\/span>))
\n
\u00a0\u00a0\u00a0\u00a0<\/span>push_array<\/span>(<\/span>$errors<\/span>,<\/span>\"Invalid\u00a0zip\u00a0code.\"<\/span>);
\n
If(!<\/span>validStreetAddress<\/span>(<\/span>$streetAddress<\/span>))
\n
\u00a0\u00a0\u00a0\u00a0<\/span>push_array<\/span>(<\/span>$errors<\/span>,<\/span>\"Invalid\u00a0address.\"<\/span>);<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\n\tEtc…<\/div>\n
\nAdding the validation functions is an exercise left to the user. Some things may not be
\neconomically or technologically feasible,
\nas you cannot always afford to verify information beyond a certain point.
\nFor example, it would be too slow to confirm every bit of the input from the
\none hundred addresses per second you get. However, a simple check like the one
\noutlined above, makes it MUCH<\/b> harder to have data that
\ndoesn’t make sense. After all, we know that valid U.S. ZIP
\ncodes are numeric and how long they can be, so why accept data that’s
\nobviously wrong?<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
| <\/div>\n
4<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Spencer P on November 3, 2000 Verify That Your Input Is Correct Never trust the input you receive from someone else. You want your data to have perfect integrity, within the limits that you establish. If you write a routine that saves someone’s address to your database, don’t trust… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1432","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1432","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1432"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1432\/revisions"}],"predecessor-version":[{"id":3290,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1432\/revisions\/3290"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}