Insert query problem

Question

I have a insert query that I have not changed, but for some reason it will not insert anything into the database.

The data gets inserted by a Ajax submit form and goes to insert.php

if(isset($_POST['message_wall'])){
    /* Connection to Database */
    include('config.php');

    /* Remove HTML tag to prevent query injection */
    $message = mysql_real_escape_string($_POST['message_wall']);
    $to = mysql_real_escape_string($_POST['profile_to']);

    $sql    =    'INSERT INTO wall (message) VALUES(
                "'.$message.'")';
                 mysql_query($sql);

I want to be able to add a user_id into the database too

The ajax code:

$(document).ready(function(){
    $("form#submit_wall").submit(function() {

    var message_wall = $('#message_wall').attr('value');

        $.ajax({
            type: "POST",
            url: "insert.php",
            data: "message_wall="+ message_wall,
            success: function(){
                $("ul#wall").prepend("<li style='display:none'>"+message_wall+"</li><br><hr>");
                $("ul#wall li:first").fadeIn();
            }
        });
    return false;
    });
});

"); $("ul#wall li:first").fadeIn(); } }); return false; });});

pziecina · Accepted Answer

hi,while I was waiting for your message I went back to the raw code.I changed my code and now it works but it falls again once I add the other info in hidden fields $.ajax({ type: "POST", url: "insert.php", data: "message_wall="+ message_wall, date: "msg_date="+ msg_date, success: function(){ $("ul#wall").prepend("
"+msg_date+"

"); $("ul#wall li:first").fadeIn();how do I add more than one post option?Is this right: data: "message_wall="+ message_wall, date: "msg_date="+ msg_date,I tried data: "message_wall="+ message_wall, "msg_date="+ msg_date,But nothing. I take it this is where the fields are sentHiAs this is an ajax form post then the data from the form should be inserted into your database using the insert.php script. Everything in the jQuery ajax form is passed to the processing script if you process it in the insert script it should work o/k.You would then include a response text using a simple echo statement in your insert script, this should include anything you wish to be included on your page.The php in your insert script would be similar to -At top of script -$date = $_POST["msg_date"];At bottom of script -if ($success) { echo "Inserted on $date"; } else { echo "There was a problem processing your information."; }The jQuery code for doing this would be -// Perform post-submission tasks function showResponse(responseText, statusText) { $('.response').text(responseText); }Plus -success: showResponse,In your ajax form processing optionsAnd simply include a

where you wish this to be displayed in your html code.PZwww.pziecina.com

The_FedEx_Guy · Answer

I have tried the orginal code sample that works.All I did was add a select statment to another page to list the messages.What could it be?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded