[4.0][com_redirect] convert to prepared statement

[alikon]

Summary of Changes

use prepared statement for SQL

Testing Instructions

test com_redirect

Expected result

should work as before

Actual result

N/A

[richard67]

com_predirect? Is it a predictive redirect component? (joking about typo in title of this PR).

[alikon]

happy to see that even a draft + work in progress pull request got audience 😃

[Quy]

Column count doesn't match value count at row 1

[Quy]

I have tested this item ✅ successfully on 72d6ef4

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/25417.}

[tonypartridge]

I have tested this item ✅ successfully on 72d6ef4

Working as before.

---

_{This comment was created with the J!Tracker Application at issues.joomla.org/tracker/joomla-cms/25417.}

[ghost]

Status "Ready To Commit".

[wilsonge]

Thanks!