PHP codes for the following please

barbaros_akkurt

Dear all,

I have established and imported a huge CSV file of about 20 thousand entries, about a musical notation archive. I have appended a column named "note_status", with which I would like to tell the database that I do not have a notation for the entry "0", or one page "1", two pages "2", three pages "3", etc.

Please help me with the PHP code, provided that I have the information above.
Secondly, since the number of note files are very numerous, I had to divide them into folders containing 1000 notes, like 1-1000, 1001-2000, etc.

Do I have to add another column, like "note_path", which helps the system find the path, or can we detect it from a column named "repertoire_no", which is exactly the same for the file name (without the page number); for example, a two-page notation for repertoire no 1221 has two files like 1221.gif and 1221_2.gif.

Thank you for your help,

PS: If someone is interested in how I imported the CSV into the corresponding MySQL table, please PM me and I will tell you.

djjjozsi

You can make a little function to create the folder name from id.

<?php

function getfoldername( $id )
{
    $id_per_thousand = ceil( $id / 1000 )-1;
    $from = $id_per_thousand * 1000;
    $to = $from + 1000;
    return ( $from + 1 ) . "-" . $to;
} 
echo getfoldername( 1 );

?>

i don't really keep it a good idea to store more then one entry in an entry. What if you need to delete one entry from a note? 1 2 3 4 5 6 are available ... the third one need to go...

Its not a well normalized database model if you realize that you cannot easily handle the records, and you need to hardcode functions to retrieve 8 notes from an id.

/**
 * imagenames_from_note()
 * 
 * @param mixed $notes  -  how many images this id has 
 * @param mixed $id  -  note id
 * @return array with image names
 */
function imagenames_from_note( $notes , $id )
{
    if ( $notes == 0 )
        return array();

foreach( range( 0 , $notes ) AS $element ) {
    $data[] = ( $element == 0 ) ? ( "$id.gif" ) : ( $id . "_" . $element . ".gif" );
}
return $data;
}

var_dump(imagenames_from_note(6 , 1001));  // test values

The problem will come if the customer asks a feature for each 'pages' from an entry, such as comment , vote , download stat...

Lets link to the mentioned "CSV into" code, please 🙂
i've made one, csvimport
i can translate if its needed 🙂

barbaros_akkurt

thank you for your reply. I will try to decipher and comprehend the contents.

what if I add columns like "note1", "note2", "note3", "note4", "note5", as it seems that I have a maximum of 3 note pages for a piece, and put 1 for the ones present and 0 for absent?

djjjozsi

i'm not friend of these solutions. But i don't want to force you to solve it with a complicated version that i suggested. Make fields as many you need, and hardcode the notes. And feel free to ask.