notas.php

File: notas.php - Tab length: 1 2 4 8 - Lines: on off - No wrap: on off

<?

$tecnic="Entrandor no valid";
if(isset($_POST['username'])){
$tecnic=$_POST['username'];
}

$trim="Trimestre no valid";
if(isset($_POST['trim'])){
$trim=$_POST['trim'];
}

$cole="Escola no valida";
if(isset($_POST['cole'])){
$cole=$_POST['cole'];
}

$id=$_POST['id'];

if(isset($_POST['alumnes'])){
$alumne=$_POST['alumnes'];
list($cognoms,$nom,$id,$curs) = explode(",","$alumne");
}

$link=@mysql_connect('localhost','s020d938_diver','divertenis');
if (!$link){
die('error #1: No ha sigut possible la conexiï¿½ amb la base de dades, reintenta-ho en breu');
}
//echo 'Connected successfully';

mysql_select_db('s020d938_notas',$link);
if(!mysql_select_db('s020d938_notas',$link)){
die('error #2: No ha sigut possible la conexiï¿½ amb la base de dades, reintenta-ho en breu');
}
$query = ("SELECT * FROM `$trim` WHERE id=$id");
$result = mysql_query( $query,$link );
if( !is_resource( $result ) ) {
die("notas error #3: Problema con el Query:".mysql_error());
}

$avaluat=mysql_fetch_array($result);

$nom="$avaluat[nom]";
$cognoms="$avaluat[cognoms]";
$curs=$avaluat[curs];
$tecnic="$avaluat[entrenador]";
$data=$avaluat[data];
//notes

$coordinacio1="xl7031821";
$lectura1="xl7031821";
$desplacament1="xl7031821";
$general1="xl7031821";
$vdrive1="xl7031821";
$vreves1="xl7031821";
$drive1="xl7031821";
$reves1="xl7031821";
$smash1="xl7031821";
$servei1="xl7031821";
$desplacajoc1="xl7031821";
$comportament1="xl7031821";
$comunica1="xl7031821";
$motivacio1="xl7031821";
$assistencia1="xl7031821";

$coordinacio2="xl7031821";
$lectura2="xl7031821";
$desplacament2="xl7031821";
$general2="xl7031821";
$vdrive2="xl7031821";
$vreves2="xl7031821";
$drive2="xl7031821";
$reves2="xl7031821";
$smash2="xl7031821";
$servei2="xl7031821";
$desplacajoc2="xl7031821";
$comportament2="xl7031821";
$comunica2="xl7031821";
$motivacio2="xl7031821";
$assistencia2="xl7031821";

$coordinacio3="xl7031821";
$lectura3="xl7031821";
$desplacament3="xl7031821";
$general3="xl7031821";
$vdrive3="xl7031821";
$vreves3="xl7031821";
$drive3="xl7031821";
$reves3="xl7031821";
$smash3="xl7031821";
$servei3="xl7031821";
$desplacajoc3="xl7031821";
$comportament3="xl7031821";
$comunica3="xl7031821";
$motivacio3="xl7031821";
$assistencia3="xl7031821";

$coordinacio4="xl7031821";
$lectura4="xl7031821";
$desplacament4="xl7031821";
$general4="xl7031821";
$vdrive4="xl7031821";
$vreves4="xl7031821";
$drive4="xl7031821";
$reves4="xl7031821";
$smash4="xl7031821";
$servei4="xl7031821";
$desplacajoc4="xl7031821";
$comportament4="xl7031821";
$comunica4="xl7031821";
$motivacio4="xl7031821";
$assistencia4="xl7031821";

$jugant=$avaluat[jugant];
$global=$avaluat[comentari];

