Consultar e Exibir resultado com ajax ou jquery
Pessoal faz pouco que iniciei com javascript, ajax e jquery... preciso de ajuda... pesquisando encontri um script na web para envio de formulario via ajax... até ai tudo bem...ele envia o formulario para uma pagina php...e grava os dados no mysql... porem no formulario eu tenho um campo "id" e eu preciso que quando eu envie esse formulario ele grave os dados e retorne o resultado da contagem dos dados... exemplo...antes de enviar o form eu tenho "id" com valor 51 e depois quando eu enviar ele atualize esse valor para 53 pois ele gravou o form pelo send.php e o send.php retornou um novo valor... segue o codigo... index.php
<?php
if (!isset($_SESSION)) session_start(). //if not exist a session destroy
if (!isset($_SESSION['username'])) { // destroy session session_destroy(). // redirect again to the index header("Location:../index.php"). exit. } $sesname = $_SESSION['username'].?>
<?php
$date = date("d/m/Y"). $time = date("H:i:s"). include "../global/connection.php".?><!DOCTYPE html>
<html> <head> <title>Bem-Vindo <?php echo $sesname.?></title> <link rel="stylesheet" href="style/css_index.css" type="text/css" /> <script type="text/javascript" language="javascript" src="js/jquery-1.3.2.js"></script> <script type="text/javascript"> $(function($) { $("#form").submit(function(){ var id = $("#id").val(). var client_name = $("#client_name").val(). var equipment = $("#equipment").val(). var model_equip = $("#model_equip").val(). var serial_number = $("#serial_number").val(). var os_infohouse = $("#os_infohouse").val(). var inside_date = $("#inside_date").val(). var inside_hour = $("#inside_hour").val(). var problem_presents = $("#problem_presents").val(). var obs = $("#obs").val(). var os_status = $("os_status").val(). $("#status").html("<img src='img/ajax-loader.gif' alt=''"). $.post("send.php", {id: id, client_name: client_name, equipment: equipment, model_equip: model_equip, serial_number: serial_number, os_infohouse: os_infohouse, inside_date: inside_date, inside_hour: inside_hour, problem_presents: problem_presents, obs: obs, os_status: os_status}, function(resposta){ $("#status").slideDown(). // Se a resposta é um erro if (resposta!= false) { // Exibe o erro na div $("#status").html(resposta). } else { $("#status").html("Mensagem enviada com sucesso!"). var nome = $("#id").val(). //usar o metodo ajax da biblioteca jquery para postar os dados em rowcount.php $.ajax({ "url": "../global/rowcount.php", "dataType": "GET", "data": { "rowCount": id, }, "success": function(response) { //em caso de sucesso, a div id recebe o response do post $("#id").html(response). } }). } }). }). }). </script> </head> <body> <header> <center><div id="title_of_page">Bem-Vindo <?php echo $sesname.?></div></center> </header> <nav> <div id="menu"> <ul id="tools"> <a href="?page=new_os" class="link"><li id="sub_tools" class="a_new">Nova OS</li></a> <a href="?page=search" class="link"><li id="sub_tools" class="a_search">Pesquisar</li></a> <a href="?page=new_client" class="link"><li id="sub_tools" class="a_client">Novo Cliente</li></a> <a href="?page=new_user" class="link"><li id="sub_tools" class="a_user">Novo Usuário</li></a> <a href="../logout.php" class="link"><li id="sub_tools" class="a_logout">Sair</li></a> </ul> </div> </nav> <section> <?php include "switch.php".?> </section> </body>
</html><?php
include "../global/connection.php". include "../global/rowcount.php".?>
<form id="form" action="javascript:func()" method="post"> <table> <tr> <td>Número O.S<br /><input type="text" name="id" id="id" class="c_md" onload="altera()" value="<?php echo $rowCount+1.?>" readonly="readonly" /></td> <td>Nome do Cliente*<br /><input type="text" name="client_name" id="client_name" class="c_m" /></td> </tr> <tr> <td>Equipamento*<br /><select name="equipment" id="equipment"> <option value="" selected="selected">Select...</option> <option value="All-in-One">All-in-One</option> <option value="Desktop">Desktop</option> <option value="Impressoras">Impressoras</option> <option value="Notebook">Notebook</option> <option value="Nobreak">Nobreak</option> </select> </td> <td>Modelo*<br /><input type="text" name="model_equip" id="model_equip" class="c_m" /></td> </tr> <tr> <td>Número de Série<br /><input type="text" name="serial_number" id="serial_number" class="c_m" /></td> <td>O.S InfoHouse<br /><input type="text" name="os_infohouse" id="so_infohouse" class="c_m" /></td> </tr> <tr> <td>Data de Entrada<br /><input type="text" name="inside_date" id="inside_date" class="c_m" value="<?php echo $date.?>" readonly="readonly" /></td> <td>Hora de Entrada<br /><input type="text" name="hour_date" id="hour_date" class="c_m" value="<?php echo $time.?>" readonly="readonly" /></td> </tr> <tr> <td>Problema Apresentado*<br /><textarea name="problem_presents" id="problem_presents" class="cm_d"></textarea></td> <td>Obs<br /><textarea name="obs" id="obs" class="cm_d"></textarea></td> </tr> <tr><td colspan="2"><input type="hidden" name="os_status" id="os_status" value="open" /></td></tr> <tr><td><input type="submit" value="ok" /></td></tr> </table>
</form>
<div id="status"></div>//Info DataBase
include "../global/connection.php". $id = $_POST['id']. $client_name = $_POST['client_name']. $cpf_cnpj = $_POST['cpf/cnpj']. $adress_client = $_POST['adress_client']. $neighborhood = $_POST['neighborhood']. $phone_client = $_POST['phone_client']. $equipment = $_POST['equipment']. $model_equip = $_POST['model_equip']. $serial_number = $_POST['serial_number']. $os_infohouse = $_POST['so_infohouse']. $inside_date = $_POST['inside_date']. $inside_hour = $_POST['inside_hour']. $problem_presents = $_POST['problem_presents']. $obs = $_POST['obs']. $os_status = $_POST['os_status']. $attendant = $POST['attendant']. $insert = $conn->prepare("INSERT INTO tabela (id, client_name) VALUES(:id,:client_name)"). $insert->bindValue(':id', $id). $insert->bindValue(':client_name', $client_name). $insert->execute(). if($insert){ echo false. }else{
echo 'nao deu'. } $select = $conn->prepare("SELECT * FROM tabela. "). $select->execute(). $rowCount = $select->rowCount().?><?php
$select = $conn->prepare("SELECT id FROM service_orders. "). $select->execute(). $rowCount = $select->rowCount().?>//Info DataBase
$hostname = "localhost". $dbname = "db". $dbuser = "root". $dbpass = "". $conn = new PDO("mysql:host=$hostname. dbname=$dbname. ",$dbuser,$dbpass).?>Discussão (2)
Carregando comentários...