Formulář se zápisem do DB bez diakritiky

7. 2. 2015 12:08:59

Zdravím,

na stránkách mám formulář který zapisuje data do databáze ale zapisuje také diakritiku do odkazů (což není vhodné pro můj projekt) a potřebuji to upravit tak aby se mi do tabulky permalink zapisoval text bez diakritiky (pokoušel jsem se řešit ty url i přes .htaccess ale bez úspěchu)

Níže přikládám kod:

<?php
	include "./license.api.php";
	if(!allow_pictures())
		header('Location: ./dashboard.php');
	include "header.php";
		error_reporting(0);
		$success=false;
		$invalid=false;
		$error="";
if(isset($_POST))
{
	$title=trim($_POST);
	$description = strip_tags(trim($_POST));
	$media="";
	if($_POST!="")
		$source=trim($_POST);
	else
		$source="";
	if($_POST!="")
		$media=httpify(trim($_POST));
	else if(trim($_FILES)!="")
		$media=$_FILES;
	if($_POST!="")
		$ext = end(explode(".",strtolower(basename($_POST))));
	else if(trim($_FILES)!="")
		$ext = end(explode(".", strtolower($_FILES)));
	if (!valid_file_extension($ext))
		$error .="o. Only these file types allowed .gif, .jpeg, .jpg, .png<br />";
	if(trim($_POST)=="")
		$error .="o. Title must not be empty.<br />";
	if($error=="")
	{
	$tag=trim($_POST);
	$tag=mysql_real_escape_string($tag);
	$ids=Array();
	if (preg_match('/,/',$tag)) {
		$tags=explode(',',$tag);
			foreach($tags as $tag) 
			{
			$tag=trim(clean_tag($tag));
			if(trim($tag)!="")
			$ids[] = insert_tag($tag); 
			}
		}
		else {
				$tags=trim(clean_tag($tag));
				if(trim($tags)!="")
				$ids[] = insert_tag($tags); 
		}
		if(trim($_POST!=""))
		{
			$post_id=add_picture_url($title,$description,$media,$source);
			if($post_id)
					{
						add_media_tag($post_id,$ids);
						$success=true;
					}
			else
					{
						$invalid=true;
					}
		}
		else if(trim($_FILES)!="")
		{
			$post_id=add_picture_file($title,$description,$source);					
			if($post_id)
					{
						add_media_tag($post_id,$ids);
						$success=true;
					}
			else
					{
						$invalid=true;
					}
		}
	}
}
include "header.php";
function count_all_pictures()
{
	$sql = "select count(id) as total from media where type=0";
	$query = mysql_query($sql);
	$fetch = mysql_fetch_array($query);
	return $fetch;
}
function count_pending_pictures()
{
	$sql = "select count(id) as total from media where approved=0 and type=0";
	$query = mysql_query($sql);
	$fetch = mysql_fetch_array($query);
	return $fetch;
}
function count_approved_pictures()
{
	$sql = "select count(id) as total from media where approved=1 and type=0";
	$query = mysql_query($sql);
	$fetch = mysql_fetch_array($query);
	return $fetch;
}
?>
	<title>Add New Picture - <?php echo(get_title()) ?></title>
	<script type='text/javascript'>
		$(function(){
			$('#myfile').change(function(){
				var $myfile = $('#myfile');
				var $picurl = $('#picurl');
				$picurl.prop('disabled', $myfile.val());
				document.getElementById('picurl').value='';
			});
		});
		$(function(){
			$('#picurl').keyup(function(){
				var $myfile = $('#myfile');
				var $picurl = $('#picurl');
				$myfile.prop('disabled', $picurl.val());
			});
		});
	</script>
<?php
include "header_under.php";
?>      
        <div id="containerHolder">
			<div id="container">
        		<div id="sidebar">
                	<ul class="sideNav">
                    	<li><a href="./pictures.php">All <strong>(<?php echo(count_all_pictures()) ?>)</strong></a></li>
                    	<li><a href="./pictures.php?type=approved">Approved <strong>(<?php echo(count_approved_pictures()) ?>)</strong></a></li>
                    	<li><a href="./pictures.php?type=pending">Pending <strong>(<?php echo(count_pending_pictures()) ?>)</strong></a></li>
                    </ul>
                    
                </div>    
                
                
                
                <h2>Add New Picture or GIF</h2>
                
                <div id="main">
					<br />
					<form action="./add_pic.php" method="post" enctype="multipart/form-data">
						<fieldset>
						<p><label><b>Picture Title</b></label>
						<input style="width:35%" name="title" maxlength="<?php echo(post_title_length()) ?>" value="<?php $_POST ?>" type="text" class="text-long"></p>
						
						<p><label><b>Description</b></label>
						<textarea placeholder="Enter upto 170 characters of description (Optional)" maxlength="170" name="description" style="width:480px;height:50px"><?php $_POST ?>

Upload Picture

*Upload from your computer

Get From URL

*Or get from URL

Source

*Source if any

Tags

*Separated By Comma (Optional)

if(isset($_POST) && $error=="" && $success && !$invalid)

echo('

Picture Added Successfully

');