Click here to Skip to main content
15,886,362 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
Questioni have this errors in my project please i need help Pin
frank saki24-Mar-21 11:55
frank saki24-Mar-21 11:55 
AnswerRe: i have this errors in my project please i need help Pin
Richard Deeming24-Mar-21 22:12
mveRichard Deeming24-Mar-21 22:12 
QuestionHow can I echo the numbers using list() function in foreach loop? Pin
Best Tutor24-Feb-21 9:33
Best Tutor24-Feb-21 9:33 
QuestionRe: How can I echo the numbers using list() function in foreach loop? Pin
Richard MacCutchan24-Feb-21 21:56
mveRichard MacCutchan24-Feb-21 21:56 
QuestionHow to import csv using php code Pin
Mohammed Hudair16-Feb-21 6:24
Mohammed Hudair16-Feb-21 6:24 
QuestionHow to code login page in html css php Pin
Member 150661826-Feb-21 1:01
Member 150661826-Feb-21 1:01 
AnswerRe: How to code login page in html css php Pin
Richard MacCutchan6-Feb-21 1:27
mveRichard MacCutchan6-Feb-21 1:27 
QuestionPosting dropdown value to database Pin
Member 1505550825-Jan-21 2:27
Member 1505550825-Jan-21 2:27 
Hello.

First of all, i want to apologize for my question, since the code im about to post is way outdated.

I am hosting this script on a server which is running a very old version of php.

The website is used by me and 2 other friends, and we are the only ones able to connect to it, due to .htaccess only showing the page to recognized ip adresses.. So there is no need to protect against sql injection or anything.

Now that thats out of the way, here is the problem i am facing:

i have a php script, which is showing a dropdown menu, with values gathered from a mysql table called chat_clothes.

I then have a submit button, that is supposed to post whatever you have chosen in the dropdown menu, to another table called chat_brugere

But when i click the submit button, it posts "Resource id #7", instead of the selected value.

Here is my code:

PHP
<?php
@session_start();
header('Content-Type: text/html; charset=ISO-8859-1');
include('includes/config.php');
?>
		<link rel="stylesheet" type="text/css" href="css/chat.css" />
<div id="sidebar_header">Garderobe</div>
<div id="sidebar_content">
	<p style="display: inline;">Skid i havet.</p><br /><br />
	<select name="sko">
<?php

	if(isset($_SESSION['logget_ind']) && $_SESSION['logget_ind'] == true) {
		$getSko = mysql_query("SELECT `navn` FROM `chat_clothes` WHERE `ejer` = '".$_SESSION['brugernavn']."' AND `type` = 'sko'");

		
		while ($showSko = mysql_fetch_array($getSko)) {
			echo '<option id="sko" name="sko" style="width: 300px;">'.$showSko['navn'].'</option><br />'
			;
			}
	}
?>

</div>

			</select>
<?php
	if (isset($_POST['sko'])) {
		

						mysql_query("UPDATE chat_brugere SET shoes='".$getSko."' WHERE id='".$_SESSION['id']."'");

						echo 'sko er opdateret!';
				} else {
					echo '';
				}
			
			echo '
			<form action="nygad.php" method="POST">

				<div>
					<table>
					
						<tr>
							<td><center><input type="submit" name="sko" value="Opdater!" /></center></td>
						</tr>
					</table>
				</div>
			</form>
			';
		?>

AnswerRe: Posting dropdown value to database Pin
Richard Deeming25-Jan-21 4:04
mveRichard Deeming25-Jan-21 4:04 
GeneralRe: Posting dropdown value to database Pin
Member 1505550825-Jan-21 6:31
Member 1505550825-Jan-21 6:31 
GeneralRe: Posting dropdown value to database Pin
Richard Deeming25-Jan-21 21:28
mveRichard Deeming25-Jan-21 21:28 
GeneralRe: Posting dropdown value to database Pin
Member 1505550825-Jan-21 21:57
Member 1505550825-Jan-21 21:57 
GeneralRe: Posting dropdown value to database Pin
Richard Deeming25-Jan-21 22:36
mveRichard Deeming25-Jan-21 22:36 
GeneralRe: Posting dropdown value to database Pin
Member 1505550825-Jan-21 22:58
Member 1505550825-Jan-21 22:58 
GeneralRe: Posting dropdown value to database Pin
Richard Deeming26-Jan-21 2:10
mveRichard Deeming26-Jan-21 2:10 
GeneralRe: Posting dropdown value to database Pin
Member 1505550826-Jan-21 3:27
Member 1505550826-Jan-21 3:27 
GeneralRe: Posting dropdown value to database Pin
jsc4226-Jan-21 3:40
professionaljsc4226-Jan-21 3:40 
GeneralRe: Posting dropdown value to database Pin
Richard Deeming26-Jan-21 3:44
mveRichard Deeming26-Jan-21 3:44 
QuestionHTML Form...Submit to E-Mail Pin
Member 149874928-Nov-20 20:04
Member 149874928-Nov-20 20:04 
QuestionCan't import pfx. Pin
ArturNoubel3-Nov-20 8:27
ArturNoubel3-Nov-20 8:27 
AnswerRe: Can't import pfx. Pin
Richard MacCutchan2-Nov-20 3:18
mveRichard MacCutchan2-Nov-20 3:18 
GeneralRe: Can't import pfx. Pin
ArturNoubel3-Nov-20 7:54
ArturNoubel3-Nov-20 7:54 
QuestionEquation of the third degree Pin
Member 1496562714-Oct-20 14:50
Member 1496562714-Oct-20 14:50 
AnswerRe: Equation of the third degree Pin
Richard MacCutchan14-Oct-20 22:37
mveRichard MacCutchan14-Oct-20 22:37 
AnswerRe: Equation of the third degree Pin
ZurdoDev15-Oct-20 1:17
professionalZurdoDev15-Oct-20 1:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.