dcsimg
www.webdeveloper.com
Results 1 to 2 of 2

Thread: New to Jquery.. Not sure why I can't get my post data to work here?

  1. #1
    Join Date
    Jul 2014
    Posts
    2

    New to Jquery.. Not sure why I can't get my post data to work here?

    I'm comfortable with PHP but I'm not very familiar with jquery, and I'm not sure why it's not working here. I have checked the file paths and they're working correctly.

    I'm trying to get this post data to work with jquery/ajax in controlpanel.php.

    Controlpanel.php

    Code:
    <?php
    include('class/db.php');
    require_once("config/db.php");
    
    require_once("class/Login.php");
    $login = new Login();
    
    
    if ($login->isUserLoggedIn() == true) {
        include("views/logged_in.php");
    } else {
        include("views/not_logged_in.php");
    }
    
    $user1 = $_SESSION['user_name'];
    
    $db = new Database();
    $db->connect();
    $user = $db->escape($user1);
    $db->select('templates', 'template_description, template_name', NULL, 'userID="'.$user.'"');
    $res = $db->getResult();
    
    ?>
    <html>
    <head>
    <script type="text/javascript" src="js/jquery.js"></script>
    </head>
    
    <body>
    
    <h2><u>Insert</u></h2>
    
    <textarea rows="10" cols="25" name="insert_template"></textarea><br/>
    Name your template: <input type="text" name="insert_template_name" id="text_submit"/><br/>
    
    <br/><input type="submit" name="insert_submit" value="submit" id="insert_submit"/>
    <div id="insert_data"></div>
    
    
    
    <h2><u>Edit</u></h2>
    
    <select name="edit">
    <?php foreach($res as $row){
    print "<option value=".$row['template_name'].">".$row['template_name']."</option>";
    }
    
    ?>
    </select><br/>
    <textarea rows="10" cols="25" name="template_edit"></textarea><br/>
    
    <input type="submit" id="edit_submit" name="edit_submit">
    <div id="edit_data"></div>
    
    <h2><u>Delete</u></h2>
    
    <?php print "<table border=\"1\">
    <th>Template Name</th>
    <th>Template Description</th>
    <th> </th>";
    foreach($res as $row){ 
    echo "<tr>";
    echo "<td>". $row['template_name']. "</td>";
    echo "<td>". $row['template_description']. "</td>";
    echo "<td><input type=\"checkbox\" value=".$row['template_name']." name=\"checkbox\"></td>";
    echo "<tr/>";
    } 
    print "</table>";
    print "<br/><input type=\"submit\" value=\"Delete\" id='delete_submit' name='delete_submit'>";
    ?>
    
    <div id="delete_data"></div>
    <script type="text/javascript" src="test_process.js"></script>
    </body>
    </html>
    ajax/name.php

    Code:
    <?php
    include('C:\xampp\htdocs\email1\class\db.php');
    require_once("config/db.php");
    require_once("class/Login.php");
    
        $login = new Login();
        $user1 = $_SESSION['user_name'];
        $db = new Database();
        $db->connect();
    
    
    //insert    
    if(isset($_POST['insert_submit'])) {
        $template_name = $db->escape($_POST['insert_template_name']);
        $template_description = $db->escape($_POST['insert_template']);
        $db->insert('templates', array('template_name' => $template_name, 'template_description' => $template_description, 'userID' => $user)); 
    
        echo "Inserted successfully";
    }
    
    //edit  
    if(isset($_POST['edit_submit'])) {
        $template_edit = $db->escape($_POST['template_edit']);
        $template_name = $db->escape($_POST['edit']);
        $user = $db->escape($user1);
        $db->update('templates', array('template_description' => $template_edit), 'template_name="'.$template_name.'" AND userID="'.$user.'"');
    
        echo "Updated successfully!";
    }   
    
    #delete
    if(isset($_POST['delete_submit'])) {
    foreach($_POST as $value){
            $db->delete('templates','template_name="'.$value.'"');
            echo $value. " has been successfully deleted.";
    }
    }
    
    
    ?>
    test_process.js

    Code:
    $('input#insert_submit').on('click', function() {
        var name = $('input#template').val();
        if($.trim(name) != '') {
           $.post('ajax/name.php', {name: name}, function(data) {
               $('div#insert_data').text(data);
           });
        }   
    });
    
    $('input#edit_submit').on('click', function() {
        var name = $('input#name').val();
        if($.trim(name) != '') {
            $.post('ajax/name.php', {name: name}, function(data) {
                $('div#edit_data').text(data);
           });
        }
    });
    
    $('input#delete_submit').on('click', function() {
        var name = $('input#name').val();
        if($.trim(name) != '') {
            $.post('ajax/name.php', {name: name}, function(data) {
                $('div#delete_data').text(data);
           });
        }
    });

  2. #2
    Join Date
    Mar 2007
    Location
    localhost
    Posts
    2,591
    Ask in the JavaScript Frameworks (JQuery) forum.
    If your post falls off the page, bump it. ...
    Please remember to wrap any code you have in forum tags:-

    [CODE]...[/CODE] [HTML]...[/HTML] [PHP]...[/PHP]

    If you can't think outside the box, you will be trapped forever with no escape...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles