I am not a programmer, just putting bits and pieces I've found on the net. I am missing something here, can you help?
The "publishcityonline" checkbox is not sending the required 0 or 1 to mysql database. It shows up when the form requests the info, just not when I add or edit. I guess the 0 could be null if that helps.
If you need more info, don't hesitate to ask. -
<html>
-
<body>
-
<p> click on name to display information for editing.<br>
-
at bottom of page, fill in form and click enter information to submit new information.<br>
-
click delete to delete record, be careful, there is no un-delete.
-
-
<?php
-
include("header1.php");
-
-
if ($submit) {
-
// here if no ID then adding else we're editing
-
-
if ($id) {
-
$sql = "UPDATE member SET
-
EXPIRE='$EXPIRE',FIRSTNAME='$FIRSTNAME',LASTNAME='$LASTNAME',ADDRESS='$ADDRESS',PUBLISHCITYONLINE='
-
-
$PUBLISHCITYONLINE'
-
WHERE id=$id";
-
}
-
else {
-
$sql = "INSERT INTO member (EXPIRE,FIRSTNAME,LASTNAME,ADDRESS,PUBLISHCITYONLINE) VALUES
-
-
('$EXPIRE','$FIRSTNAME','$LASTNAME','$ADDRESS','$PUBLISHCITYONLINE')";
-
}
-
-
// run SQL against the DB
-
-
$result = mysql_query($sql);
-
echo "Record updated/edited!<p>";
-
} elseif ($delete) {
-
-
// delete a record
-
-
$sql = "DELETE FROM member 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 member order by LASTNAME",$db);
-
while ($myrow = mysql_fetch_array($result)) {
-
printf("<a href=\"%s?id=%s\">%s, %s</a> \n", $PHP_SELF, $myrow[0],$myrow[3], $myrow[2]);
-
printf("<a href=\"%s?id=%s&delete=yes\"> (Delete)</a><br>", $PHP_SELF, $myrow[0]);
-
}
-
}
-
?>
-
<P>
-
<!-- This part does not work: -->
-
<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 member WHERE id=$id";
-
$result = mysql_query($sql);
-
$myrow = mysql_fetch_array($result);
-
$id = $myrow[0];
-
$EXPIRE=$myrow[1];
-
$FIRSTNAME=$myrow[2];
-
$LASTNAME=$myrow[3];
-
$ADDRESS=$myrow[4];
-
$PUBLISHCITYONLINE=$myrow[30];
-
-
// print the id for editing
-
-
?>
-
<input type=hidden name="id" value="<?php echo $id ?>">
-
<?php
-
}
-
?>
-
-
Chapter Expiration Date:<input type="Text" name="EXPIRE" value="<?php echo $EXPIRE ?>"><br>
-
FIRSTNAME:<input type="Text" name="FIRSTNAME" value="<?php echo $FIRSTNAME ?>"><br>
-
LASTNAME:<input type="Text" name="LASTNAME" value="<?php echo $LASTNAME ?>"><br>
-
-
ADDRESS:<input type="Text" name="ADDRESS" value="<?php echo $ADDRESS ?>"><br>
-
-
PUBLISH CITY ONLINE:
-
<input type="checkbox" name="PUBLISHCITYONLINE" value="<?PHP if($PUBLISHCITYONLINE =="1") { echo "checked"; } ?>"><br>
-
-
<input type="Submit" name="submit" value="Enter information">
-
</form>
-
-
<?php
-
}
-
?>
-
<p> if no id we are adding, if id, then we're editing. submit.</p>
-
<P> <a href=display29.php>display29</a><br>
-
-
</body>
-
</html>
8  2366 
Heya, Nick. Welcome to TSDN!
For your protection, I have removed your email address from your post text.
Please use CODE tags when posting source code:
[CODE=php]
PHP code goes here.
[/code]
Try using $_SERVER['PHP_SELF']. You may be working on a system that has register_globals turned off.
That didn't work.
Received error
404 File Not Found
The requested url /404.shtml was not found on this server.
Nick
I'm thinking I need some kind of
if isset[$PUBLISHCITYONLINE ==checkbox, checked then $PUBLISHCITYONLINE ==1 else $PUBLISHCITYONLINE ==0
I'm just not sure on the syntax and where it should go.
Try this: -
<input type="checkbox" name="PUBLISHCITYONLINE" value="1" <?PHP if($PUBLISHCITYONLINE =="1") { echo "checked"; } ?>>
-
The value field is passed iff the box is checked. The way you had it, if the value of the field was "1" then you were changing the value to "checked".
It's highly inadvisable to rely on register globals to be on. You should access the data through the post array, like this: -
<input type="checkbox" name="PUBLISHCITYONLINE" value="1" <?PHP if($_POST['PUBLISHCITYONLINE'] =="1") { echo "checked"; } ?>>
-
Though, if you do that change, you'll need to substantially rework this script. Doing so will, however, remove the SQL injection attack that your code is now easily subject to.
Thank you very much. Been on this most of the day.
Found the script at webmonkey.com, without the checkboxes.
The script is within a password protected directory. I hope this is secure enough that we will not sustain a sql attack or loose members names and addresses.
The ideal script would allow members to access and update their own information by entering key info only they know. Membership managers would be able to add, edit, and delete any or all records.
If anyone has scripts already written, I'd be greatful if they would share them.
Thanks again
Nick
Well, you're trusting all your members to never have their password compromised and to never try and hack you. Call me cynical, but I don't offer such trust to anyone.
It could help a bit to add extract($_POST) above all of your processing as that will replace variables set via the $_POST array that could be otherwise overwritten, but people can edit which fields are posted fairly easily.
I just thought of a slightly better quick-fix. AFTER you have connected to your database and BEFORE you use any of the POST variables, insert this code: -
foreach ($_POST as $name=>$value) {
-
$_POST[$name] = mysql_real_escape_string(stripslashes($value));
-
}
-
extract ($_POST);
-
I tried it and now it doesn't display the member list, just ",delete" for each id.
If I use seperate pages for display all, edit, and add, I think your code will work ok.
As allways with me, any and all comments are welcome.
Thanks again, I really appreciate your help.
Nick
Heya, Nick.
When a form contains checkboxes, only the checked boxes will be submitted.
You may want to try something like this: -
echo '<input type="checkbox" name="delete[', $row['id'], ']" /> Delete';
-
Which will give you something that looks like this: -
<input type="checkbox" name="delete[2]" /> Delete
-
<input type="checkbox" name="delete[3]" /> Delete
-
and so on.
Now let's pretend that the User checks the 'delete[3]' checkbox, but not the 'delete[2]' checkbox. When the User submits the form, here's what $_POST looks like: -
array
-
(
-
'delete' =>
-
array
-
(
-
3 => 'on'
-
),
-
.
-
.
-
.
-
);
-
Note that only the checked box showed up in $_POST, which makes checking to see if you need to delete anything fairly simple: -
if( ! empty($_POST['delete']) )
-
{
-
foreach( $_POST['delete'] as $_id => $_on )
-
{
-
// Delete record # $_id.
-
}
-
}
-
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Bill |
last post by:
I have a catalog of books which need to be categorized into different
groups. Some of the books can be listed under more than one category.
I'm creating a page where I can assign a group of books...
|
by: Jack |
last post by:
Hi, I have a checkbox the value which goes to a database via a asp page that
builds the sql string.
In the front end asp page, the checkbox code is written as follows:
<i><input...
|
by: mike7510uk |
last post by:
Hi, I am using a gridview with a templatefield containing a checkbox.
I want to update the database with a 1 or 0 depending on if a checkbox
is checked or unchecked (then use the 1 or 0 later on...
|
by: shobu |
last post by:
passing array checkbox value and update the database <?include 'dbconnect.php'; error_reporting(0);$update_qr="update...
|
by: delram |
last post by:
I'm trying to get user selections (using checkboxes) on one JSP page(A.jsp) and pass them on to another page.
So I have one page with a list of dynamically populated items like this
1
2 ...
|
by: cyberdawg999 |
last post by:
Greetings all in ASP land
I have overcome one obstacle that took me 2 weeks to overcome and I
did it!!!!!
I am so elated!! thank you to all who invested their time and energy towards helping me...
|
by: manjunath1985 |
last post by:
Hi,
I am really having problem in checkbox....
i have a php page which displays the username retrieved from the database i want to create a checkbox for each username and pass the selected...
|
by: Archanak |
last post by:
Hi,
Any limits exists while passing values of checkbox to another program?
Here is the code:
<script type="text/javascript">
function valuate()
{
|
by: mukeshrasm |
last post by:
Hi
I want to update records in database based on selected records using checkbox. if user does not select a record and clicks update button it should show the message please select record to be...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
