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?

Hybrid View

  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,348
    Ask in the JavaScript Frameworks (JQuery) forum.
    Yes, I know I'm about as subtle as being hit by a bus..(\\.\ Aug08)
    Yep... I say it like I see it, even if it is like a baseball bat in the nutz... (\\.\ Aug08)
    I want to leave this world the same way I came into it, Screaming, Incontinent & No memory!
    I laughed that hard I burst my colostomy bag... (\\.\ May03)
    Life for some is like a car accident... Mine is like a motorway pile up...

    Problems with Vista? :: Getting Cryptic wid it. :: The 'C' word! :: Whois?

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