Kryptronic Software Support Forum

Converting it to SQL is an option yes.. but we havent been having the best of luck with CCP yet keep running into problem after problem now dont get me wrong the software is the best we have tryed, hence why we went with it.. However it is the first time we needed 3rd party software. and well to be honest I dont really feel like messing with the fungshway so to speak of the whole package. By converting all or a section of it to SQL.. rather then that I would rather hack into it a little with an outside script that calls the maillist.csv and displays it similar to that of the maillist in admin view of the store.

So far I have no problem with calling and displaying the CSV file except that I can only get it to display like it does in the file itself email,f_name,l_name..

And what I want is to make it display a table view of it.

[ email ][ f_name l_name ][ edit / remove ]

^^^ is how i would like to get a table to display it. I know I shouldnt have a problem getting the file to remove a line or more.. and i know i shouldnt have a problem getting the info to edit on any given line...

this is what I have thus far as far as code goes for the script im workin on maybe you or someone else can help point me in the right direction as to make what it is I want.

<?php 

// reads a csv file and returns a two-dimensional array of lines/fields 
function read_csv($file,$delimiter) 
{ 
  $data_array = file($file); 
  for ( $i = 0; $i < count($data_array); $i++ ) 
  { 
   $parts_array[$i] = explode($delimiter,$data_array[$i]); 
  } 
  return $parts_array; 
} 

// reads a csv file and returns an two-dimensional array of lines/fields 
function select_csv($file,$delimiter,$field,$query) 
{ 
  $data_array = file($file); 
  for ( $i = 0; $i < count($data_array); $i++ ) 
  { 
   $parts_array[$i] = explode($delimiter,$data_array[$i]); 
   if(trim(strtolower($parts_array[$i][$field])) == trim(strtolower($query))) 
   { 
    $result_array[] = $parts_array[$i]; 
   } 
  } 
  return $result_array; 
} 


// ------------------- demonstration below -------------------- 


// this willl display all records in the csv file 
$data = read_csv('ccp51/data/tables/maillist.csv','|'); 
for ( $i = 1; $i < count($data); $i++ ) 
{ 
  for ( $u = 0; $u < count($data[$i]); $u++ ) 
  { 
   echo $data[$i][$u].' '; 
   if($data[$i][$u] == end($data[$i])) 
   { 
    echo '<br>';   
   } 
  } 
} 


echo '<p>';   
?>

If all else fails I will go out and try to convert the email list over to SQL.. but Im going to need help with that also..
How would I have CCP call to SQL, what should I name the tables etc etc etc.. Thanks   

alright nevermind.. comon sence.. i endlessly forget that Nick has done a great job with this software and has implimented almost everything as an option in the admin of CCP..

I guess im just a little too panicy right now.. the site plus the store are to be 100% working condition in less the 4 days and the client is up my ******** with constant changes and wanting to do un heard of things and complicated things.. things that should have been mentioned day one when he actually thought of them rather then coming up and saying heyi thought about this awhile back how bout do this.. and its usually not a question lol.. thanks for your patients (i know thats misspelled)..

if i have any questions from now on ill do more research before i post them. Thanks to those of you have helped me recently and in the past.

and thanks Nick for making such a great store package with support system on top of it all.  :-)

Although if someone can help me with the above CSV question I asked earlier please do.. I could use that someday soon cause I have researched that one for a few good hours to come up with examples to eventually get that out of it all...