php - Updating user table in database -



php - Updating user table in database -

i've created members area user can update bio. problem info user submits isn't updating rows in database.

member's area

<body bgcolor="#e6e6fa"> <a href="logout.php"><button>log out</button></a><br><br> <input type="text" name="age"placeholder="enter age."><br> <input type="text" name="bio"placeholder="enter bio."> <input type="submit" name="submit" value="submit details!">

php

<?php if(isset($_post['submit'])){ $con=mysql_connect("localhost","root","****","****"); // check connection if (mysql_errno()) { echo "failed connect mysql: " . mysqli_connect_error(); } $age = mysql_real_escape_string($_post['age']); $bio = mysql_real_escape_string($_post['bio']); $name = mysql_real_escape_string($_session['username']); mysql_query($con,"update accs set age='.$age.' name='.$name.'"); mysql_query($con,"update accs set bio='.$bio.' name='.$name.'"); mysql_close($con); }; ?> </body></html>

any ideas wrong here?

in html page, form should within <form></form> tags

<form method="post" action="update.php"> <input type="text" name="age" placeholder="enter age."> <br> <input type="text" name="bio" placeholder="enter bio."> <input type="submit" name="submit" value="submit details!"> </form>

in php page - check results, can temporarily echo $age; echo $bio; using $_session['username']; think missing session_start(); top of php code.

also mysql_query needs sql command, , not connection ($con), mysqli, advised utilize instead of mysql_*.

as side note, don't rely on user names in database update criteria. if not introduced, can add together id column table

php mysql phpmyadmin

Comments

Post a Comment

Popular posts from this blog

Php operator `break` doesn't stop while -

Php operator `break` doesn't stop while - have weird issue, break doesn't break while loop , maintain rotating. logically should break cycle , set output while ($c++ != 5) { // here curl request, doesn't relevant have removed preg_match("!<.*?>(\s*)[^<>]*?{$to}<!", $resp, $result) ; // echo 'cnt = ' .count($result).'<br>'; if(!count($result)) { $amount = 0; echo 'sleep called'; sleep(4); exit; continue; } else { $amount = trim(@$result[1]); $amount = round($amount + $amount * $exchange_ratio, $precision); echo 'break happen<br>'; break; } } so output cnt = 2 break happen cnt = 0 sleep called so skipped break , maintain rotating. how so? edit works fine on localhost issue php version? ...
Read more

ubuntu - Bash Script to Check That Files Are Being Created -

ubuntu - Bash Script to Check That Files Are Being Created - we have amazon ec2 instance upload output our security cameras. every , then, cameras have issue, stop uploaded, , need rebooted. easy way determine seeing if files not beingness created. problem creates lots , lots of files. if utilize find -ctime, takes long time script run. there faster way check see if files have been created since yesterday? need capture result, (yes there files, or not there not,) , email message, nice have didn't take half hr run. #!/bin/bash find /vol/security_ftp/west -ctime -1 find /vol/security_ftp/backentrance -ctime -1 find /vol/security_ftp/boardroomdoor -ctime -1 find /vol/security_ftp/mainentrance -ctime -1 find /vol/security_ftp/north -ctime -1 find /vol/security_ftp/south -ctime -1 using find natural solution, if must avoid it, can see newest file in directory using ls , sorting output according ctime, eg. ls /vol/security_ftp/west -clt | head --lines=1 ...
Read more

vim: Search & replace -

vim: Search & replace - i searching easy way search , replace things in vim "workaround" refactoring. on other stackoverflow-question found snippet of code: nnoremap gr gd:%s/<c-r>///gc<left><left><left> i thought gd selects current word under cursor in whole document , %s search , replaces matches after typed replace pattern. gc stands globally confirmation?! however: not work expected. illustration in python class of mine can easy rename occurencies of self in whole file not work on method identifieres or field identifieres length of one. def __init__(self): self.test = [] self.a = [] ... so self changed using snippet, doing gr on field a not work. how can work easy search , replace on 1 file? any tips on intelligent refactoring appreciated. after hours of searching found plugins , workarounds work c files, need @ to the lowest degree java, python , php compatibility. thanks every reply :) update: found...
Read more