Family users

Hi Peter,

Thank you for thoughtful reply. I’m making a site clone later next week and I will start trying things out then. Everything up to now has worked out-of-the-box so I’m really studying as I am sure this project will need more than I know, need to make the jump from designer with the odd borrowed snippet to quasi-developer for some new requirements..

I don’t want to take up your time until I have a better idea of my plan so will follow up properly later but this is what I’m thinking so far, I know this will probably be much more complicated to work..

So there is a users database and new family database/table, parent ids will be not unique and can be assigned to multiple users. I guess I could use Heidi to create/populate new db and test a demo..

Then create a family.php file with similar to your query, something like:

<?php
	require-once('wp-load.php');
	$get = $wpdb->get_results(" SELECT * from ".$wpdb->prefix."family_table" where PARENT_ID = 0001 ");
	echo "<pre>";print_r();echo "</pre>"
?>

Then load URL https://domain.com/family.php

If that shows the children ids of the test parent, then repeat with showing the results for the children, following the standard model and db link to scores:

<?php
// The Query
$the_query = new WP_Query( $args );
// The Loop
if ( $the_query->have_posts() ) {
    echo '<ul>';
    while ( $the_query->have_posts() ) {
        $the_query->the_post();
        echo '<li>' . get_the_title() . '</li>';
    }
    echo '</ul>';
} else {
    // no posts found
}
/* Restore original Post Data */
wp_reset_postdata();

Then edit query to use the parent ID for current user $$USER$$.

Then include your condition:

STUDENT_ID in (select STUDENT_ID from family_table where PARENT_ID = $$USER$$)
or STUDENT_ID = $$USER$$

Then retest for no crash with an only-child user.

And add a condition for connection failure like:

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

Then copy php file into a PHP snippet and insert into new family reports page on site.

I’d be grateful for a ‘you’re on the right track’ or ‘no, no, no’ if you have a minute. Thanks again.

I’ll follow up soon.

Bw,
Ben

Thanks Peter,

Will do!

Bw,
Ben

Hi @peterschulznl,

Thanks for follow up and advice. Not resolved but I have half a plan, not enough to be helpful to anyone else yet. Will close ticket though.

Bw,
Ben