The X-Lab - Experimental Development Repository

ChordLib
Category: database
Language: PHP/MySQL
Description:
Adds guitar and piano chords into a database via point-n-click interface. This script is incomplete (missing POST-handler and database insertion code for piano chords)
Download: chordLib.zip
Source Code:
<!--### Written by Micah Atwell - www.micahatwell.com/xlab ###-->
<?php
   define('DB','chord_lib');
   define('GTR_LIB','guitar');
   define('PIANO_LIB','piano');
   define('IMG_URL','http://url/to/chord_lib/imgs/');
   define('PAGE',basename($_SERVER['SCRIPT_NAME']));
   
   function sqlAccess($db=null,$svr="your_sqlhost",$U="your_username",$P="your_password"){
      global $dbcon;
      $dbcon=@mysql_connect($svr,$U,$P)or die(mysql_error());
      if($db!=null){
         $sel_db=@mysql_select_db($db,$dbcon);
         if(!$sel_db)return false;
      }else return false;
      return true;
   }
   
   // POST HANDLER
   if(@$_POST){
      sqlAccess(DB);
      /*   EXPECT:
         cname   = str <chord_name>
         cell_<fret>_<string>   = str (''|'x'); ''=none, x=fingered (or open)
      */
      if(!isset($_POST['mode'])||$_POST['mode']=='')die('Mode not set. Aborting.');
      $MODE=$_POST['mode'];
      $CNAME=(isset($_POST['cname'])&&$_POST['cname']!='')?$_POST['cname']:'';
      $dbCols=array();
      $dbVals=array();
      $tmp=array();
      if($MODE=='guitar'){
         foreach($_POST as $PK=>$PV){
            if($PK=='mode'||$PV=='')continue;//skip mode and empty cells
            if($PK=='cname' && $PV!=''){
               $dbCols[]=$PK;
               $dbVals[]=mysql_real_escape_string($PV);
               continue;
            }
            $brk=explode('_',$PK);//[0]='cell', [1]=<fret>, [2]=<string>
            $dbCols[]='str'.$brk[2];
            $dbVals[]=$brk[1];
            $tmp[]='str'.$brk[2].' = '.$brk[1];
         }
         $QS="INSERT INTO ".GTR_LIB." (".implode(',',$dbCols).") VALUES ('".implode("','",$dbVals)."')";
         echo $QS;
         $qIns=mysql_query($QS)or die(mysql_error());
      }else if($MODE=='piano'){
         
      }
   }
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
   <title>ChordLib - Add Chords</title>
   <meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1">
   <script type="text/javascript">
      <!--
         //   parentEl   = (''|'<object_id>'|<object>)
         function pno_drawChord(parentEl){
            // CREATE PIANO KEYBOARD SHELL
            var shell=document.createElement('DIV');
            shell.setAttribute('id','pno_chordShell');
            shell.style.position='relative';
            shell.style.left='0px';
            shell.style.top='0px';
            shell.style.width='280px';
            shell.style.height='100px';
            shell.style.marginBottom='20px';
            // CREATE PIANO KEYBOARD
            var
               whtKeyW=20,
               whtKeyH=100,
               whtKeyC=14,
               whtKeyNums=new Array(1,3,5,6,8,10,12,13,15,17,18,20,22,24),
               blkKeyW=12,
               blkKeyH=100,
               blkKeyC=10,
               blkKeyNums=new Array(2,4,7,9,11,14,16,19,21,23),
               blkKeyOffsets=new Array(13,33,73,93,113,153,173,213,233,253);
            // DRAW WHITE KEYS
            for(var i=0;i<whtKeyC;i++){
               var key=document.createElement('DIV');
               key.style.position='absolute';
               key.style.top='0px';
               key.style.left=i*whtKeyW+'px';
               key.style.width=whtKeyW+'px';
               key.style.height=whtKeyH+'px';
               key.style.backgroundImage='url(<?php echo IMG_URL;?>piano_wht0.gif)';
               key.style.backgroundRepeat='no-repeat';
               key.setAttribute('id','key_'+whtKeyNums[i]);// key_<key_num>
               key.title=key.id;
               key.onclick=function(){pno_toggleMarker(this);}
               shell.appendChild(key);
            }
            // DRAW BLACK KEYS
            for(var i=0;i<blkKeyC;i++){
               var key=document.createElement('DIV');
               key.style.position='absolute';
               key.style.top='0px';
               key.style.left=blkKeyOffsets[i]+'px';
               key.style.width=blkKeyW+'px';
               key.style.height=blkKeyH+'px';
               key.style.backgroundImage='url(<?php echo IMG_URL;?>piano_blk0.gif)';
               key.style.backgroundRepeat='no-repeat';
               key.setAttribute('id','key_'+blkKeyNums[i]);// key_<key_num>
               key.title=key.id;
               key.onclick=function(){pno_toggleMarker(this);}
               shell.appendChild(key);
            }
            // INSERT DIAGRAM INTO DOCUMENT
            if(arguments.length==0||arguments[0]=='')document.body.appendChild(shell);
            else{
               if(document.getElementById(arguments[0])!=null)document.getElementById(parentEl).appendChild(shell);
               else parentEl.appendChild(shell);
            }
         }
         function pno_toggleMarker(srcEl){
            if(srcEl.style.backgroundImage.search(/0\.gif/)!=-1){
               srcEl.style.backgroundImage=srcEl.style.backgroundImage.replace(/0/,'1');
               document.getElementById('pno_form').elements[srcEl.id].value='x';
            }else if(srcEl.style.backgroundImage.search(/1\.gif/)!=-1){
               srcEl.style.backgroundImage=srcEl.style.backgroundImage.replace(/1/,'0');
               document.getElementById('pno_form').elements[srcEl.id].value='';
            }
         }
         //   parentEl   = (''|'<object_id>'|<object>)
         function gtr_drawChord(parentEl){
            // CREATE CHORD DIAGRAM SHELL
            var shell=document.createElement('DIV');
            shell.setAttribute('id','gtr_chordShell');
            shell.style.position='relative';
            shell.style.left='0px';
            shell.style.top='0px';
            shell.style.width='112px';
            shell.style.height='141px';
            shell.style.marginBottom='20px';
            shell.style.backgroundImage='url(<?php echo IMG_URL;?>gtr_block.gif)';
            shell.style.backgroundRepeat='no-repeat';
            // CREATE CHORD DIAGRAM CELLS
            var
               strC=6,
               fretC=7,
               cellW=20,
               cellH=20;
            for(var i=0;i<fretC;i++){
               for(var j=0;j<strC;j++){
                  var cell=document.createElement('DIV');
                  cell.style.position='absolute';
                  cell.style.display='inline';
                  cell.style.width=cellW+'px';
                  cell.style.height=cellH+'px';
                  cell.style.left=j*cellW;
                  cell.style.top=i*cellH;
                  cell.style.backgroundImage='url(<?php echo IMG_URL;?>clear.gif)';
                  cell.style.backgroundRepeat='no-repeat';
                  cell.setAttribute('id','cell_'+((i==0)?'0_'+(j+1):i+'_'+(j+1)));// cell_<fret>_<str>
                  cell.title=cell.id;
                  cell.onclick=function(){gtr_toggleMarker(this);}
                  shell.appendChild(cell);
               }
            }
            // INSERT DIAGRAM INTO DOCUMENT
            if(arguments.length==0||arguments[0]=='')document.body.appendChild(shell);
            else{
               if(document.getElementById(arguments[0])!=null)document.getElementById(parentEl).appendChild(shell);
               else parentEl.appendChild(shell);
            }
         }
         function gtr_toggleMarker(srcEl){
            if(srcEl.style.backgroundImage.search(/clear\.gif/)!=-1){
               srcEl.style.backgroundImage='url(<?php echo IMG_URL;?>gtr_dot_solid.gif)';
               document.getElementById('gtr_form').elements[srcEl.id].value='x';
            }else{
               srcEl.style.backgroundImage='url(<?php echo IMG_URL;?>clear.gif)';
               document.getElementById('gtr_form').elements[srcEl.id].value='';
            }
         }
      //-->
   </script>