switch ($avaluat[coordinacio]){
case '1':
$coordinacio1="seleccio";
break;
case '2':
$coordinacio2="seleccio";
break;
case '3':
$coordinacio3="seleccio";
break;
case '4':
$coordinacio4="seleccio";
break;
}
switch ($avaluat[lectura]){
case 1:
$lectura1="seleccio";
break;
case 2:
$lectura2="seleccio";
break;
case 3:
$lectura3="seleccio";
break;
case 4:
$lectura4="seleccio";
break;
}
switch ($avaluat[desplacament]){
case 1:
$desplacament1="seleccio";
break;
case 2:
$desplacament2="seleccio";
break;
case 3:
$desplacament3="seleccio";
break;
case 4:
$desplacament4="seleccio";
break;
}
switch ($avaluat[general]){
case 1:
$general1="seleccio";
break;
case 2:
$general2="seleccio";
break;
case 3:
$general3="seleccio";
break;
case 4:
$general4="seleccio";
break;
}
switch ($avaluat[vdrive]){
case 1:
$vdrive1="seleccio";
break;
case 2:
$vdrive2="seleccio";
break;
case 3:
$vdrive3="seleccio";
break;
case 4:
$vdrive4="seleccio";
break;
}
switch ($avaluat[vreves]){
case 1:
$vreves1="seleccio";
break;
case 2:
$vreves2="seleccio";
break;
case 3:
$vreves3="seleccio";
break;
case 4:
$vreves4="seleccio";
break;
}
switch ($avaluat[drive]){
case 1:
$drive1="seleccio";
break;
case 2:
$drive2="seleccio";
break;
case 3:
$drive3="seleccio";
break;
case 4:
$drive4="seleccio";
break;
}
switch ($avaluat[reves]){
case 1:
$reves1="seleccio";
break;
case 2:
$reves2="seleccio";
break;
case 3:
$reves3="seleccio";
break;
case 4:
$reves4="seleccio";
break;
}
switch ($avaluat[smash]){
case 1:
$smash1="seleccio";
break;
case 2:
$smash2="seleccio";
break;
case 3:
$smash3="seleccio";
break;
case 4:
$smash4="seleccio";
break;
}
switch ($avaluat[servei]){
case 1:
$servei1="seleccio";
break;
case 2:
$servei2="seleccio";
break;
case 3:
$servei3="seleccio";
break;
case 4:
$servei4="seleccio";
break;
}
switch ($avaluat[desplacajoc]){
case 1:
$desplacajoc1="seleccio";
break;
case 2:
$desplacajoc2="seleccio";
break;
case 3:
$desplacajoc3="seleccio";
break;
case 4:
$desplacajoc4="seleccio";
break;
}
switch ($avaluat[comportament]){
case 1:
$comportament1="seleccio";
break;
case 2:
$comportament2="seleccio";
break;
case 3:
$comportament3="seleccio";
break;
}
switch ($avaluat[comunica]){
case 1:
$comunica1="seleccio";
break;
case 2:
$comunica2="seleccio";
break;
case 3:
$comunica3="seleccio";
break;
case 4:
$comunica4="seleccio";
break;
}
switch ($avaluat[motivacio]){
case 1:
$motivacio1="seleccio";
break;
case 2:
$motivacio2="seleccio";
break;
case 3:
$motivacio3="seleccio";
break;
}
switch ($avaluat[assistencia]){
case 1:
$assistencia1="seleccio";
break;
case 2:
$assistencia2="seleccio";
break;
case 3:
$assistencia3="seleccio";
break;
}
/*
switch ($avaluat[nivell]){
case 'mini1':
$nivell="Minitennis I";
break;
case 'mini2':
$nivell="Minitennis II";
break;
case 'mini3':
$nivell="Minitennis III";
break;
case 'charly1':
$nivell="Charlytennis I";
break;
case 'charly2':
$nivell="Charlytennis II";
break;
case 'charly3':
$nivell="Charlytennis III";
break;
case 'charly4':
$nivell="Charlytennis IV";
break;
case 'tennis1':
$nivell="Tennis I";
break;
case 'tennis2':
$nivell="Tennis II";
break;
case 'tennis3':
$nivell="Tennis III";
break;
case 'tennis4':
$nivell="Tennis IV";
break;
case 'master1':
$nivell="Master Tennis I";
break;
case 'master2':
$nivell="Master Tennis II";
break;
case 'mini':
$nivell="Minitennis";
break;
case 'iniciacio':
$nivell="Iniciaciï¿½";
break;
case 'perfeccionament':
$nivell="Perfeccionament";
break;
}
switch ($avaluat[color]){
case 1:
$logo="vermell.png";
break;
case 2:
$logo="groc.png";
break;
case 3:
$logo="verd.png";
break;
case 4:
$logo="blau.png";
break;
}

*/
$logo="judo.png";
// ???? Texto Html almacenado en la variable $html ??????
$html = "
<html xmlns:o=\"urn:schemas-microsoft-com:office:office charset=UTF-8\"
xmlns:x=\"urn:schemas-microsoft-com:office:excel\"
xmlns=\"http://www.w3.org/TR/REC-html40\">

<head>
<title>$nom $cognoms, $cole $trim</title>
<meta http-equiv=Content-Type content=\"text/html;charset=utf-8\" />
<style type=\"text/css\">


</style>

<style id=\"Divertenis\">


</style>

<link href=\"print.css\" type=\"text/css\" rel=\"stylesheet\" media=\"print\">";

