close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Update before page loads

Thread began 2/23/2021 1:42 am by Sweens | Last modified 2/23/2021 12:55 pm by Ray Borduin | 53 views | 4 replies |

Sweens

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

Attached Files
3-pages_InsertURLa.php
Sign in to reply to this post

Ray BorduinWebAssist

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); ?>

Sign in to reply to this post
Did this help? Tips are appreciated...

Sweens

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

Sign in to reply to this post

Ray BorduinWebAssist

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"]);

Sign in to reply to this post
Did this help? Tips are appreciated...

Sweens

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);
}
?>

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...