paulsvang

I’ve found this code to refresh my page after submittal.

echo “<meta http-equiv=’refresh’ content=’0′>”;

Your code worked by the way. Thanks a bunch!

I will definitely read up on it. And thanks for your input again! Good night.

I modified it and got it to work. How would I go about just looking for one record so that I avoid the foreach loop.

 $query = "SELECT userId FROM dsp_user_settings WHERE userID = 1";
$result = $wpdb->get_results ($query);
echo  $result->userId ;

I tried what I modified and it didn’t work. Am I doing something wrong here?

• This reply was modified 8 years ago by paulsvang.

I will give that a try.

I have a table with the column userId, globalShipping, freeShipping and I want to be able to pull them in. THe table is named dsp_user_settings.

If I can do it with $wpdb, I dont mind trying that route. I appreciate it Catacaustic!

I’m using the typical SELECT statement.

$servername = "localhost";
$username = "xxx";
$password = "xxx";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
 if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = mysqli_query($conn,"SELECT * FROM dsp_user_settings");
echo $sql['userId'];

• This reply was modified 8 years ago by paulsvang.

It worked once I run that code and put it outside the form. tx

• This reply was modified 8 years, 1 month ago by paulsvang.

Thank you Shannon. I’ll take a look at that link.

Just changed. Thank you for the reminder Maria.

i figured out the issue. It was passing the condition to the next but there was an issue on the next condition. Fixed it. Thanks all for your input. It was user error.

I’ve done that. That’s why I’m confused.

Output1 = “”
Output2 = “”
Output3 = “value”

The problem is that when I put in a third condition, and submit the form, then it’s in a loading phase and never goes anywhere. If I change to two conditions, it works just fine.

Base on the condition above, when all variables are empty, then the “do something” will take place however Output3 has a value in it so it should pass over the condition and continue on with the rest of the code. It’s just not making any sense to me right now. I’m using the plugin “Insert PHP” so that I can use PHP code within the page text area… I’m wondering if this is causing the issue.

• This reply was modified 8 years, 2 months ago by paulsvang.

Shannon,

The problem is that it’s not working in the latest version of WP. I’m not sure why. The only thing I can think of is the plugin I’m using.

I appreciate your feedback catacaustic. Do you know anyone who is willing to take on a project like that for payment?

Any insight guys?