Auto save username

QuestionsAuto save username
Jorge Barosa asked 3 years ago

Hello,

I have this query:

mysql_select_db ( $database_ggi, $ggi );
$query_rsUserName = sprintf ( "SELECT nome FROM utilizadores WHERE utilizador = '%s'", $_SESSION['MM_Username'] );
$rsUserName = mysql_query ( $query_rsUserName, $ggi ) or die ( mysql_error () );
$row_rsUserName = mysql_fetch_assoc ( $rsUserName );
$totalRows_rsUserName = mysql_num_rows ( $rsUserName );

and I would like to autosave the username on the table, something like this:

$col = array();
$col["title"] = "Utilizador";
$col["name"] = "Utilizador";
$col["width"] = "0";
$col["align"] = "left";
$col["hidden"] = false;
$col["editable"] = true; // esta coluna não editável
$col["editoptions"] = array("size"=>20); // with default display of textbox with size 20
// $col["editrules"] = array("required"=>false); // required:true(false), number:true(false), minValue:val, maxValue:val
// $col["editrules"] = array("edithidden"=>true);
// $col["formatter"] = "date"; // format as date
$col["formatter"] = "autocomplete"; // autocomplete
$col["formatoptions"] = $rsUserName;
$cols[] = $col;

But this is not working, can you help me.

Thanks
Jorge Barosa

3 Answers
Abu Ghufran answered 3 years ago

For default value, you can set

$col["editoptions"]["defaultValue"] = 'default';

Jorge answered 3 years ago

Hello Abu,

Thanks for your answer.

I want this field to be saved, but I don't want the user to edit the field!

$col = array();
$col["title"] = "Utilizador";
$col["name"] = "Utilizador";
$col["width"] = "20";
$col["align"] = "left";
$col["hidden"] = false;
$col["editable"] = false; // esta coluna não editável
// $col["editoptions"] = array("size"=>20); // with default display of textbox with size 20
$col["editoptions"]["defaultValue"] = $nome;
$cols[] = $col;

How can I do it?

Regards,
Jorge Barosa

Abu Ghufran answered 3 years ago

You can set it readonly.
$col["editrules"]["readonly"] = true;

Your Answer

10 + 13 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!