{"id":1580,"date":"2018-01-19T19:23:00","date_gmt":"2018-01-19T19:23:00","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/remote-scripting-with-javascript-iframes-and-php-page-6\/"},"modified":"2018-01-19T19:24:54","modified_gmt":"2018-01-19T19:24:54","slug":"remote-scripting-with-javascript-iframes-and-php-page-6","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/remote-scripting-with-javascript-iframes-and-php-page-6\/","title":{"rendered":"Remote Scripting with Javascript, IFrames and PHP Page 6"},"content":{"rendered":"
\n
\n
By David Vance<\/div>\n
on May 10, 2004<\/div>\n<\/p><\/div>\n
\n
\nHere, the search value is extracted from the textbox, and if it’s less than 2
\ncharacters in length, nothing is done, and we are returned. With 60,000
\nrecords I needed to limit the search results and the resulting drop down
\nlist, so I implemented this arbitrary length check. Next, I check that
\nthe character entered is alphanumeric, a space, dash, or period. Again,
\nan arbitrary limit that is specific to my case. Finally, if the search term
\nis >= 2 characters and conatins valid characters, we dispatch the search term
\nto callToServer()<\/code>.<\/div>\n
\nBasically, the callToServer()<\/code> function creates a hidden
\nIFrame object and “calls”
\nthe server by loading the URL and it’s query string with the IFrame’s location
\nattribute. There are also various browser compatibility and error checks interspersed.\n<\/div>\n
\nNow, over on the server side is our PHP page of course, in my case server.php.
\nThe basic code looks like this:<\/div>\n
\n<\/p>\n

<?php
\n
<\/span>if(!isset(<\/span>$_GET<\/span>[<\/span>'s'<\/span>]))
\n
{
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$listAsString\u00a0<\/span>=\u00a0<\/span>'No\u00a0results'<\/span>;
\n
}
\n
else\u00a0
\n
{
\n
<\/span>\/\/cleanVar()\u00a0just\u00a0does\u00a0some\u00a0slash\/trim\/strip_tags\u00a0type\u00a0things
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$listAsString\u00a0<\/span>=\u00a0<\/span>searchFromJs<\/span>(<\/span>cleanVar<\/span>(<\/span>$_GET<\/span>[<\/span>'s'<\/span>]));
\n
}<\/p>\n

function\u00a0<\/span>searchFromJs<\/span>(<\/span>$searchTerm<\/span>)\u00a0
\n
{
\n
\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$query\u00a0<\/span>=\u00a0<\/span>'select\u00a0id,\u00a0first_name,\u00a0last_name\u00a0
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0from\u00a0users\u00a0where\u00a0last_name\u00a0like\u00a0\"'<\/span>.<\/span>$searchTerm<\/span>.<\/span>'%\"\u00a0
\n
\u00a0\u00a0\u00a0\u00a0order\u00a0by\u00a0last_name,\u00a0first_name\";\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0$result\u00a0=\u00a0mysql_query($query);
\n
\u00a0\u00a0\u00a0\u00a0if($result\u00a0===\u00a0false)\u00a0return\u00a0'<\/span>Invalid\u00a0query<\/span>:\u00a0<\/span>'\u00a0.\u00a0mysql_error();\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0if(mysql_num_rows($result)\u00a0<\u00a01)\u00a0return\u00a0'<\/span>No\u00a0results<\/span>';
\n
\u00a0\u00a0\u00a0\u00a0while($r\u00a0=\u00a0mysql_fetch_assoc($result))
\n
\u00a0\u00a0\u00a0\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$list\u00a0.=\u00a0$r['<\/span>id<\/span>'].'<\/span>~<\/span>'.$r['<\/span>first_name<\/span>'].'<\/span>~<\/span>'.$r['<\/span>last_name<\/span>'].'<\/span>|<\/span>';
\n
\u00a0\u00a0\u00a0\u00a0}
\n
\u00a0\u00a0\u00a0\u00a0$list\u00a0=\u00a0htmlspecialchars(preg_replace('<\/span>\/|$\/<\/span>','',$list),ENT_QUOTES);
\n
\u00a0\u00a0\u00a0\u00a0return\u00a0$list;\u00a0\u00a0\u00a0\u00a0
\n
}
\n
?><\/p>\n

<html>
\n
<script\u00a0type=\"text\/javascript\">
\n
window.parent.handleResponse(encodeURIComponent('<\/span><?=<\/span>$listAsString<\/span>;<\/span>?><\/span>'));
\n
<\/script>
\n
<\/html>
\n
<\/span>
\n<\/code><\/font><\/div>\n<\/div>\n

<\/p>\n

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

David Vance explains there basics of remote scripting, using Javascript, IFrames and<\/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-1580","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1580","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=1580"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1580\/revisions"}],"predecessor-version":[{"id":3404,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1580\/revisions\/3404"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1580"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1580"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1580"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}