Need to understand $_SESSION variables in php (2 weeks into wrestling with php for the first time)

Trying to implement Google login to a student survey, accessed via gmail. Prior version worked with an LDAP login, using the variable username.

The google login code returns $userid. Then I was told to use $_SESSION['valid_user'], so I tried this:  $_SESSION['valid_user'] = $userid;. But haven't been able to get this to work.

Mainly I need to populate $username with $_SESSION['valid_user'] and use that for several MySQL statements.

For example - current MySQL code
-          $query = "SELECT * FROM sum_training WHERE student_id = ' ".$username." ' ";
-          $query = "INSERT INTO sum_training (student_id_with_tng_cycle, student_id, date_submitted) VALUES( '$username', '$student_id', '$timeOnly');";

I ended up with this for username: $_SESSION[2a, where it should have been sjones2a

Original code:    sessionStorage.setItem("student_id_with_tng_cycle", "<?php print($username) ?>");

Also, having a hard time debugging this, so if you have a good php debugging link at your fingertips, that will really help.

I have a data array that I will be encoding into JSON.  Part of the array includes nested values:

"lineItems": [
    {
      "itemNumber": "44672",
      "quantity": 4,
      "unitOfMeasure": "BDL",
      "description": "LANDMARK PRO"
    }
    {
      "itemNumber": "447506",
      "quantity": 3,
      "unitOfMeasure": "BDL",
      "description": "LANDMARK 30 AR METRIC SHINGLES"
    }
  ],

How do I display this in my data array: $data=array("lineItems" => " . . .").  I'm hoping this is simple, but I am new to PHP cURL and haven't been able to find a solution anywhere.  Thanks for your help!

Hello everybody,

I usually make MS SQL statements from two or more using JOIN or UNION, but normally when they all have a row in common (WHERE something IS somewhere). This time I need to do the same with 3 tables but saying what's NOT in another table.

Basically, I have a table for users, another table for notifications and a third table with the read status for each notification and each user. What I need to get are all the notifications that the user haven't read. I've attached an image with a simplistic view of my tables:


How can I do this?

Thanks in advance!

Hi experts!  I'm trying to create a variable using an element of a json result.
The result is:

{"CreateOrderResponse":{"CreateOrderResult":{"OrderSubmittedFlag":1,"Response":{"ResponseCode":1,"ResponseMessage":"Order Created"},"Orders":[{"OrderID":1501001275,"ReportType":"Roof"}]}}}

I'm trying to create a php variable for the Order ID.  My code is:

$confirmation= $arr->CreateOrderResponse->CreateOrderResult->OrderSubmittedFlag->Orders->OrderID;

However, this is not working and it has me stumped.  Any help would be greatly appreciated!

I need help styling a custom add to cart url.  On this page, https://www.theherbsplace.com/which_calcium_is_best_for_you__sp_92/ right below Coral Calcium.

I tried this css code but it doesn't seem to even impact it.

.my-product  .woocommerce-Price-amount.amount {
	position:relative;
	right: 10px;
	top:10px;
}
.my-product woocommerce-Price-currencySymbol {
	position:relative;
	right: 10px;
	top:10px;
}

Select all Open in new window

All I want is for every thing to be on the same line as the image and to the right of the image.  I want it in this order the image, the price then add to cart button.

This is the custom code that creates it

add_shortcode( 'cs_product', 'cs_product_callback');
function cs_product_callback($atts = []) {

    global $product;

    $atts = shortcode_atts( array(
        'id' => null,
    ), $atts, 'cs_product' );

    $product = new WC_product( $atts['id'] );

    $product_img = wp_get_attachment_image( $product->get_image_id(), 'woocommerce_gallery_thumbnail' );
    $product_button = do_shortcode( sprintf('[add_to_cart id="%d" style="" show_price="%s"]', $atts['id'], false) );
    $product_price = $product->get_price_html();

    ob_start();

    $output = <<< EOT
        <div class="my-product">
            <div>$product_img</div>
            <div>$product_price</div>
            <div>$product_button</div>
        </div>
EOT;

    echo $output;

    return ob_get_clean();
}

Select all Open in new window

Thanks,

 $getString = "2018-09-17T17:02:10.898Z";

Select all Open in new window

im using php how can i use php to split this into like below


2018-09-17

17 hour
02 min
10 seconds

? struggling for hour with preg_mach

I have used this code here:

https://codex.buddypress.org/developer/loops-reference/the-members-loop/

and I want to filter users by certain criteria. The example for the bp-custom page is:

function my_custom_ids( $field_name, $field_value = '' ) {

  if ( empty( $field_name ) )
    return '';

  global $wpdb;

  $field_id = xprofile_get_field_id_from_name( $field_name ); 

  if ( !empty( $field_id ) ) 
    $query = "SELECT user_id FROM " . $wpdb->prefix . "bp_xprofile_data WHERE field_id = " . $field_id;
  else
   return '';

  if ( $field_value != '' ) 
    $query .= " AND value LIKE '%" . $field_value . "%'";
      /* 
      LIKE is slow. If you're sure the value has not been serialized, you can do this:
      $query .= " AND value = '" . $field_value . "'";
      */

  $custom_ids = $wpdb->get_col( $query );

  if ( !empty( $custom_ids ) ) {
    // convert the array to a csv string
    $custom_ids_str = 'include=' . implode(",", $custom_ids);
    return $custom_ids_str;
  }
  else
   return '';

}

Select all Open in new window

Example Usage: Get all members who have filled out the xprofile field ‘dogs’ and selected the value ‘poodles’.

<?php if ( bp_has_members( my_custom_ids( 'dogs', 'poodles' ) ) ) : ?>

Select all Open in new window

How do I add more conditions to the dogs/poodles. What If I also want 'birds', 'parrot' as well as 'dogs', 'poodles' ?

 $trackedTreadIDs[] = array(
              'id' =>$getThreadIds['id']
            );

Select all Open in new window

    
return implode(',', $trackedTreadIDs) ;

Select all Open in new window

output  = testGM: "Array,Array"

it suspose to be two ids but displays array array ?

All of the sudden my posts do not show up properly and my navigation drops and you cant see it. I am a novice at WordPress, can someone please assist? The posts are all on the default template set up, which is what I have always used. The facts its affecting every page (other than the home page) makes me feel a setting is off.  Can someone please check out the site and advise?  Thank you!!

**UPDATE I figured out the posts but my navigation isnt showing in the proper spot on all pages except the home page like it use to. Is it maybe too many words?
wise-eats.com

this is a  follow-on to this question

https://www.experts-exchange.com/questions/29145248/Need-Custom-Short-Code-For-WooCommerce.html

Select all Open in new window

The image is too large to be useful.  So, is there any way to programmatically create a short-code that does everything in the previous question but uses a thumbnail instead?

I found this

https://wordpress.stackexchange.com/questions/235313/add-the-post-thumbnail-url-to-a-shortcode-in-function-php

Select all Open in new window

but I am not clear how to design what I need.

Sorry if I didn't post the code, but my question is purely theoretical.

I am creating an android app, where in the Login activity the login credentials are entered by the app automatically (after an authentication via SMS) in the EditText GONE and are sent to the server.

Is it a problem if the php code is vulnerable to SQL Injection?

Would some attacker be able to manipulate the hidden fields of my application?

I need a shortcode for WooCommerce 3.6.2 that will show the image, price and add to cart button.  I found this shortcode [add_to_cart id="1984"] but it only shows the following:

https://gyazo.com/c1efad0e35b85a05227db4941ff6cd62

I saw this

https://stackoverflow.com/questions/19930779/woocommerce-custom-shortcodes

Select all Open in new window

discussing how to do a custom shortcode via php.  I know some php but I am not that clear how to create what I am needing.

Thanks,

 $created = date('d-m-Y',$setupCampaigns['TIMESTAMP']);
    

        if($setupCampaigns['TIMESTAMP'] < time() + 86400){
            $new = "<div class='new-eng-alert has-tooltip' data-original-title='null'>1</div>";
        } else {
            $new = "";
        }

Select all Open in new window

how can i tell if this current timestamp is within the 24 hours old from the current timestamp,

if yes display new else dont.

for example if timestamp is 2 hours old from current show, if it is 25 hours dont show.