</head>
<body>
<h3>ChordLib - Add Chords</h3>

<b>New Guitar Chord:</b><br>
<script type="text/javascript">gtr_drawChord();</script>
<form id="gtr_form" method="POST" action="<?php echo PAGE;?>">
   <input type="hidden" name="mode" value="guitar">
   <input type="hidden" name="cell_0_1"><input type="hidden" name="cell_0_2"><input type="hidden" name="cell_0_3">
   <input type="hidden" name="cell_0_4"><input type="hidden" name="cell_0_5"><input type="hidden" name="cell_0_6">
   <input type="hidden" name="cell_1_1"><input type="hidden" name="cell_1_2"><input type="hidden" name="cell_1_3">
   <input type="hidden" name="cell_1_4"><input type="hidden" name="cell_1_5"><input type="hidden" name="cell_1_6">
   <input type="hidden" name="cell_2_1"><input type="hidden" name="cell_2_2"><input type="hidden" name="cell_2_3">
   <input type="hidden" name="cell_2_4"><input type="hidden" name="cell_2_5"><input type="hidden" name="cell_2_6">
   <input type="hidden" name="cell_3_1"><input type="hidden" name="cell_3_2"><input type="hidden" name="cell_3_3">
   <input type="hidden" name="cell_3_4"><input type="hidden" name="cell_3_5"><input type="hidden" name="cell_3_6">
   <input type="hidden" name="cell_4_1"><input type="hidden" name="cell_4_2"><input type="hidden" name="cell_4_3">
   <input type="hidden" name="cell_4_4"><input type="hidden" name="cell_4_5"><input type="hidden" name="cell_4_6">
   <input type="hidden" name="cell_5_1"><input type="hidden" name="cell_5_2"><input type="hidden" name="cell_5_3">
   <input type="hidden" name="cell_5_4"><input type="hidden" name="cell_5_5"><input type="hidden" name="cell_5_6">
   <input type="hidden" name="cell_6_1"><input type="hidden" name="cell_6_2"><input type="hidden" name="cell_6_3">
   <input type="hidden" name="cell_6_4"><input type="hidden" name="cell_6_5"><input type="hidden" name="cell_6_6">
   Name: <input type="text" name="cname" size="8"><br>
   <input type="submit" value="Save"> <input type="reset" onclick="window.location='<?php echo PAGE;?>';">
