chucky2183 on Does anyone have a sample .php file for use with editurl?

Wed, 11 Jan 2012 23:32:03 +0200

And how i can do the same but not modifying the database? I only want to add, edit, and delete an empty grid. I have days with this.

Thanks

tony on Does anyone have a sample .php file for use with editurl?

Fri, 16 Sep 2011 17:04:10 +0300

Well

It is very easy to say not work -

Please specify example code, browser, OS

This way you will save your and our time

Please do this into the future – if not – no help

Regards

djkuddel on Does anyone have a sample .php file for use with editurl?

Fri, 16 Sep 2011 01:05:30 +0300

Hi,

I have the same issue. It seem, that the editurl for edit do not work.

It would be great if someone could help.

Best regards,

jayasri on Does anyone have a sample .php file for use with editurl?

Tue, 13 Sep 2011 11:12:36 +0300

Hi BenRivera,

its working fine for me.but update,delete is not woking because $_POST['id'] is not coming in someurl.php.

can you give me a solution for that..

BenRivera on Does anyone have a sample .php file for use with editurl?

Wed, 10 Nov 2010 04:45:56 +0200

Here is an example:

<?php
... create your database connection here...

include_once('functions.php');

if (isset($_POST["oper"])) {
    if ($_POST["oper"] == "add") {
        $insertSQL = sprintf("INSERT INTO users (login, pword, fname, lname,
            email, wphone, hphone, mphone, idlocations, idaccess, idorgunits,
            status, last_update_id, last_update_dt, expiration_dt)
            VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, ifnull(%s,1000),
            current_timestamp(), DATE_ADD(current_timestamp(), INTERVAL 90 DAY))",
                        GetSQLValueString($_POST['login'], "text"),
                        GetSQLValueString($_POST['pword'], "password"),
                        GetSQLValueString($_POST['fname'], "text"),
                        GetSQLValueString($_POST['lname'], "text"),
                        GetSQLValueString($_POST['email'], "text"),
                        GetSQLValueString($_POST['wphone'], "text"),
                        GetSQLValueString($_POST['hphone'], "text"),
                        GetSQLValueString($_POST['mphone'], "text"),
                        GetSQLValueString($_POST['idlocations'], "int"),
                        GetSQLValueString($_POST['idaccess'], "int"),
                        GetSQLValueString($_POST['idorgunits'], "int"),
                        GetSQLValueString($_POST['status'], "text"),
                        GetSQLValueString($_SESSION['MM_UserID'], "int"));
        $Result = mysql_query($insertSQL, $metrics) or die(mysql_error());
    } elseif ($_POST["oper"] == "edit") {
        $editSQL = sprintf("update users set login = %s, pword = %s, fname = %s,
            lname = %s, email = %s, wphone = %s, hphone = %s, mphone = %s,
            idlocations = %s, idaccess = %s, idorgunits = %s, status = %s,
            last_update_id = %s, last_update_dt = current_timestamp(),
            expiration_dt = DATE_ADD(current_timestamp(), INTERVAL 90 DAY)
            where idusers = %s",
                        GetSQLValueString($_POST['login'], "text"),
                        GetSQLValueString($_POST['pword'], "password"),
                        GetSQLValueString($_POST['fname'], "text"),
                        GetSQLValueString($_POST['lname'], "text"),
                        GetSQLValueString($_POST['email'], "text"),
                        GetSQLValueString($_POST['wphone'], "text"),
                        GetSQLValueString($_POST['hphone'], "text"),
                        GetSQLValueString($_POST['mphone'], "text"),
                        GetSQLValueString($_POST['idlocations'], "int"),
                        GetSQLValueString($_POST['idaccess'], "int"),
                        GetSQLValueString($_POST['idorgunits'], "int"),
                        GetSQLValueString($_POST['status'], "text"),
                        GetSQLValueString($_SESSION['MM_UserID'], "int"),
                        GetSQLValueString($_POST['id'], "int"));
        $Result = mysql_query($editSQL, $metrics) or die(mysql_error());
    } elseif ($_POST["oper"] == "del") {
        $deleteSQL = sprintf("delete from users where idusers = %s",
                        GetSQLValueString($_POST['id'], "int"));
        $Result = mysql_query($deleteSQL, $metrics) or die(mysql_error());
    }
}
mysql_close($metrics);
?>

The function.php file has the getsqlvaluestring function to return data in the format needed for sql. If you want this file, send me a PM.

Regards,

Ben

mblack24 on Does anyone have a sample .php file for use with editurl?

Tue, 09 Nov 2010 19:11:38 +0200

I'm using php to pull from a mysql table. Everything is working except for the adding new data and editing data part. I have the options available, I just don't know what the someurl.php page is supposed to look like in order to add the new or edited data to my table.