Update before page loads

Hi Ray

I have the attached page which creates a URL 'slug' from a newly created page title. It works after submitting the form. However, I'd really like it to update the field before the page submits (one less thing for the user to do) - but this obviously won't work as it is, as the form isn't created before the page loads!

I can move the 'slug' code before the update code - but how do I call it 'something' so that the update behaviour takes the value of 'something' ?

Many thanks

Chris

Just define a variable with the value and then refer to that value in the update like:

<?php
$something = "test";
?>

then set the update column value to:
<?php echo($something); ?>

Hi Ray

Many thanks. We're at the limit of my knowledge here! Where do I name the 'test' part? echo create_slug("".$rsPg->getColumnVal("pg_slug")."")."";

I move the slug code between the recordset and the update behaviour:

<?php
function create_slug($string, $charset = 'utf-8'){
$string = htmlentities($string, ENT_NOQUOTES, $charset, false); // convert accented characters to entities
// strip unwanted parts of entities to leave unaccented character
$string = preg_replace('~&([A-za-z])(?:acute|cedil|caron|circ|grave|orn|ring|slash|th|tilde|uml);~', '\1', $string);
$string = preg_replace('~&([A-za-z]{2})(?:lig);~', '\1', $string);
$string = preg_replace('~&[^;]+;~', '', $string); // remove other entities
return preg_replace('~[\s!*\'();:£@&=+$,/?%#[\]]+~', '-', $string); // replace spaces and illegal characters with hyphens
}
echo create_slug("".$rsPg->getColumnVal("pg_slug")."")."";
?>

Cheers
Chris

I'm not sure what you are trying to use to create the slug. This looks wrong.

I think instead of:


echo create_slug("".$rsPg->getColumnVal("pg_slug")."")."";

it would be something like:

$newSlug = create_slug($_POST["ProductName"]);

Hi Ray

It works fine with the form field; it's the code supplied as a Dreamweaver snippet.

UPDATE - I've got it working!

Many, many thanks

Cheers
Chris
------------------------
<?php
function create_slug($string, $charset = 'utf-8'){
$string = htmlentities($string, ENT_NOQUOTES, $charset, false); // convert accented characters to entities
// strip unwanted parts of entities to leave unaccented character
$string = preg_replace('~&([A-za-z])(?:acute|cedil|caron|circ|grave|orn|ring|slash|th|tilde|uml);~', '\1', $string);
$string = preg_replace('~&([A-za-z]{2})(?:lig);~', '\1', $string);
$string = preg_replace('~&[^;]+;~', '', $string); // remove other entities
return preg_replace('~[\s!*\'();£:@&=+$,/?%#[\]]+~', '-', $string); // replace spaces and illegal characters with hyphens
}
$newSlug = create_slug("".$rsPg->getColumnVal("pg_slug")."")."";
?>
<?php
if ("" === "") {
$UpdateQuery = new WA_MySQLi_Query($connEGM_i);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "page_content";
$UpdateQuery->bindColumn("pg_url", "s", "".($newSlug) ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("pg_sortorder", "i", "", "WA_DEFAULT");
$UpdateQuery->addFilter("pg_id", "=", "i", "".($_GET['pg_id']) ."");
$UpdateQuery->execute();
$UpdateGoTo = "3-pages-main-pic.php?pg_id=".$rsPg->getColumnVal("pg_id")."";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>