The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> Validating 'required' form page data for save to database, Saving by php code file after succesful validation. Success message on
Freddz
post Jan 7 2019, 08:34 PM
Post #1


Novice
**

Group: Members
Posts: 25
Joined: 7-January 19
Member No.: 26,791



Hello,
I have a form page where I check the mandatory inputs client-sided by the attribute 'required' (when clicking send button).
When all required inputs are done the send button click...
1.) should call a php file 'dbinsert.php' which just contains the save process of the form data to a database.
2.) But the success message should be shown on the SAME page, on top of the form page.
How can I implement this process under those 2 conditions?

I suppose that the send button's 'action' attrbute should be empty and the php file has to be called via Ajax (within a Javascript function?) !?
But unfortunately I fail in implementing THIS specific configuration.

Could you help me, please?
If so, please specify in your answer all necessary code lines like the form header, the submit button and the Javascript function that executes the Ajax call (and also fires the success message, I suppose)?
Thank you so much!

The following constellation does not work:
* <FORM NAME="Betrugseingabe" ACTION="../cgi-bin/DBinsert.php" METHOD=POST>
* <INPUT TYPE="submit" NAME="Absenden" VALUE="Absenden" ID="Schaltflaeche1" formtarget="_self">
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
 
Reply to this topicStart new topic
Replies
Freddz
post Jan 21 2019, 06:52 AM
Post #2


Novice
**

Group: Members
Posts: 25
Joined: 7-January 19
Member No.: 26,791



Yes, I know that I have to edit the generated file afterwards to e.g. realise iFrame support. However, it is nerving to do that any time you modify this page.
That's why I am prefering a solution that forces manual modifications as less as possible.
So that's why I am currently concentrating on solution 4.

Unfortunately this doesn't work yet.
What I did:
I added an .htaccess file in the html folder with the line:
"AddType application/x-httpd-php .html .htm" and set in the /etc/apache2/apache2.conf file the AllowOverride option from 'none' to 'all':
<Directory /var/www/>
Options Indexes FollowSymLinks
AllowOverride All
Require all granted
</Directory>

But my test page of the isset function is still not working.
What I couldn't find yet:
1) A proof command if the above apache config file really is the right one. Cannot find an apache command for asking its config file to be totally sure.
2) Cannot find an apache proof command for asking its current override setting.
Points 1 and 2 for making sure that override is really working...
3) Maybe there is still a mistake at my page file!?... Therefore I copied it below to this message for you.
I would appreciate it if you could have a quick look...

Thank you so much for your continuous help !!!

Here is the isset page code:
++++++++++++++++++++++++++++++++++++++++++++++++
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
</HEAD>

<BODY NOF="(MB=(DefaultMasterBorder, 150, 51, 66, 0), L=(KontaktLayout, 849, 452))">
<DIV ID="LayoutLYR"><LAYER ID="LayoutLYR" TOP=0 LEFT=0 VISIBILITY=INHERIT WIDTH=915 HEIGHT=653 Z-INDEX=1><DIV ID="Text39LYR" CLASS="TextObject"><LAYER ID="Text39LYR" VISIBILITY=INHERIT TOP=190 LEFT=81 WIDTH=801 HEIGHT=38 Z-INDEX=1>
</LAYER></DIV><DIV ID="Tabelle4LYR" STYLE="background-color: rgb(217,217,217);"><LAYER ID="Tabelle4LYR" VISIBILITY=INHERIT TOP=249 LEFT=104 WIDTH=746 HEIGHT=272 Z-INDEX=2 bgcolor="#D9D9D9">
<FORM NAME="Tabelle4FORMULAR" METHOD=POST>

<?php
if(isset($_POST['Absenden']))
{
// put form handler script here
echo "Form was submitted (field data saved successfully)!...";
}
else
{
echo "Form was not submitted.";
}
?>

<TABLE ID="Tabelle4" BORDER=0 BGCOLOR="#D9D9D9" CELLSPACING=3 CELLPADDING=1 WIDTH="100%">
<TR>
<TD>
<P> </P>
</TD>
<TD WIDTH=136>
<P><B>Thema:</B></P>
</TD>
<TD WIDTH=253>
<P>
<SELECT ID="Auswahlfeld1" NAME="Auswahlfeld1" required>
<OPTION VALUE="" SELECTED>/ Thema wählen /</OPTION>
<OPTION VALUE="1">Option 1</OPTION>
<OPTION VALUE="2">Option 2</OPTION>
<OPTION VALUE="3">Option 3</OPTION>
<OPTION VALUE="4">Option 4</OPTION>
<OPTION VALUE="5">Option 5</OPTION>
</SELECT>
</P>
</TD>
<TD WIDTH=299>
</TR>
<TR>
<TD>
<P> </P>
</TD>
<TD>
<P> </P>
</TD>
<TD WIDTH=253>
<P STYLE="text-align: center;"><INPUT TYPE=SUBMIT NAME="Absenden" VALUE="Abschicken" ID="Schaltflaeche1"></P>
</TD>
<TD>
<P> </P>
</TD>
<TD>
<P> </P>
</TD>
</TR>

</TABLE>
</FORM>
</BODY>
</HTML>
+++++++++++++++++++++++++++++++++++++++++++++++

