How to write 0 to database in float from input value?

Question

PHP

Good afternoon, there is a field for entering numbers

<input name="c_score" value="<?php echo $data['lists']['c_score'];?>" type="text" class="inputbox" />

also button

<input type="button" value="Apply" onclick="javascript: document.adminForm.id.value='<?php echo $data['lists']['id']; ?>'; document.adminForm.stu_id.value='<?php echo $data['lists']['qid']; ?>'; submitbutton('quest_reportA');" />

there is also update tables

$mainframe = JFactory::getApplication();
    $database = JFactory::getDBO();
    $jinput = $mainframe->input;
    $c_score = $jinput->get('c_score', 0, 'INT');
......

 $remark = JFactory::getApplication()->input->getRaw('remark', '');

            $c_score = (float)$c_score;


      $query = "UPDATE #__quiz_r_student_question SET c_score = '".$c_score."', `remark` = ".$database->Quote($remark).", reviewed = 1 WHERE c_id = '".$data['id']."'";
      $database->SetQuery( $query );
      $database->execute();

The question is, when entering manually into input 0,0, the value will be saved to the base as 0. But if you enter just 0 (without a comma), then it does not save. Tried removing $c_score = (float)$c_score;
but nothing changes also does not save. Can anyone come across types or transformations?

Answer 1

Learn to use prepared statement(parameterized query)

Answer 2

$c_score = $jinput->get('c_score', 0, 'STRING');
$c_score = str_replace(',', '.', $c_score);
//...
$c_score = (float)$c_score;
//$query = "UPDATE ...

Answer 3

Read https://cmscafe.ru/docs/joomla/developer/api/627-j...
Should help.