How to get URL from WP database and open it?

Question

I have WordPress site and custom table in DB. I need an user can enter promocode in the form, submit it, script find URL in the table by this promocode and open this URL in new window. I insert this HTML in widjet

<form method="get" id="searchform" action="">
<input type="text" name="destination" id="destination" value="" />
<input type="submit" id="searchsubmit" value="GO" />
</form>

And insert this code in function.php

$q = $_GET["destination"];
$result = $wpdb->get_results( "SELECT url FROM mytable WHERE target = ".$q);
var_dump($result);

But how to open window?

If you add target=“_blank” to form tag, you can then redirect it https://stackoverflow.com/a/768472/3254405 — boateng, Jun 01 '18 at 15:44
@ numbtongue interesting, but I need open URL to other website — Astraport, Jun 01 '18 at 16:06

score 1 · Answer 1 · answered Jun 01 '18 at 19:12

You can do this task by doing ajax once you get success in that you can write the code for opening the website in new tab

Here is another option but i am not preferring this.

echo "<script> window.open(".$external_link.", '_blank') </script>";
     exit;

How to get URL from WP database and open it?

1 Answers1