Q695

Thanks, that worked perfectly

I tried assigning variable names first, but for some reason I was unable to get it process, so I decided to try with ? to get them to run. Can you provide a run-able example?

Going from something like: $sql_update=''; $binders=''; if(isset($_POST['name']) && $_POST['name']!=''){ $name=$_POST['name']; $binders.=",$name"; $sql_update.="`name`=?"; } ... if(isset($_POST['phone']) && $_POST['phone']!=''){ $phone=$_POST['phone']; $binders.=",$phone"; $sql_update.="`phone`=?"; } $binders = trim($binders, ','); $sql_update = trim($sql_update, ','); if ($sql_update!='' && $binders!='') { $sql = "UPDATE ___table___ SET $sql_update WHERE id=$___id___"; $q = $conn->prepare($sql); // $q->execute(array($binders,$___id___)); } How would you send it to the PDO function? I spent the whole day trying to convert it from a mysql statement to a PDO statement, and feel like

If I do that, I need a way to also search with JavaScript turned off.

When I put the run_modal( href, url_data ) inside the jquery function() it says: Uncaught Reference Error: run_modal is not defined when outside It says: Uncaught Error: cannot call methods on dialog prior to initialization; attempted to call method 'open' when I remove the return false the hyperlink behaves as it always has. I'm just trying to be able to pass the function variables in through the "old method" to make the function more understandable (maybe I need to see a video on how exactly the jquery variable system works). vision: you have X possible modals that can be triggered you're trying to only trigger 1 modal that will use the variables it receives to run its ajax lookup.

This would work, if I wasn't trying to run a modal instead of an alert for presentation reasons: https://jqueryui.com/dialog/#modal-form The error I'm getting is: Uncaught Error: cannot call methods on dialog prior to initialization; attempted to call method 'open'

Here's what I'm starting with: javascript: $(function() { $( "#dialog" ).dialog({ autoOpen: false }); }); function run_modal( href, url_data ) { // $("#dialog").dialog("open"); $( "#dialog" ).dialog( "open" ); alert(href+"?"+url_data); } PHP: echo " <div id='dialog' title='Blog Post Viewer'></div> "; function modalize($link_txt, $href, $url_data){ //<a href='?$url_data' onmousedown='run_modal()' onclick='return false' >$link_txt</a> echo " <a href='? $url_data ' onclick='return false' onmousedown=' run_modal ( \" $href \" , \" $url_data \" );'> $link_txt </a> "; } I'm struggling to make the modal popup. From there I plan to plug in my own generic ajax loader to request the data to be populated in the modal.

Lunar pages is very to use, and their sites load quickly. Their winter special is $4.95, and the specs are: General account information: Hosting package default Shared Ip Address 67.210.123.60 Subdomains 0 / 999 Parked Domains 2 / 999 Addon Domains 0 / unlimited MySQL Databases 3 / 999 Postgresql Databases 0 / 999 Disk Space Usage 5.05 Megabytes MySQL Disk Space 0.22 Megabytes Disk space available Unlimited Megabytes Bandwidth (this month) 22.43 Megabytes Email Accounts 0 / 999 Email Forwarders 0 Auto-responders 0 Mailing Lists 0 / 1 Email Filters 0 Ftp Accounts 0 / 999 General server information: Operating system Linux Service Status Click to View Kernel version 2.6.9-78.0.8.ELsmp Machine Type i686 Apache version 2.0.63 PERL version 5.8.8 Path to PERL /usr/bin/perl Path to sendmail /usr/sbin/sendmail Installed Perl Modules Click to View PHP version 4.4.9 MySQL version 5.0.67-community cPanel Version 11.24.4-RELEASE 32603 Theme cPanel X v2.5.0 Documentation Click to View