jract7

I would… but the end result of all of this is to have a process setup to where you can dynamically build tables, display them on any page with a shortcode. Be able to enter/mark new data based on users info and have the ability to download that from the front and back end via permissions. And if a company would decide, aahh I don’t like that theme… then I’d be digging through pages trying to disect code, not to mention this would be a simplified answer to where most form plugins stop. If the ability to plug and play this stuff is there… why would you restrict yourself to a single page template or theme… more dynamic the better.

So after reading through the examples/info you gave me jackson, I’m beginning to think… I need to rethink this whole process…lol. I have the WP_Filesystem up and running. It will read the data to the .txt file, but not to the .csv…I’m sure I can figure that out… but my response to how the WP_Filesystem works brings up a few concerns….

1st, all my users will need this functionality from the front end and none of them have/nor need admin level access, so writing with the WP_Filesystm API would make things much difficult. Were talking 50+ employees… All of them getting ftp access is rediculious.

2nd, I do not really need to access that csv file for anything more than writing the data from the query. I mean that file is just a placeholder for the data on the local server so I could link to it and they could download… so i need it streamed and really it doesn’t have to touch a server file.

Awesome Jackson! Sending me on the right path… I thank you very, very much!

Alright… i’ve dug enough to figure out that the file is not being handled correctly.

Can fopen, open a http address that points to the filename?

[Code moderated as per the Forum Rules. Please use the pastebin]

…this is the code…

[Code moderated as per the Forum Rules. Please use the pastebin]

So I’m slowly answering my own question… so I thought I’d post to help others out if they are looking to do the same…

Please correct me if I’m wrong on any of these points, I’d hate to be misleading or confusing, but this is the way I understand it…

1) Use a plugin… Writing_a_Plugin
All the half-arse leads into the good WP documention can really throw you for a loop. You can create a dynamic table in the wp database…

->Copy the index.php in your “wp_content/plugin directory”
->Name it whatever you want… we’ll use “mynewplugin.php” for this
->Open mynewplugin.php
->Delete everything out of it
->Setup your mynewplugin.php as so…plugin name(just the bare minimum):

<?php
/*
Plugin Name: My New Plugin
*/
?>

-> Open your WordPress account and goto your editor under plugins
-> Select your “My New Plugin” in the drop down

2) So that’s where that code goes
Goto Creating_Tables_with_Plugins and read, re-read and follow what it says…

3) Editing for your own use
You can define global vars to use in other places by setting $my_new_vars in the mynewplugin.php
Basically I changed this:

function jal_install_data() {
   global $wpdb;
   $welcome_name = "Mr. WordPress";
   $welcome_text = "Congratulations, you just completed the installation!";

   $rows_affected = $wpdb->insert( $table_name, array( 'time' => current_time('mysql'), 'name' => $welcome_name, 'text' => $welcome_text ) );
}

To this:

global $jsa_user_name;
$jsa_user_name = "TestGuy";
global $jsa_post_title;
$jsa_post_title = "PO-0  Just a fake post for testing";

function jsadb_install_data() {
	global $wpdb;
	global $jsa_user_name;
	global $jsa_post_title;	

	$rows_affected = $wpdb->insert( $table_name, array( 'time' => current_time( 'mysql' ), 'name' => $jsa_user_name, 'text' => $jsa_post_title ) );
}

I’m assuming that creating the global vars $jsa_user_name and $jsa_post_title will allow me to add data by calling jal_install_data (which I renamed jsa_add_data)

My next question is do functions work in WP like they do in other programming languages… HERE… no, the scope of a function’s variables can only be used in that function if you redefine the global…like above:

global $jsa_user_name;
$jsa_user_name = "TestGuy";
global $jsa_post_title;
$jsa_post_title = "PO-0  Just a fake post for testing";

function jsadb_install_data() {
	global $wpdb;
	global $jsa_user_name;
	global $jsa_post_title;