SQL query in pages

  • Hi,

    I am new to wordpress and would like help to get the following scenario to work.

    I have a registration page with a registration form for an event. The results are stored in a table on the same DB as the WP installation. I would like to have the results of an SQL query display on a page of “Confirmed Attendees” where that SQL queries my table and spits out those results where I have flagged those folks who have paid the attendance fee. I then want these results to appear in a table with the first name, last name and attendance status.

    My question is:

    1. How do I use the connection to the SQL DB that wordpress is already using?
    2. How do I write the PHP so that the table will have as many rows as the SQL statement will spit out?

    Your help is very much appreciated.

    Thanks

    Kenneth

Viewing 2 replies - 1 through 2 (of 2 total)

  • You can simply use thewp-config.php file using require once.

    Or you can use the same database using the mysql connection string..

    Thread Starter kenrohde

    (@kenrohde)

    OK – here’s what I have so far but it’s obviously not working. However, it may give you a good idea what I am trying to do. I am using this code as part of a page.php within my theme folder. My idea is to then simply make the page use this template and the results should show…

    <?php
/*
Template Name: Page Show Youth Attendee Status
*/
?>
<?php get_header(); ?>
<div id="content">
	<div id="contentleft">
		<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
		<h1><?php the_title(); ?></h1>
		<?php the_content(__('Read more'));?><div style="clear:both;"></div>

		<!-- SQL Spits out results here  -->
		WP_Query($query = 'select first_name, last_name, reg_confirm, count(1) as count_rows from ft_form_1')
		<!-- table here  -->
		echo "<table border=\"1\" align=\"center\">";
		echo "<tr><th>First Name</th>";
		echo "<th>Last Name</th></tr>";
		echo "<th>Registration Status</th></tr>";
		while ( $counter <= sum(count_rows_SQL) ) {
		echo "<tr><td>";
		echo $first_name_SQL;
		echo "</td><td>";
		echo $last_name_SQL;
		echo "</td></tr>";
		echo $reg_confirm_SQL;
		echo "</td></tr>";
		$counter = $counter + 1;
		}
		echo "</table>";

		<!-- END OF SQL Spits out results here  -->

		<!--
		<?php trackback_rdf(); ?>
		-->
		<?php endwhile; else: ?>
		<p><?php _e('Sorry, no posts matched your criteria.'); ?></p><?php endif; ?>

	</div>

</div>

<!-- The main column ends  -->

<?php get_footer(); ?>

    Any helps is appreciated.

    Thanks a lot!!!!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL query in pages’ is closed to new replies.