I want to insert records from one table to another. Both tables are in the same database. The idea is this: a value is read into the $ temp1 variable, a record from another table must be written into another variable (this is the last name). In another table there are only 2 columns - number and surname. This error is written in the logs:

PHP Catchable fatal error: Object of class stdClass could not be converted to string in D:\\Server\\htdocs\\www\\add.php on line 9

add.php

 <?php include("connect.php"); $link=Connection(); $temp1=$_POST['temp1']; $sql= "SELECT sname FROM names WHERE (UID='$temp1')"; $result = mysqli_query($link,$sql); $sname=mysqli_fetch_object($result); $query = "INSERT INTO `templog` (`temperature`,`sname`) VALUES ('".$temp1."','".$sname."')"; mysqli_query($link,$query); //var_dump(mysqli_error($link)); mysqli_close($link); ?>
  • In general, this can be done with one insert into templog(...) select uid, sname from names where uid=? And use the bindable variables, and do not insert values ​​directly into the query text. If there is any quotation mark to you now in sname, then your insertion will fly off with at least an error - Mike

1 answer 1

The value of this variable ( $sname ) is an object with data that is returned by the mysql_fetch_object function, and properties are your fields (property = value).

In other words, to get the value of the desired field, you need to access it so that $object->fieldname

 <?php include("connect.php"); $link=Connection(); $temp1=$_POST['temp1']; $sql= "SELECT sname FROM names WHERE (UID='$temp1')"; $result = mysqli_query($link,$sql); $obj=mysqli_fetch_object($result); $query = "INSERT INTO `templog` (`temperature`,`sname`) VALUES ('".$temp1."','".$obj->sname."')"; mysqli_query($link,$query); //var_dump(mysqli_error($link)); mysqli_close($link); ?>
  • It helped, thanks. Actually, do not tell me why it was impossible to directly insert the value of a variable if the mysqli_fetch_object () function was used - Stanislav
  • The value of this variable is an object with data, which is returned by the mysql_fetch_object function, and the properties are your fields (property = value). In other words, to get the value of the desired field, you need to access it as follows: $object->fieldname - alias
  • It is clear, thanks again. - Stanislav
  • Please mark the correct answers so that others can quickly find what you are looking for. - alias
  • one
    @alias and you would be desirable to explain the actions that you are doing or that are needed to achieve the result .... Otherwise, it becomes unclear what you did, where and why. - Alexey Shimansky