Forum Moderators: coopster
<script type="text/javascript">
<!--
$("#link-bios").on("click", function(e) {
e.preventDefault();
var textarea = $("#markItUp");
var peopleid = "<?php echo $peopleid; ?>";
var db_request = $.ajax({
url: "/rather/linkcelebs.php",
type: "POST",
data: {
textarea: textarea.val(),
peopleid: peopleid
},
dataType: "json"
});
db_request.done(function(response) {
textarea.val(response.text);
})
});
// -->
</script>
while ($stmt->fetch()) {
if (mb_stristr($_POST['textarea'], $name) == TRUE AND mb_stristr($_POST['textarea'], $url) == FALSE) {
$_POST['textarea'] = str_replace($name, "\"$name\":/cr/$url/", $_POST['textarea']);
}
}
SELECT * FROM `peopledatabase` WHERE 'This is your text area with Renee Zellweger without accent and a lot of other words' LIKE CONCAT('%',`name`,'%')
This statement should return all records from your people database where the field `name` matches part of the text while ignoring accents.