$body="<body>

<div id=\"avaluacio\" align=center>

<table border=0 cellpadding=0 cellspacing=0 width=895 style='border-collapse: collapse;table-layout:fixed;width:672pt'>
<col width=216 style='mso-width-source:userset;mso-width-alt:7899;width:162pt'>
<col width=26 style='mso-width-source:userset;mso-width-alt:950;width:20pt'>
<col width=187 style='mso-width-source:userset;mso-width-alt:6838;width:140pt'>
<col width=26 style='mso-width-source:userset;mso-width-alt:950;width:20pt'>
<col width=208 style='mso-width-source:userset;mso-width-alt:7606;width:156pt'>
<col width=26 style='mso-width-source:userset;mso-width-alt:950;width:20pt'>
<col width=35 style='mso-width-source:userset;mso-width-alt:2742;width:56pt'>
<col width=170 style='mso-width-source:userset;mso-width-alt:4790;width:120pt'>
<tr height=23 style='height:17.25pt'>
<td colspan=3 height=23 class=xl6531821b width=429 style='height:17.25pt; width:322pt'>ESCOLA/COLï¿½LEGI: <span style='mso-spacerun:yes;'>$cole</span></td>
<td colspan=3 class=xl6331821 width=260 style='width:196pt'></td>
<td class=xl6331821 width=35 style='width:56pt'></td>
<td class=xl6731821 width=170 style='width:120pt'>Trimestre: $trim</td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl6431821 style='height:16.5pt'>DADES DE L ALUMNE:</td>
<td rowspan=32 class=xl1531821></td>
<td class=xl6431821>B-ASPECTE Tï¿½CNIC</td>
<td rowspan=32 class=xl1531821></td>
<td class=xl6631821>COMBINACIï¿½ I CONTRAATAC</td>
<td rowspan=32 class=xl1531821></td>
<td colspan=2 class=xl6631821b>4. ASSISTï¿½NCIA:</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6831821 style='height:15.0pt'>COGNOMS:<span style='mso-spacerun:yes'class=dades>$cognoms</td>
<td class=xl6631821>1. JUDO TERRA:</td>
<td class=$desplacajoc1>MOLT Bï¿½</td>
<td colspan=2 class=$assistencia1>BONA</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6831821 style='height:15.0pt'>NOM:<span style='mso-spacerun:yes'class=dades>$nom</span></td>
<td class=xl6631821>IMMOBILITZACIONS</td>
<td class=$desplacajoc2>Bï¿½</td>
<td colspan=2 class=$assistencia2>NORMAL</td>
</tr>
<tr height=21 style='height:15.75pt'>
<td height=21 class=xl6831821 style='height:15.75pt'>CURS:<span style='mso-spacerun:yes'class=dades>$curs</span></td>
<td class=$vdrive1>MOLT Bï¿½</td>
<td class=$desplacajoc3>NORMAL</td>
<td colspan=2 class=$assistencia3>POCA</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6831821 style='height:15.0pt'>NIVELL:<span style='mso-spacerun:yes'class=dades>$nivell</span></td>
<td class=$vdrive2>Bï¿½</td>
<td class=$desplacajoc4>AMB DIFICULTAT</td>
<td colspan=2 class=xl6531821>COMENTARI GLOBAL:</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6931821 style='height:15.0pt'>Tï¿½CNICS:</td>
<td class=$vdrive3>NORMAL</td>
<td class=xl6631821>3. Tï¿½CNICA DE COMBAT:</td>
<td colspan=2 rowspan=17 class=dades>$global</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td rowspan=4 style='border-bottom:1.5pt solid black; height:75.75pt'class=dades>$tecnic</td>
<td class=$vdrive4>AMB DIFICULTAT</td>
<td class=$servei1>MOLT Bï¿½</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6631821 style='height:15.0pt'>FORMES DE TOMBAR:</td>
<td class=$servei2>Bï¿½</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$vreves1 style='height:15.0pt'>MOLT Bï¿½</td>
<td class=$servei3>NORMAL</td>
</tr>
<tr height=21 style='height:15.75pt'>
<td height=20 class=$vreves2 style='height:15.0pt'>Bï¿½</td>
<td class=$servei4>AMB DIFICULTAT</td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=xl6431821 style='height:16.5pt;'>A-ASPECTE MOTRIU</td>
<td height=21 class=$vreves3 style='height:15.75pt'>NORMAL</td>
<td rowspan=2 class=dades> </td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6631821 style='height:15.0pt'>1. VALORACIï¿½ GENERAL:</td>
<td class=$vreves4>AMB DIFICULTAT</td>
</tr>
<tr height=21 style='height:15.75pt'>
<td height=20 class=$general1 style='height:15.0pt'>MOLT Bï¿½</td>
<td class=xl6631821>ROL DEFENSIU:</td>
<td class=xl1531821></td>
</tr>
<tr height=22 style='height:16.5pt'>
<td height=22 class=$general2 style='height:16.5pt'>Bï¿½</td>
<td class=$drive1>MOLT Bï¿½</td>
<td class=xl6431821>C-ACTITUD</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$general3 style='height:15.0pt'>NORMAL</td>
<td class=$drive2>Bï¿½</td>
<td class=xl6631821>1. COMPORTAMENT:</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$general4 style='height:15.0pt'>AMB DIFICULTAT</td>
<td class=$drive3>NORMAL</td>
<td class=$comportament1>Bï¿½</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6631821 style='height:15.0pt'>2. COORDINACIï¿½:</td>
<td class=$drive4>AMB DIFICULTAT</td>
<td class=$comportament2>NORMAL</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$coordinacio1 style='height:15.0pt'>MOLT Bï¿½</td>
<td class=xl6631821>ROL ATACANT:</td>
<td class=$comportament3>PASSIU</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$coordinacio2 style='height:15.0pt'>Bï¿½</td>
<td class=$reves1>MOLT Bï¿½</td>
<td class=xl6631821>2. DAVANT DEL GRUP ES COMUNICA:</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$coordinacio3 style='height:15.0pt'>NORMAL</td>
<td class=$reves2>Bï¿½</td>
<td class=$comunica1>AMB TOTHOM</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$coordinacio4 style='height:15.0pt'>AMB DIFICULTAT</td>
<td class=$reves3>NORMAL</td>
<td class=$comunica2>GRUP REDUï¿½T</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl6631821 style='height:15.0pt'>3. DESPLAï¿½AMENT:</td>
<td class=$reves4>AMB DIFICULTAT</td>
<td class=$comunica3>Lï¿½DER</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$desplacament1 style='height:15.0pt'>MOLT Bï¿½</td>
<td class=xl6631821>2. JUDO PEU:</td>
<td class=$comunica4>NORMAL</td>
<td colspan=2 class=xl1531821></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$desplacament2 style='height:15.0pt'>Bï¿½</td>
<td class=xl6631821>CLAUS</td>
<td class=xl6631821>3. MOTIVACIï¿½</td>
<td colspan=2 class=xl6631821>SIGNATURA Tï¿½CNICS</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$desplacament3 style='height:15.0pt'>NORMAL</td>
<td class=$smash1>MOLT Bï¿½</td>
<td class=$motivacio1>BONA</td>
<td colspan=2 rowspan=4 class=xl1531821></td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=$desplacament4 style='height:15.0pt'>AMB DIFICULTAT</td>
<td class=$smash2>Bï¿½</td>
<td class=$motivacio2>NORMAL</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 > </td>
<td class=$smash3>NORMAL</td>
<td class=$motivacio3>POCA</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 style='height:15.0pt'> </td>
<td class=$smash4>AMB DIFICULTAT</td>
</tr>
<tr height=20 style='height:15.0pt'>
<td colspan=2 rowspan=4 class=xl1531821></td>
</tr>
<tr height=20 style='height:15.0pt'>
</tr>
<tr height=20 style='height:15.0pt'>
</tr>
<tr height=20 style='height:15.0pt'>
<td height=20 class=xl1531821 style='height:15.0pt'></td>
<td class=xl1531821></td>
<td class=xl1531821></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=216 style='width:162pt'></td>
<td width=26 style='width:20pt'></td>
<td width=187 style='width:140pt'></td>
<td width=26 style='width:20pt'></td>
<td width=208 style='width:156pt'></td>
<td width=26 style='width:20pt'></td>
<td width=75 style='width:56pt'></td>
<td width=131 style='width:98pt'></td>
</tr>
<![endif]>
</table>
</div>

</body>
";
$html2="</html>

";
//* ----------HTML2PDF------------

$content = "
<page>
<h1>Exemple d'utilisation</h1>
<br>
Ceci est un <b>exemple d'utilisation</b>
de <a href='http://html2pdf.fr/'>HTML2PDF</a>.<br>
</page>";

require_once('../html2pdf/html2pdf.class.php');
$html2pdf = new HTML2PDF('P','A4','es');
$html2pdf->WriteHTML($body);
$html2pdf->Output('/prova/exemple.pdf');

// ???? Texto Html ??????
echo("$html $body $html2");

?>