</form>

<hr>

<b>New Piano Chord:</b>
<script type="text/javascript">pno_drawChord();</script>
<form id="pno_form" method="POST" action="<?php echo PAGE;?>">
   <input type="hidden" name="mode" value="piano">
   <input type="hidden" name="key_1"><input type="hidden" name="key_2"><input type="hidden" name="key_3">
   <input type="hidden" name="key_4"><input type="hidden" name="key_5"><input type="hidden" name="key_6">
   <input type="hidden" name="key_7"><input type="hidden" name="key_8"><input type="hidden" name="key_9">
   <input type="hidden" name="key_10"><input type="hidden" name="key_11"><input type="hidden" name="key_12">
   <input type="hidden" name="key_13"><input type="hidden" name="key_14"><input type="hidden" name="key_15">
   <input type="hidden" name="key_16"><input type="hidden" name="key_17"><input type="hidden" name="key_18">
   <input type="hidden" name="key_19"><input type="hidden" name="key_20"><input type="hidden" name="key_21">
   <input type="hidden" name="key_22"><input type="hidden" name="key_23"><input type="hidden" name="key_24">
   Name: <input type="text" name="cname" size="8"><br>
   <input type="submit" value="Save"> <input type="reset" onclick="window.location='<?php echo PAGE;?>';">
</form>
</body>
</html>