This post has been edited by Freddz: Jan 21 2019, 07:05 AM
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic
Freddz   Validating 'required' form page data for save to database   Jan 7 2019, 08:34 PM
Christian J   Hello Hello, I have a form page where I check th...   Jan 8 2019, 05:56 AM
Freddz   Thank you very much. But how is the button (<I...   Jan 8 2019, 08:55 AM
Christian J   Could you specify this button definition in detai...   Jan 8 2019, 12:39 PM
Freddz   Another little question to you related to my probl...   Jan 8 2019, 10:10 AM
Christian J   Isn't there anywhere a nice, simple, powerful...   Jan 8 2019, 12:42 PM
Freddz   Hello Christian. I am very sorry but I do not unde...   Jan 10 2019, 04:57 AM
Christian J   But how could the php script be started?? What fr...   Jan 10 2019, 07:35 AM
Christian J   Here's another way of looking at it, where esp...   Jan 10 2019, 07:41 AM
Freddz   Hello Christian. Thank you again. But I still don...   Jan 12 2019, 04:29 AM
Christian J   But I still don't understand e.g. why there i...   Jan 12 2019, 05:55 AM
Freddz   Hello Christian. I think you think that my form p...   Jan 12 2019, 09:34 AM
Christian J   Let's give you a simple example of my form pa...   Jan 12 2019, 02:14 PM
Freddz   Hello Christian. Thank you very much. But once aga...   Jan 14 2019, 07:48 AM
Christian J   But once again your code begins with <?php aga...   Jan 14 2019, 09:53 AM
Freddz   So from your side you just cannot send me a soluti...   Jan 14 2019, 11:54 AM
Christian J   So from your side you just cannot send me a solut...   Jan 14 2019, 01:05 PM
CharlesEF   I posted a $_GET Ajax example a couple of wee...   Jan 14 2019, 12:52 PM
Freddz   I meanwhile think the basic question ist just a si...   Jan 14 2019, 01:58 PM
Christian J   How can be detected that the 'required' a...   Jan 14 2019, 03:31 PM
CharlesEF   If you want to make sure your required fields are ...   Jan 14 2019, 02:19 PM
Christian J   Also, 'onSubmit' isn't a valid form a...   Jan 14 2019, 03:36 PM
CharlesEF   Also, 'onSubmit' isn't a valid form ...   Jan 14 2019, 04:44 PM
Freddz   Hello Charles. Thank you for your time! My goa...   Jan 14 2019, 06:09 PM
Freddz   Would you please show me the code that uses Ajax? ...   Jan 14 2019, 06:23 PM
CharlesEF   Would you please show me the code that uses Ajax?...   Jan 14 2019, 09:19 PM
Freddz   Hello Charles. Yes, I use POST. The PHP script is ...   Jan 15 2019, 02:14 AM
Freddz   If it means that we cannot use a function (javascr...   Jan 15 2019, 02:32 AM
Freddz   Ah, this is also not possible, right? isset can on...   Jan 15 2019, 03:52 AM
Christian J   $sql = "INSERT INTO ... VALUES ('...   Jan 15 2019, 07:03 AM
Freddz   See, Christian, we meanwhile have discussed about ...   Jan 15 2019, 09:23 AM
Christian J   Obviously at each method there is at least one di...   Jan 15 2019, 12:33 PM
CharlesEF   Attached is an example of a $_POST Ajax funct...   Jan 15 2019, 01:58 PM
Freddz   I assume your solution 5 cannot be used as Netobje...   Jan 15 2019, 02:17 PM
Christian J   I assume your solution 5 cannot be used as Netobj...   Jan 15 2019, 03:50 PM
CharlesEF   I forgot to say that you didn't post enough ...   Jan 15 2019, 03:53 PM
Freddz   I forgot to say that you didn't post enough ...   Jan 18 2019, 09:13 AM
CharlesEF   Additional form elements I would add just by addi...   Jan 18 2019, 02:37 PM
Freddz   I forgot to say that you didn't post enough ...   Feb 12 2019, 11:58 AM
Freddz   To solution 1: The idea with the iFrames is a good...   Jan 18 2019, 07:36 AM
Christian J   To solution 1: The idea with the iFrames is a goo...   Jan 18 2019, 12:44 PM
Freddz   Yes, I know that I have to edit the generated file...   Jan 21 2019, 06:52 AM
Christian J   I added an .htaccess file in the html folder with...   Jan 21 2019, 11:09 AM
Freddz   Afterwards I tested your last suggestion, Christia...   Jan 21 2019, 07:13 AM
Freddz   My code is okay, isn't it?... Yes, I have a r...   Jan 21 2019, 05:27 PM
Christian J   My code is okay, isn't it?... The PHP yes, o...   Jan 22 2019, 05:55 AM
CharlesEF   The main problem I see is your use of 'getElem...   Feb 13 2019, 01:07 AM
Freddz   Oh thank you. So I changed from ByName to ByID aga...   Feb 13 2019, 11:13 AM
CharlesEF   Nothing in 'dbinsert.php' jumps out at me,...   Feb 13 2019, 12:01 PM
Freddz   Nothing in 'dbinsert.php' jumps out at me...   Feb 13 2019, 09:59 PM
CharlesEF   I still see the same problem. You did change the ...   Feb 14 2019, 10:19 AM
Freddz   Ohhh, you are sooo great!! Now it works ...   Feb 15 2019, 01:34 PM
CharlesEF   Glad to hear you got it working (after shooting yo...   Feb 15 2019, 03:40 PM


Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 19th April 2024 - 02:17 PM