Mixing
SQL unable to update in laravel controller
1
I'm having an issue with saving the current updated inputs into the database using this format.
This database was created to store typeform created values through zapier, but I wanted to make it editable.
Here's a snippet of the code in the blade.php
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="cilent_email" class="optional">Email</label>
<input type="text" name="cilent_email" id="cilent_email" value="{{$userProfile->cilent_email }}" class="form-control" autocomplete="off" placeholder="email">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_country" class="optional">Country</label>
@php $usercountry=explode(" - ",$userProfile->client_country); @endphp
<select name="client_country" id="client_country" value="{{$usercountry[1]}}" class="form-control " aria-required="true">
<option value="" selected="selected">{{$usercountry[1]}}</option>
@foreach ($countries as $country)
<option value="{{ $country->id }}" @if( $usercountry[1] == $country->id) selected @endif>{{ $country->country_name }}</option>
@endforeach
</select>
</div>
</div>
</div>
<div class="col-md-12 p0 ">
<div class=" form-group "><label for="client_accomplishment" class="optional">Accomplishments</label>
<input type="text" name="client_accomplishment" id="client_accomplishment" value="{{$userProfile->client_accomplishment }}" class="form-control" autocomplete="off" >
</div>
</div>
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="client_firstproj" class="optional">First Project Date</label>
<input type="date" name="client_firstproj" id="client_firstproj" value="{{$userProfile->client_first_project }}" class="form-control" autocomplete="off">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_totalproj" class="optional">Total Projects Completed</label>
<input type="text" name="client_totalproj" id="client_totalproj" value="{{$userProfile->client_total_project }}" class="form-control" autocomplete="off">
</div>
</div>
</div>
and this is from the controller
public function profileSave(Request $request, $id){
$userProfile= DB::table('user_profile')
->where('cilent_email',Auth::user()->email)
->first();
$userProfile->cilent_email = $request->cilent_email;
$userProfile->client_country = $request->client_country;
$userProfile->client_accomplishments = $request->client_accomplishments;
$userProfile->client_first_project = $request->client_firstproj;
$userProfile->client_total_project = $request->client_totalproj;
$userProfile->enjoy_design = $request->enjoy_design;
$userProfile->enjoy_manage = $request->enjoy_manage;
$userProfile->enjoy_style = $request->enjoy_style;
$user = User::find(Auth::user()->id);
$user->client_url = $request->client_url;
// dd($user);
if($request->skills)
{
foreach ($request->skills as $skill){
$skills.=$skill.';';
}
$userProfile->client_skills = "a:".count($request->skills).":{".$skills."}";
}
else{
$userProfile->client_skills = '';
}
$userProfile->save();
$user->save();
return redirect()->back()->with('message','Profile Settings Updated');
}
Such that when I submit the form with a newly updated input, the refreshed page would still return the same value as previously.
mysql laravel
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
add a comment |
1
I'm having an issue with saving the current updated inputs into the database using this format.
This database was created to store typeform created values through zapier, but I wanted to make it editable.
Here's a snippet of the code in the blade.php
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="cilent_email" class="optional">Email</label>
<input type="text" name="cilent_email" id="cilent_email" value="{{$userProfile->cilent_email }}" class="form-control" autocomplete="off" placeholder="email">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_country" class="optional">Country</label>
@php $usercountry=explode(" - ",$userProfile->client_country); @endphp
<select name="client_country" id="client_country" value="{{$usercountry[1]}}" class="form-control " aria-required="true">
<option value="" selected="selected">{{$usercountry[1]}}</option>
@foreach ($countries as $country)
<option value="{{ $country->id }}" @if( $usercountry[1] == $country->id) selected @endif>{{ $country->country_name }}</option>
@endforeach
</select>
</div>
</div>
</div>
<div class="col-md-12 p0 ">
<div class=" form-group "><label for="client_accomplishment" class="optional">Accomplishments</label>
<input type="text" name="client_accomplishment" id="client_accomplishment" value="{{$userProfile->client_accomplishment }}" class="form-control" autocomplete="off" >
</div>
</div>
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="client_firstproj" class="optional">First Project Date</label>
<input type="date" name="client_firstproj" id="client_firstproj" value="{{$userProfile->client_first_project }}" class="form-control" autocomplete="off">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_totalproj" class="optional">Total Projects Completed</label>
<input type="text" name="client_totalproj" id="client_totalproj" value="{{$userProfile->client_total_project }}" class="form-control" autocomplete="off">
</div>
</div>
</div>
and this is from the controller
public function profileSave(Request $request, $id){
$userProfile= DB::table('user_profile')
->where('cilent_email',Auth::user()->email)
->first();
$userProfile->cilent_email = $request->cilent_email;
$userProfile->client_country = $request->client_country;
$userProfile->client_accomplishments = $request->client_accomplishments;
$userProfile->client_first_project = $request->client_firstproj;
$userProfile->client_total_project = $request->client_totalproj;
$userProfile->enjoy_design = $request->enjoy_design;
$userProfile->enjoy_manage = $request->enjoy_manage;
$userProfile->enjoy_style = $request->enjoy_style;
$user = User::find(Auth::user()->id);
$user->client_url = $request->client_url;
// dd($user);
if($request->skills)
{
foreach ($request->skills as $skill){
$skills.=$skill.';';
}
$userProfile->client_skills = "a:".count($request->skills).":{".$skills."}";
}
else{
$userProfile->client_skills = '';
}
$userProfile->save();
$user->save();
return redirect()->back()->with('message','Profile Settings Updated');
}
Such that when I submit the form with a newly updated input, the refreshed page would still return the same value as previously.
mysql laravel
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
add a comment |
1
1
1
I'm having an issue with saving the current updated inputs into the database using this format.
This database was created to store typeform created values through zapier, but I wanted to make it editable.
Here's a snippet of the code in the blade.php
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="cilent_email" class="optional">Email</label>
<input type="text" name="cilent_email" id="cilent_email" value="{{$userProfile->cilent_email }}" class="form-control" autocomplete="off" placeholder="email">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_country" class="optional">Country</label>
@php $usercountry=explode(" - ",$userProfile->client_country); @endphp
<select name="client_country" id="client_country" value="{{$usercountry[1]}}" class="form-control " aria-required="true">
<option value="" selected="selected">{{$usercountry[1]}}</option>
@foreach ($countries as $country)
<option value="{{ $country->id }}" @if( $usercountry[1] == $country->id) selected @endif>{{ $country->country_name }}</option>
@endforeach
</select>
</div>
</div>
</div>
<div class="col-md-12 p0 ">
<div class=" form-group "><label for="client_accomplishment" class="optional">Accomplishments</label>
<input type="text" name="client_accomplishment" id="client_accomplishment" value="{{$userProfile->client_accomplishment }}" class="form-control" autocomplete="off" >
</div>
</div>
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="client_firstproj" class="optional">First Project Date</label>
<input type="date" name="client_firstproj" id="client_firstproj" value="{{$userProfile->client_first_project }}" class="form-control" autocomplete="off">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_totalproj" class="optional">Total Projects Completed</label>
<input type="text" name="client_totalproj" id="client_totalproj" value="{{$userProfile->client_total_project }}" class="form-control" autocomplete="off">
</div>
</div>
</div>
and this is from the controller
public function profileSave(Request $request, $id){
$userProfile= DB::table('user_profile')
->where('cilent_email',Auth::user()->email)
->first();
$userProfile->cilent_email = $request->cilent_email;
$userProfile->client_country = $request->client_country;
$userProfile->client_accomplishments = $request->client_accomplishments;
$userProfile->client_first_project = $request->client_firstproj;
$userProfile->client_total_project = $request->client_totalproj;
$userProfile->enjoy_design = $request->enjoy_design;
$userProfile->enjoy_manage = $request->enjoy_manage;
$userProfile->enjoy_style = $request->enjoy_style;
$user = User::find(Auth::user()->id);
$user->client_url = $request->client_url;
// dd($user);
if($request->skills)
{
foreach ($request->skills as $skill){
$skills.=$skill.';';
}
$userProfile->client_skills = "a:".count($request->skills).":{".$skills."}";
}
else{
$userProfile->client_skills = '';
}
$userProfile->save();
$user->save();
return redirect()->back()->with('message','Profile Settings Updated');
}
Such that when I submit the form with a newly updated input, the refreshed page would still return the same value as previously.
mysql laravel
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
I'm having an issue with saving the current updated inputs into the database using this format.
This database was created to store typeform created values through zapier, but I wanted to make it editable.
Here's a snippet of the code in the blade.php
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="cilent_email" class="optional">Email</label>
<input type="text" name="cilent_email" id="cilent_email" value="{{$userProfile->cilent_email }}" class="form-control" autocomplete="off" placeholder="email">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_country" class="optional">Country</label>
@php $usercountry=explode(" - ",$userProfile->client_country); @endphp
<select name="client_country" id="client_country" value="{{$usercountry[1]}}" class="form-control " aria-required="true">
<option value="" selected="selected">{{$usercountry[1]}}</option>
@foreach ($countries as $country)
<option value="{{ $country->id }}" @if( $usercountry[1] == $country->id) selected @endif>{{ $country->country_name }}</option>
@endforeach
</select>
</div>
</div>
</div>
<div class="col-md-12 p0 ">
<div class=" form-group "><label for="client_accomplishment" class="optional">Accomplishments</label>
<input type="text" name="client_accomplishment" id="client_accomplishment" value="{{$userProfile->client_accomplishment }}" class="form-control" autocomplete="off" >
</div>
</div>
<div class="col-md-12 p0 ">
<div class="col-md-6 PL0 p0_smresp">
<div class=" form-group "><label for="client_firstproj" class="optional">First Project Date</label>
<input type="date" name="client_firstproj" id="client_firstproj" value="{{$userProfile->client_first_project }}" class="form-control" autocomplete="off">
</div>
</div>
<div class="col-md-6 PR0 p0_smresp">
<div class=" form-group "><label for="client_totalproj" class="optional">Total Projects Completed</label>
<input type="text" name="client_totalproj" id="client_totalproj" value="{{$userProfile->client_total_project }}" class="form-control" autocomplete="off">
</div>
</div>
</div>
and this is from the controller
public function profileSave(Request $request, $id){
$userProfile= DB::table('user_profile')
->where('cilent_email',Auth::user()->email)
->first();
$userProfile->cilent_email = $request->cilent_email;
$userProfile->client_country = $request->client_country;
$userProfile->client_accomplishments = $request->client_accomplishments;
$userProfile->client_first_project = $request->client_firstproj;
$userProfile->client_total_project = $request->client_totalproj;
$userProfile->enjoy_design = $request->enjoy_design;
$userProfile->enjoy_manage = $request->enjoy_manage;
$userProfile->enjoy_style = $request->enjoy_style;
$user = User::find(Auth::user()->id);
$user->client_url = $request->client_url;
// dd($user);
if($request->skills)
{
foreach ($request->skills as $skill){
$skills.=$skill.';';
}
$userProfile->client_skills = "a:".count($request->skills).":{".$skills."}";
}
else{
$userProfile->client_skills = '';
}
$userProfile->save();
$user->save();
return redirect()->back()->with('message','Profile Settings Updated');
}
Such that when I submit the form with a newly updated input, the refreshed page would still return the same value as previously.
mysql laravel
mysql laravel
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
asked Nov 20 '18 at 7:22
MonomoniMonomoni
5319
5319
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
0
$id is return the old value. $input contains the updated value. and include use IlluminateSupportFacadesInput for Input::all()
$input = Input::all();
$id->update($input);
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
add a comment |
0
Use the userProfile model
$userProfile= UserProfile::where('cilent_email',Auth::user()->email)->first();
and instant of
return redirect()->back()->with('message','Profile Settings Updated');
use return redirect(url('your url'));
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53388086%2fsql-unable-to-update-in-laravel-controller%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
0
$id is return the old value. $input contains the updated value. and include use IlluminateSupportFacadesInput for Input::all()
$input = Input::all();
$id->update($input);
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
add a comment |
0
$id is return the old value. $input contains the updated value. and include use IlluminateSupportFacadesInput for Input::all()
$input = Input::all();
$id->update($input);
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
add a comment |
0
0
0
$id is return the old value. $input contains the updated value. and include use IlluminateSupportFacadesInput for Input::all()
$input = Input::all();
$id->update($input);
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
$id is return the old value. $input contains the updated value. and include use IlluminateSupportFacadesInput for Input::all()
$input = Input::all();
$id->update($input);
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
answered Nov 20 '18 at 7:32
Bhoomi patelBhoomi patel
416117
416117
add a comment |
add a comment |
0
Use the userProfile model
$userProfile= UserProfile::where('cilent_email',Auth::user()->email)->first();
and instant of
return redirect()->back()->with('message','Profile Settings Updated');
use return redirect(url('your url'));
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
add a comment |
0
Use the userProfile model
$userProfile= UserProfile::where('cilent_email',Auth::user()->email)->first();
and instant of
return redirect()->back()->with('message','Profile Settings Updated');
use return redirect(url('your url'));
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
add a comment |
0
0
0
Use the userProfile model
$userProfile= UserProfile::where('cilent_email',Auth::user()->email)->first();
and instant of
return redirect()->back()->with('message','Profile Settings Updated');
use return redirect(url('your url'));
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
Use the userProfile model
$userProfile= UserProfile::where('cilent_email',Auth::user()->email)->first();
and instant of
return redirect()->back()->with('message','Profile Settings Updated');
use return redirect(url('your url'));
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
answered Nov 20 '18 at 7:49
Tarun SainiTarun Saini
753
753
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53388086%2fsql-unable-to-update-in-laravel-controller%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
