More than one function on one variable

Question

I want to write something in the database, but before I want to delete all spaces in the string and upper the first letter.

That's how I wanted to do it but it doesnt work :P

//INITIALIZATION OF VARIABLE $perfectFirstname 

    $perfectFirstname = str_replace(' ','',$_POST["firstnameInput"]);

//PART OF MY QUERY

    $sql .=     "'".mysql_real_escape_string(ucfirst($perfectFirstname))."', ";

How can I do this?

Answer 1

You can use ucfirst for upper case:

$your_var = mysql_real_escape_string(ucfirst(strtolower(str_replace(' ','',$_POST["firstnameInput"]))));

Answer 2

how about,

$perfectFirstname = preg_replace('/\s+/', '', $_POST["firstnameInput"])

Answer 3

<?php

$_POST["firstnameInput"] = 'Billy';

$sql = '';
$sql .= "'".mysql_real_escape_string(ucfirst(str_replace(' ','', $_POST["firstnameInput"])))."', ";

var_dump($sql);


// OR, to reuse, a function like:

function MyEscape ($text) {
  return mysql_real_escape_string(ucfirst(str_replace(' ','', $text)));
}

$sql = '';
$sql .= "'".MyEscape($_POST["firstnameInput"])."', ";
var_dump($sql);

?>