jack12345
-
Posts
7 -
Joined
-
Last visited
Never
Posts posted by jack12345
-
-
Ok. I'll explain. I have a drop down box the one where i chose listassignement. There i have several ships listed. Say USS Jackson
USS Viking
USS Delaware
so when i select in the list let's say USS Viking in the database it gets's added <a href="http://felixsavali.awardspace.com/table.php">USS Viking</a> or if i select USS Jackson it gets added <a href="http://test.freserver.org/Jackson.php">USS Jackson</a> -
Ok i've tried that and now i get always the same url no matter what option i select from the drop down box and i need the url to be different for each option. And thnx for taking your time to help me out.
-
No, it is $listassignement.
-
Ok here is the whole code of the form.
[code]<html>
<body>
<?php
$db = mysql_connect("localhost", "dbuser", "dbpass");
mysql_select_db("dbname",$db);
if ($submit) {
// here if no ID then adding else we're editing
if ($id) {
$sql = "UPDATE profile SET name='$name',listassignement='$listassignement',listposition='$listposition',rank_image='$rank_image', medal_image='$medal_image', rank='$rank', species='$species', birthplace='$birthplace', current_posting='$current_posting', qualification='$qualification', age='$age', sex='$sex', dob='$dob', appearance='$appearance',history='$history', background='$background', service_record='$service_record', commendations='$commendations', reprimands='$reprimands', med_record='$med_record', interests='$interests', added_notes='$added_notes', picture='$picture' WHERE id=$id";
} else {
$sql = "INSERT INTO profile (name,listassignement,listposition,rank_image,medal_image,rank,species,birthplace,current_posting,qualification,age,sex,dob,appearance,history,background,service_record,commendations,reprimands,med_record,interests,added_notes,picture) VALUES ('$name','$listassignement','$listposition','$rank_image','$medal_image','$rank','$species','$birthplace','$current_posting','$qualification','$age','$sex','$dob','$appearance','$history','$background','$service_record','$commendations','$reprimands','$med_record','$interests','$added_notes','$picture')";
}
// run SQL against the DB
$result = mysql_query($sql) or die(mysql_error());
echo "Record updated/edited!<p>";
} elseif ($delete) {
// delete a record
$sql = "DELETE FROM profile WHERE id=$id";
$result = mysql_query($sql);
echo "$sql Record deleted!<p>";
} else {
// this part happens if we don't press submit
if (!$id) {
// print the list if there is not editing
$result = mysql_query("SELECT * FROM profile",$db);
while ($myrow = mysql_fetch_array($result)) {
printf("<a href=\"%s?id=%s\">%s %s</a> \n", $PHP_SELF, $myrow["id"], $myrow["name"], $myrow["rank"]);
printf("<a href=\"%s?id=%s&delete=yes\">(DELETE)</a><br>", $PHP_SELF, $myrow["id"]);
}
}
?>
<P>
<a href="<?php echo $PHP_SELF?>">ADD A RECORD</a>
<P>
<form method="post" action="<?php echo $PHP_SELF?>">
<?php
if ($id) {
// editing so select a record
$sql = "SELECT * FROM profile WHERE id=$id";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$id = $myrow["id"];
$name = $myrow["name"];
$listassignement = $myrow["listassignement"];
$listposition = $myrow["listposition"];
$rank_image = $myrow["rank_image"];
$medal_image = $myrow["medal_image"];
$rank = $myrow["rank"];
$species = $myrow["species"];
$birthplace = $myrow["birthplace"];
$current_posting = $myrow["current_posting"];
$qualification = $myrow["qualification"];
$age = $myrow["age"];
$sex = $myrow["sex"];
$dob = $myrow["dob"];
$appearance = $myrow["appearance"];
$history = $myrow["history"];
$background = $myrow["background"];
$service_record = $myrow["service_record"];
$commendations = $myrow["commendations"];
$reprimands = $myrow["reprimands"];
$med_record = $myrow["med_record"];
$interests = $myrow["interests"];
$added_notes = $myrow["added_notes"];
$picture = $myrow["picture"];
// print the id for editing
?>
<input type=hidden name="id" value="<?php echo $id ?>">
<?php
}
?>
Character Name:<br><br><input type="Text" name="name" value="<?php echo $name ?>"><br><br>
Assignement for the positions page(a link to the ship or base on which he is serving):
<br><br>
<select name="listassignement">
<?php
$options = array('USS Jackson', 'USS Viking', 'USS Delaware', 'USS Big Foot', 'USS Jody', 'USS Ana', 'USS Ivana');
foreach ($options as $option) {
$isSelected = $option == $listassignement ? ' selected' : '';
print "<option$isSelected>$option</option>\n";
}
?>
</select>
<br><br>
Position for the positions page, use an abrevation, consult the position page for the abrevations<br><br>
<select name="listposition">
<?php
$options = array('', 'CO', 'FO', 'CTSO', 'SMO', 'CEO', 'COO', 'CNO', 'CScO', 'CMO', 'CNS', 'EXO', 'MLT', 'CTO', 'CSO', 'Tac', 'Sec', 'CIVIL', 'ORE', 'DCS', 'AMB', 'CSbS', 'CSbO', 'ECH', 'LiO', 'CSOO', 'CIO', 'AI', 'Cadet', 'CHO', 'TO', 'SO', 'FW', 'CCO', 'NS', 'CAO');
foreach ($options as $option) {
$isSelected = $option == $listposition ? ' selected' : '';
print "<option$isSelected>$option</option>\n";
}
?>
</select>
<br>
<br>
Rank Image(just enter the name of the rank image file something.jpg):<input type="Text" name="rank_image" value="<?php echo $rank_image ?>"><br>
Medal image(enter the html code to display the medal image):
<textarea name="medal_image" cols="80" rows="20"><?php echo $medal_image ?></textarea>
<br>
Rank name:<input type="Text" name="rank" value="<?php echo $rank?>"><br>
Species:<input type="Text" name="species" value="<?php echo $species ?>"><br>
Birthplace:<br>
<textarea name="birthplace" cols="80"><?php echo $birthplace ?></textarea>
<br>
Current Posting:<input type="Text" name="current_posting" value="<?php echo $current_posting ?>"><br>
Qualification:<br>
<textarea name="qualification" cols="80" rows="5"><?php echo $qualification ?></textarea>
<br>
Age:<input type="Text" name="age" value="<?php echo $age ?>"><br>
Sex:<input type="Text" name="sex" value="<?php echo $sex ?>"><br>
Date of Birth:<input type="Text" name="dob" value="<?php echo $dob ?>"><br>
Apperance:<br><textarea name="appearance" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $appearance ?></textarea>
<br>
History:<br><textarea name="history" cols="80" rows="20" wrap="VIRTUAL" ><?php echo $history ?></textarea>
<br>
Background:<br><textarea name="background" cols="80" rows="20" wrap="VIRTUAL" ><?php echo $background ?></textarea>
<br>
Service record, enter a (br at the end of each line):<br><textarea name="service_record" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $service_record ?></textarea>
<br>
Commendations(same as above):<br><textarea name="commendations" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $commendations ?></textarea>
<br>
Reprimands:<br><textarea name="reprimands" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $reprimands ?></textarea>
<br>
Medical Record:<br><textarea name="med_record" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $med_record ?></textarea>
<br>
Interests:<br><textarea name="interests" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $interests ?></textarea>
<br>
Additional Notes:<br><textarea name="added_notes" cols="60" rows="20" wrap="VIRTUAL" ><?php echo $added_notes ?></textarea>
<br>
Picture(just enter the image url):<br>
<textarea name="picture" cols="70" rows="2"><?php echo $picture ?></textarea>
<br>
<input type="Submit" name="submit" value="Enter information">
</form>
<?php
}
?>
</body>
</html>[/code] -
I'm not aure i understand the question exactly. But this drop down box. When i select an option from it and click add to database it get's added so i don't have a problem with it. It is a part of a form which works ok.
The problem is that i am not able to replace Irene, Jane, Jack ... which are in the array as they are they are not variables, with html code. So that when i select Jack in the database it get's added <a href="http://www.test.com/jack.html">Jack</a> So how do i replace those simple names in the array with html code. -
I have a small problem in regards to php/mysql. I have a drop down box/list on my form for entering data into a mysql database.
[code]<select>
<?php
$options = array('Jack', 'Jane', 'Irene', 'Marry', 'Jody', 'Ana', 'Ivana');
foreach ($options as $option) {
$isSelected = $option == $name ? ' selected' : '';
print "<option$isSelected>$option</option>\n";
}
?>
</select>[/code]
Now the problem is that instead of insertin Irene, Jane, Marry... into the database i'd like to insert html code in it. Example <a href="url">Irene</a> and something like that for every name. Now i can't seem to figure out how to use that instead of just the name. Any help would be appreciated.
php/mysql problem...
in PHP Coding Help
Posted
[code]<a href="http://felixsavali.awardspace.com/table.php">USS Viking</a>[/code]