[SOLVED] Inserting Data

[mike6256]

Hi all

I am fairly new at php and need a little help.

I am having trouble with a code-it will insert my image but will not insert my number.

# Gather all required data

        $name = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['name']);

        $mime = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['type']);

        $size = $_FILES['uploaded_file']['size'];

        $data = mysqli_real_escape_string($dbLink, file_get_contents($_FILES  ['uploaded_file'][        'tmp_name']));

$number = mysqli_real_escape_string($dbLink, $_POST['textfield'], "text"),

 

The last line keeps kicking a pharse error

 

Thanks For Any Help

[trq]

There is no third perameter to mysqli_real_escape_string, what is "text" doing there?

[The Little Guy]

probably because you are using a coma instead of a semi-colon, and you have too many parameters...

 

Try this:

        $name = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['name']);
        $mime = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['type']);
        $size = $_FILES['uploaded_file']['size'];
        $data = mysqli_real_escape_string($dbLink, file_get_contents($_FILES['uploaded_file']['tmp_name']));
        $number = mysqli_real_escape_string($dbLink, $_POST['textfield'] . "text");

[mike6256]

updated the code with the ;  now is as follows

        # Gather all required data

        $name = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['name']);

        $mime = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['type']);

        $size = $_FILES['uploaded_file']['size'];

        $data = mysqli_real_escape_string($dbLink, file_get_contents($_FILES  ['uploaded_file'][        'tmp_name']));

$number = mysqli_real_escape_string($dbLink, $_POST['textfield'], ("text");

 

same thing--pharse error

[Philip]

What is , ("text"); supposed to be?

[The Little Guy]

updated the code with the ;   now is as follows

        # Gather all required data

        $name = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['name']);

        $mime = mysqli_real_escape_string($dbLink, $_FILES['uploaded_file']['type']);

        $size = $_FILES['uploaded_file']['size'];

        $data = mysqli_real_escape_string($dbLink, file_get_contents($_FILES  ['uploaded_file'][        'tmp_name']));

$number = mysqli_real_escape_string($dbLink, $_POST['textfield'], ("text");

 

same thing--pharse error

 

check my previous post, I concatenated some values... with the last line.

[mike6256]

Well got it part working by updating code to:

$number = mysqli_real_escape_string($dbLink, $_POST['textfield']["text"]);

 

Now will insrt the first character only ex. D instead of DT-41177

[The Little Guy]

try this:

 

$number = mysqli_real_escape_string($dbLink, $_POST['textfield']);

[mike6256]

THAT DID IT!  Thanks for all the help!