loc adlı üyeden alıntı:
mesajı görüntüle
Unknown column 'city' in 'field list'
14
●876
- 01-09-2016, 18:22:55ben üye ol kısmına tıklıyorum o zaman register.php içinde mi çalışıyor bu sorgu öyleyse eğer o kısım ülke ile resim yükle arasında geçiyor o kısımda geçen kodlar bunlarloc adlı üyeden alıntı: mesajı görüntüle
<tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=COUNTRY?></td> <td style="padding:5px"> <select name="idcountry"> <? $country = mysql_query("SELECT * FROM country ORDER BY ID ASC"); while($cou = mysql_fetch_array($country)) { ?> <option value="<?=$cou[ID]?>"><?=$cou[name]?></option> <? } ?> </select> </tr> <tr>eğer burası değilse söylediğin için nereye bakmalıyım Anlayamıyorum sizi - 01-09-2016, 18:27:40hocam anlayamıyorum sizi ben işlemden kastınız nedir acaba standart üye ol denildiği zaman çıkan form en sonda da ok diyorsunuz olay bu burada sql hatası falan vermiyor sadece boş sayfa çıkıyor ve unknow diyor ama kastınız register.php ise buyrun değilse lütfen açıklayıcı olun Anlayamıyorum siziloc adlı üyeden alıntı: mesajı görüntüle
<? include("header.php"); ?> <table width="96%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr> <td width="220" valign="top" style="padding:8px; font-size:12px; background-color:#FFFFFF"> <div align="center"><a href="register.php"><img src="register.png" border="0"></a></div><br> » <a style="font-size:14px; font-weight:bold" href="index.php"><?=HOMEPAGE?></a><br> » <a style="font-size:14px; font-weight:bold" href="account.php"><?=ENTER_ACCOUNT_BUTTON?></a><br> » <a style="font-size:14px; font-weight:bold" href="mailto:<?=$admin_detail[admin_email]?>"><?=CONTACT_US?></a> </td> <td valign="top"> <? if(isset($_POST[addprof])) { $err = array(); if($_POST[username] == "") $err[username] = "<span style=\"color:red; font-size:10px\">".USERNAME_IS_REQUIRED."</span>"; elseif($_POST[username] != "") { $check_user = mysql_num_rows(mysql_query("SELECT * FROM members WHERE username='$_POST[username]'")); if($check_user > 0) $err[username] = "<span style=\"color:red; font-size:10px\">".USERNAME_ALREADY_REG."</span>"; } if($_POST[password] == "") $err[password] = "<span style=\"color:red; font-size:10px\">".PASSWORD_REQ."</span>"; if($_POST[first_name] == "") $err[first_name] = "<span style=\"color:red; font-size:10px\">".FIRST_NAME_REQ."</span>"; if($_POST[last_name] == "") $err[last_name] = "<span style=\"color:red; font-size:10px\">".LAST_NAME_REQ."</span>"; if($_POST[email] == "") $err[email] = "<span style=\"color:red; font-size:10px\">".EMAIL_REQ."</span>"; if($_FILES['image']['name'] == "") $err[photo] = "<span style=\"color:red; font-size:10px\">".PHOTO_REQ."</span>"; elseif(str_replace("[^a-zA-Z0-9-_\.]","_",$_FILES['image']['name']) == "") $err[photo] = "<span style=\"color:red; font-size:10px\">".PHOTO_REQ."</span>"; elseif(!eregi("jpeg|jpg|gif|png",$_FILES[image][type])) $err[photo] = "<span style=\"color:red; font-size:10px\">".FILETYPE_NOT_ALLOWED."</span>"; if(count($err) == 0) { $username = cleanVar($_POST[username]); $password = cleanVar($_POST[password]); $first_name = cleanVar($_POST[first_name]); $last_name = cleanVar($_POST[last_name]); $email = cleanVar($_POST[email]); $mail_contact = cleanVar($_POST[mail_contact]); $filename = time()."_".str_replace("[^a-zA-Z0-9-_\.]","_",$_FILES['image']['name']); $filetmp = $_FILES['image']['tmp_name']; $filesize = $_FILES['image']['size']; $filetype = $_FILES['image']['type']; $size = getimagesize($filetmp); ImageResize($filename,$filetmp,$filetype,"300"); $code = get_rand_num(10); $sql = "INSERT INTO `members` (`username` , `password` , `first_name` , `last_name` , `***` , `born_year` , `height` , "; $sql .= "`people_give` , `email` , `mail_contact` ,`mail_comment` , `idcountry` , `image` , `code` , `state` , `state_email` , `datareg`) "; $sql .= "VALUES ( '$username', '$password', '$first_name', '$last_name',"; $sql .= "'$_POST[***]', '$_POST[born_year]', '$_POST[height]', '$_POST[people_give]', '$email', '$mail_contact', '$_POST[mail_comment]','$_POST[idcountry]',"; $sql .= "'$filename', '$code', '0', '0', '".date("Y-m-d",time())."')"; mysql_query($sql) or die(mysql_error()); $msg = "Hi $_POST[first_name],<br>thanks for your registration and welcome in ".$admin_detail[sitename]." Community<br>"; $msg .= "These are you Registration details that you need to access your Member Page:<br>Username: $_POST[username]<br>Password: $_POST[password]<br>Code: $code<br><br>"; $msg .= "The Registration code is very important cause you need of it to send message to other members.<br><br>"; $msg .= "Please confirm your email by clicking on the link below:<br>"; $msg .= "<a href=\"".$admin_detail[siteurl]."/confirm.php?code=$code&email=$_POST[email]\">".$admin_detail[siteurl]."/confirm.php?code=$code&email=$_POST[email]</a><br><br>"; $msg .= "Thanks to use ".$admin_detail[sitename]." Community<br>".$admin_detail[siteurl]; //print nl2br($msg); $header = "Content-Type: text/html; charset=iso-8859-1\n"; $header .= "From: ".$admin_detail[sitename]."<".$admin_detail[admin_email].">"; @mail("$_POST[email]","Confirm Registration on ".$admin_detail[sitename]."!","$msg",$header); @mail($admin_detail[admin_email],"Confirm Registration on ".$admin_detail[sitename]."!","$msg",$header); ?> <div align="center" style="font-family:Verdana, Arial, Helvetica, sans-serif; font-size:12px; color:#003366"> <?=REG_MAIL_001?> <?=$admin_detail[sitename]?>!<br> <?=REG_MAIL_002?>.<br><br> <span style="color:#FF0000"><strong><?=ATTENTION_PLEASE?>:</strong><BR> <?=REG_MAIL_003?>.</span> </div> <? exit(); } } ?> </td> <td> <div align="center" style="padding:5px"><?=ATTENTION_MSG_REGISTER?> <strong><?=$admin_detail[sitename]?></strong> <?=ATTENTION_MSG_REGISTER_02?> </div> <form action="register.php" method="post" enctype="multipart/form-data"> <table width="680" border="0" cellspacing="0" cellpadding="0" style="background-color:#C9C994" align="center"> <tr><th colspan="2" style="background-color:#696934; color:#FFFFFF; height:24px"><?=REGISTER_PROFILE?></th></tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=USERNAME?> (*)</td> <td style="padding:5px"><input type="text" name="username" size="20" value="<?=$_POST[username]?>"> <? echo ($err[username] != "")?"<br>$err[username]":""; ?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=PASSWORD?> (*)</td> <td style="padding:5px"><input type="password" name="password" size="20" value="<?=$_POST[password]?>"> <? echo ($err[password] != "")?"<br>$err[password]":""; ?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=FIRST_NAME?> (*)</td> <td style="padding:5px"><input type="text" name="first_name" size="20" value="<?=$_POST[first_name]?>"> <? echo ($err[first_name] != "")?"<br>$err[first_name]":""; ?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=LAST_NAME?> (*)</td> <td style="padding:5px"><input type="text" name="last_name" size="20" value="<?=$_POST[last_name]?>"> <em>(<?=NOT_SHOWN?>)</em> <? echo ($err[last_name] != "")?"<br>$err[last_name]":""; ?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=***?> (*)</td> <td style="padding:5px"> <select name="***"> <option value="M"> <?=MALE?> </option> <option value="W" selected> <?=FEMALE?> </option> </select> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=BORN_YEAR?> (*)</td> <td style="padding:5px"> <select name="born_year"> <? $old_year = date("Y",time())-100; $you_year = date("Y",time())-10; for($j=$you_year;$j>$old_year;$j--) { $sel = ($j == "1980")?"selected":""; ?> <option value="<?=$j?>" <?=$sel?>><?=$j?></option> <? } ?> </select> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=HEIGHT?> (*)</td> <td style="padding:5px"> <select name="height"> <? for($j=100;$j<220;$j++) { $sel = ($j == "160")?"selected":""; ?> <option value="<?=$j?>" <?=$sel?>><?=$j?></option> <? } ?> </select> cm. </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=PEOPLE_GIVE_YOU?>...</td> <td style="padding:5px"> <input type="radio" name="people_give" value="0" checked> <?=LESS_AGE?> <input type="radio" name="people_give" value="1"> <?=MORE_AGE?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=EMAIL?> (*)</td> <td style="padding:5px"><input type="text" name="email" size="35" value="<?=$_POST[email]?>"> <? echo ($err[email] != "")?"<br>$err[email]":""; ?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold" colspan="2"><?=WANNA_BE_CONTACTED?>? (*)<br><span style="font-size:10px; font-weight:100"><em>(<?=WANNA_BE_CONTACTED_SUBTITLE?>)</em></span></td> </tr> <tr> <td style="padding:5px" colspan="2"> <input type="radio" name="mail_contact" value="0" checked> <?=WANT_CONTACT_NO?><br> <input type="radio" name="mail_contact" value="1"> <?=WANT_CONTACT_YES?>! </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold" colspan="2"><?=COMMENT_NOTICE?>? (*)</td> </tr> <tr> <td style="padding:5px" colspan="2"> <input type="radio" name="mail_comment" value="0"> no <input type="radio" name="mail_comment" value="1" checked> <?=YES?> </td> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=COUNTRY?></td> <td style="padding:5px"> <select name="idcountry"> <? $country = mysql_query("SELECT * FROM country ORDER BY ID ASC"); while($cou = mysql_fetch_array($country)) { ?> <option value="<?=$cou[ID]?>"><?=$cou[name]?></option> <? } ?> </select> </tr> <tr> <td style="padding:5px; color:#3F3F1F; font-weight:bold"><?=PHOTO?> (*)</td> <td style="padding:5px"><input type="file" name="image" size="30"> <? echo ($err[photo] != "")?"<br>$err[photo]":""; ?> </td> </tr> <tr> <td colspan="2" style="height:30px;"><em>(*) <?=FIELDS_REQUIRED?></em></td> <tr> <tr> <td colspan="2" style="height:30px; padding:6px"> <input type="checkbox" name="terms" value="1" checked><?=PRIVACY_MSG_001?> <strong><?=$admin_detail[sitename]?></strong> <?=PRIVACY_MSG_002?>.<br> </td> <tr> <td colspan="2" style="height:50px; text-align:center"> <input type="submit" value="<?=ADD_MY_PROFILE?>" name="addprof"> </td> </tr> </table> </form> <br><br><br> </td> </table> <? function ImageResize($imagename,$imagetemp,$imagetype,$width) { $imagedir = "./photos/"; $thumbdir = "./thumbs/"; switch($imagetype) { case 'image/jpeg': case 'image/pjpeg': $orig = imagecreatefromjpeg("$imagetemp") or die(PROBLEM_OPEN_SOURCE_IMAGE.":".$imagename); break; case 'image/png': $orig = imagecreatefrompng("$imagetemp") or die(PROBLEM_OPEN_SOURCE_IMAGE.":".$imagename); break; case 'image/gif': $orig = imagecreatefromgif("$imagetemp") or die(PROBLEM_OPEN_SOURCE_IMAGE.":".$imagename); break; default: $error = UNKNOWN_FORMAT; $show = ERROR; } $i_orig_x = imagesx($orig); $i_orig_y = imagesy($orig); $i_thumb_x = "$width"; $i_thumb_y = round(($i_orig_y * $i_thumb_x) / $i_orig_x); $thumb_i = imagecreatetruecolor($i_thumb_x, $i_thumb_y); imagecopyresampled($thumb_i, $orig, 0, 0, 0, 0, $i_thumb_x, $i_thumb_y, $i_orig_x, $i_orig_y); imagejpeg($thumb_i, $imagedir . "$imagename") or die('Failed!');; $orig_x = imagesx($orig); $orig_y = imagesy($orig); $thumb_x = "180"; $thumb_y = round(($orig_y * $thumb_x) / $orig_x); $thumb = imagecreatetruecolor($thumb_x, $thumb_y); imagecopyresampled($thumb, $orig, 0, 0, 0, 0, $thumb_x, $thumb_y, $orig_x, $orig_y); imagejpeg($thumb, $thumbdir . "$imagename") or die('Failed!');; } function get_rand_num($length) { if($length>0) { $rand_id=""; for($i=1; $i<=$length; $i++) { mt_srand((double)microtime() * 1000000); $num = mt_rand(1,36); $rand_id .= assign_rand_value($num); } } return strtoupper($rand_id); } function assign_rand_value($num) { switch($num) { case "1": $rand_value = "a"; break; case "2": $rand_value = "b"; break; case "3": $rand_value = "c"; break; case "4": $rand_value = "d"; break; case "5": $rand_value = "e"; break; case "6": $rand_value = "f"; break; case "7": $rand_value = "g"; break; case "8": $rand_value = "h"; break; case "9": $rand_value = "i"; break; case "10": $rand_value = "j"; break; case "11": $rand_value = "k"; break; case "12": $rand_value = "l"; break; case "13": $rand_value = "m"; break; case "14": $rand_value = "n"; break; case "15": $rand_value = "o"; break; case "16": $rand_value = "p"; break; case "17": $rand_value = "q"; break; case "18": $rand_value = "r"; break; case "19": $rand_value = "s"; break; case "20": $rand_value = "t"; break; case "21": $rand_value = "u"; break; case "22": $rand_value = "v"; break; case "23": $rand_value = "w"; break; case "24": $rand_value = "x"; break; case "25": $rand_value = "y"; break; case "26": $rand_value = "z"; break; case "27": $rand_value = "0"; break; case "28": $rand_value = "1"; break; case "29": $rand_value = "2"; break; case "30": $rand_value = "3"; break; case "31": $rand_value = "4"; break; case "32": $rand_value = "5"; break; case "33": $rand_value = "6"; break; case "34": $rand_value = "7"; break; case "35": $rand_value = "8"; break; case "36": $rand_value = "9"; break; } return $rand_value; } function cleanVar($str) { if(is_numeric($str)) return $str; else { if(get_magic_quotes_gpc()) { $str = stripslashes($str); if(function_exists('mysql_real_escape_string')) return mysql_real_escape_string($str); elseif(function_exists('mysql_escape_string')) return mysql_escape_string($str); else return addslashes($str); } // end magic } // end numeric } // end function ?> <? include("footer.php"); ?> - 02-09-2016, 07:58:07Sorun çözüldü yardımcı olan herkese teşekkür ederim çözüm şekli ilk mesaja eklenmiştir.
