function insertToDatabase($xml) { //kopplar in till database $mysqli = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); if (!$mysqli) { echo "Det här gick ju inte så bra!"; } //Tömmer tabellen så att den blir nollställd $mysqli->query("truncate apk_data"); //sätter upp prepered $stmt = $mysqli->prepare("INSERT INTO apk_data (id,item_id,name,name2, department,volym,price, alcohol_by_volym, apk, status) VALUES (?,?,?,?,?,?,?,?,?,?)"); $stmt->bind_param("iisssdddds", $id, $artikelid, $name, $name2, $department, $volym, $price, $alcoholByVolym, $apk, $status); $char = ","; $csvFile = ""; //Loppar igenom alla artiklar foreach ($xml->artikel as $attribute) { $id = $attribute->nr; $artikelid = $attribute->Artikelid; $name = utf8_decode(deleteComma($attribute->Namn)); $name2 = utf8_decode(deleteComma($attribute->Namn2)); $department = utf8_decode(getDep($attribute->Varugrupp)); $price = floatval($attribute->Pant) + floatval($attribute->Prisinklmoms); $volym = floatval($attribute->Volymiml); $alcoholByVolym = calcAlc($attribute->Alkoholhalt); $apk = calcAPK($price, $volym, $alcoholByVolym); $status = $attribute->Sortiment; //Kör satsen $stmt->execute(); } }
} } ?> </div> <form method="get" class="appnitro" action=""> <label for="D_assoc">Selecionar Associado</label> <input id="D_assoc" type="text" name="D_assoc" placeholder="RG do associado" value="<?php echo @$_GET['D_assoc']; ?> "> <input type="submit" value="BUSCA"> </form> <form id="form_1044499" class="appnitro" method="post" action=""> <?php if (isAssoc(@$_GET['D_assoc'])) { getAssoc($_GET['D_assoc']); echo "<br>"; getDep($_GET['D_assoc']); print "\n <form id='form_1044499' class='appnitro' method='post' action=''>\n <ul >\n <li id='li_1' >\n <label class='description' for='element_1'>Nome </label>\n\t\t<span>\n\t\t\t<input id='element_1_1' name='D_nome' class='element text' maxlength='255' size='38' required/>\n\t\t\t<label>Nome completo</label>\n </li>\n <li id='li_3' >\n <label class='description' for='element_3'>Data de nascimento </label>\n\t\t<span>\n <input id='element_3_2' name='D_datanascDD' class='element text' size='2' maxlength='2' value='' type='number'> /\n\t\t\t<label for='element_3_2'>DD</label>\n\n\t\t</span>\n\t\t<span>\n\t\t\t<input id='element_3_1' name='D_datanascMM' class='element text' size='2' maxlength='2' value='' type='number'> /\n\t\t\t<label for='element_3_1'>MM</label>\n\t\t</span>\n\t\t<span>\n\t \t\t<input id='element_3_3' name='D_datanascYYYY' class='element text' size='4' maxlength='4' value='' type='number'>\n\t\t\t<label for='element_3_3'>YYYY</label>\n\t\t</span>\n\n\t\t<span id='calendar_3'>\n\t\t\t<img id='cal_img_3' class='datepicker' src='../img/calendar.gif' alt='Pick a date.'>\n\t\t</span>\n <script type='text/javascript'>\n Calendar.setup({\n inputField\t : 'element_3_3',\n baseField : 'element_3',\n displayArea : 'calendar_3',\n button\t\t : 'cal_img_3',\n ifFormat\t : '%B %e, %Y',\n onSelect\t : selectDate\n });\n </script>\n\n </li>\n <li id='li_10' >\n <label class='description' for='element_10'>Grau de Parentesco </label>\n <div>\n <select class='element select medium' id='element_10' name='D_parentesco' required>\n <option value='Mâe' >Mae</option>\n <option value='Pai' selected='selected'>PAI</option>\n <option value='Filho' >Filho</option>\n <option value='Filha'>Filha</option>\n <option value='Sobrinho' >Sobrinho</option>\n <option value='Sobrinha' >Sobrinha</option>\n <option value='Tio' >Tio</option>\n <option value='Tia' >Tio</option>\n <option value='Marido' >Marido</option>\n <option value='Esposa' >Esposa</option>\n <option value='Irmão' >Irmão</option> \n <option value='Irmã' >Irmã</option> \n <option value='Primo' >Primo</option> \n <option value='Prima' >Prima</option> \n <option value='Sogro' >Sogro</option> \n <option value='Sogra' >Sogra</option> \n <option value='Outros' >Outros</option> \n </select>\n </div>\n </li>\n\n <li class='buttons'>\n <input type='hidden' name='form_id' value='677' />\n\n <input id='saveForm' class='button_text' type='submit' name='submit' value='Cadastrar' />\n </li>\n </ul>\n </form>\n"; } else { echo "<p style='color: #22a20b;'>Busque por um associado para adicionar dependentte</p>"; } ?> <div id="footer"> </div> </div> <img id="bottom" src="../img/bottom.png" alt=""> </body> </html>
</li> </ul> <div class="datagrid"> <?php if (isset($_GET['C_rg']) || isset($_GET['C_registro'])) { if ($query = mysqli_query($com, $sql)) { $linhas = 1; $rows = mysqli_num_rows($query); if ($rows > 0) { echo "<table><thead><tr><th>Nome</th><th>Status</th><th>Nº Cartão</th><th>Dependentes</th></tr></thead>"; while ($assoc = mysqli_fetch_assoc($query)) { echo "<tbody><tr><td>" . $assoc['nome'] . "</td><td>" . status($assoc['status']) . "</td><td>" . $assoc['registro'] . "</td><td>" . depedentes(0) . " dependente</td></tr></tbody>"; } echo "</table><br></div>"; echo "<h2> Dependentes</h2> <br>"; getDep($_GET['C_rg']); } else { echo "Associado não encontrado"; } } } mysqli_close($com); ?> </div> <div id="footer"> </div> </form> </div>