All Questions
Tagged with insert-update php
181
questions
0
votes
0
answers
50
views
PHP Update API php://input returning unexpected response
I am creating an API to update. When I call the API in Postman, I get a strange response when I var_dump what I am to get.
Here is my code:
$data = json_decode(file_get_contents("php://input&...
- 428
0
votes
1
answer
40
views
How can I UPDATE a column in a record when that information is the result of a GROUP CONCAT in the same table?
I cannot determine if this should be something nested or a JOIN.
Each record has three values from the column value across from their name in the column variable.
I have a successful GROUP CONCAT that ...
- 13
-1
votes
1
answer
190
views
Syntax error near on while using SQLITE on conflict clause
Here is my syntax where I am trying to update data if already exist but here I am not getting Why this error is coming up I am using SQLITE3.
Can anyone help me with my issue or can suggest me better ...
- 390
0
votes
1
answer
331
views
PHP Oracle not inserting data into the database
I'm trying insert the data into the oracle database by input tag which is inside the table tag but the the data is not inserting for some reason. Used multiple table tags inside the form tag. But data ...
0
votes
1
answer
400
views
Error. How can i make live table update and delete using ajax in laravel
i try to make editable role in user table but its error and not update data to database
here the error
this is my blade
<div class="table-responsive">
@csrf
<table ...
0
votes
1
answer
1k
views
Laravel can't update in database __ the create is working
The problem i have is i click on show on a seperate page then i edit the data.
but when i click on update nothing happen.
Controller
public function edit(Request $request,$id)
{
//
// $...
0
votes
0
answers
31
views
PHP: replace existing date in DB
I'm trying to remove the current date and update it with a new date to show that it is the latest version. This happens without creating a new entry in the DB table. The below works to update other ...
1
vote
1
answer
1k
views
Laravel patch method not supported (even on update method)
HTML PATCHING FORM
{{ Form::model($model , [ 'route' => ['admin.friendship.update', $model->id] , 'class'=>'needs-validation ajax-form', 'method' => 'post' ]) }}
@...
- 431
0
votes
0
answers
272
views
"Uncaught PDOException: SQLSTATE[HY000]" When Trying to Insert [PHP 8.0]
So my code was working perfectly fine, until I tried to insert to the database..
my DB.php (The problem seems to be here, I checked all the other files and nothing is causing any problems, the ...
- 11
-1
votes
3
answers
363
views
PDO Insert / Update on duplicate key
I have information coming from an online form, anywhere from 1-12 rows of repeated fields. It's all working up to this point, but when there is a duplicate, I'd like it to update three columns.
I'm ...
- 9
0
votes
1
answer
186
views
laravel array update multiple rows with diffrent ids
i am stuck in when i update multiple array value then each time update same value in diffrent ids like i have three fields like email,alert_level and select in select dropdoewn depends on alert_level ...
0
votes
0
answers
658
views
Using Codeigniter's Model - issue with saving according to primary key
I have been looking for a solution that would replicate MySQL's INSERT ... ON DUPLICATE KEY UPDATE in my Codeigniter model, which led me to the save() function.
I get the logic of it, and my script ...
- 121
-2
votes
1
answer
94
views
i am trying to create a banking app and i am getting this error " Undefined property: Illuminate\Database\Eloquent\Relations\HasMany::$amount"
user.php
public function transaction()
{
return $this->hasMany(Activity\transactionModel::class);
}
transactionModel.php
class transactionModel extends Model
{
protected $guarded=[];
...
0
votes
0
answers
70
views
PHP new strings update in DB with unshift?
I have a problem to adding more strings in my database.
The idea is: SELECT information, then added array together, after these UPDATE to database.
These are in one code, but UPDATE not working with ...
- 33
-1
votes
1
answer
413
views
Column name must be either a string or an array. yii
while I am updating record it display above error.
message id seems like this - 1536126282209770000
$q = new CDbCriteria(array(
'condition' => 'tokenId = :btokenid',
'...
