Wordpress contact form to query external database
Required skills: jQuery / Prototype, PHP, Software Architecture, Wordpress
I need to create a reservation form inside wordpress that is to query and populate an external database.
I need this form to be editable in a way i can change "Agency ID" (see below) and Database Address and Authentication Info so i can use on multiple sites. If you need more information please let me know.
What needs to happen is as follows.
Step 1 – Insert the Customer Record
-----------------------------------------------
The table for this is called member, and a sample insert statement would be like this:
INSERT INTO member (AgencyID, MemberName, FirstName, FamilyName, Email, Mobile, Postcode, State, Country, Gender)
VALUES (1, ‘John Smith’, ‘John’, ‘Smith’, ‘’, ‘0123456789’, ‘2000’, ‘STATE’, ‘COUNTRY’, ‘M’)
The AgencyID field is the unique identifier that identifies the agency.
The MemberName field is the name of the person, couple or group who is making the booking. This can be a person’s full name or whatever.
The Mobile field is the mobile phone number of the customer and needs to have no spaces.
The Gender field must be the letter M, F, or C, where M means Male, F means Female, C means couple. If you don’t know this then you can just insert the character ‘U’ for Unknown.
The member table will not allow a duplicate Email address or Mobile phone number, so you need to check that the insert statement executed successfully.
Step 2 – Get the New Customer Record ID
------------------------------------------------------
Once you have inserted the customer record, you need to get it’s ID with a query based on their Mobile Phone number or email address. Otherwise, if the person making a booking is an existing customer, you do not need to insert a new customer record, as above.
SELECT MemberID WHERE Email = ‘myemailaddress’
or
SELECT MemberID WHERE Mobile = ‘0123...’
Step 3 – Insert the Booking Record
The table for this is called booking, and a sample insert statement would be like this:
INSERT INTO booking (AgencyID, ServiceID, StaffMemberID, MemberID, Branch, StartDT, EndDT, AmountDue, NumPeople)
VALUES (1, x, x, x, ‘PITT_ST’, ’22 Sep 2011 8:30’, ’22 Sep 2011 9:30’, x, x)
The AgencyID field is the unique identifier that identifies the agency.
The ServiceID field must be a valid Service ID which will be supplied.
The StaffmemberID field must be a valid Staff ID which will be supplied.
The MemberID field must be a valid Member ID which comes from the query above.
The Branch field must be a valid Branch code, and will be either ‘P’ or ‘B’.
The StartDT field is the Starting Date/Time for the booking.
The EndDT field is the Finishing Date/Time for the booking.
Make sure there are no seconds in the data, only hours and minutes, and the time must be in 24-hour format (6PM at night would be 18:00)
The AmountDue field is the Total Cost for the booking.
The NumPeople field is the Total Number of People booking a massage (usually 1 or 2).
Posted In:jQuery / PrototypePHPSoftware ArchitectureWordpress |
Related projects:
Wordpress Plugin - Custom form to query MSSQL Database
dpress, end user enter data in form, data is queried to external mssql database doing necessary checks outlined in my word document.
Please see my attached WORD document for detailed information.
PLEASE READ AND UNDERSTAND MY ATTACHMENT BEFORE you bid.
Please Private message me if you need more information.
Please also PM me past wordpress plugin or related projects.
Thank you.
Ray.
Please see my attached WORD document for detailed information.
PLEASE READ AND UNDERSTAND MY ATTACHMENT BEFORE you bid.
Please Private message me if you need more information.
Please also PM me past wordpress plugin or related projects.
Thank you.
Ray.
Create Wordpress Contact Form Plugin
/J15Pbi" target="_blank" rel="nofollow">http://bit.ly/J15Pbi
I like the rounded corners and the captcha verification.
The plugin will need a simple admin settings page.
All code must be written by you, do not plagiarize or copy code from anywhere.
Also, I might need you for future updates, but we can work out a deal on that later.
When you place a bid, tell me how long it will take you to get a working version ready.
Thanks
I like the rounded corners and the captcha verification.
The plugin will need a simple admin settings page.
All code must be written by you, do not plagiarize or copy code from anywhere.
Also, I might need you for future updates, but we can work out a deal on that later.
When you place a bid, tell me how long it will take you to get a working version ready.
Thanks
Wordpress Contact Form to Google Docs
826px; border-width: 0pxborder-style: none; border-spacing: 0px;">
I want, if it can, to do for me a contact form in Wordpress, manually created and all subscriptions to be listed on a google docs given by me.
I don't know if this is possible but I have to try it.
More details about fileds of contact form you'll find in PMB.
I don't know if this is possible but I have to try it.
More details about fileds of contact form you'll find in PMB.
Wordpress Contact Form
be very easy to used (used by anybody who has almost no HTML knowledge), easier than the plugins which are readily available (contact-form-7 etc).
User should be able to create a new contact form (with different field type) and save it as a post.
Project needs to be completed asap.(3-4 days). If it's done successfully, I would hire for similar wordpress projects once this is done (this could be a vary from 3-10 projects)
User should be able to create a new contact form (with different field type) and save it as a post.
Project needs to be completed asap.(3-4 days). If it's done successfully, I would hire for similar wordpress projects once this is done (this could be a vary from 3-10 projects)
A Script To Query The Database Over The Browser
he script has to be able to read a file on the local hard disk so it would know what to query for.
once the search results were generated the script will extract
tdfldOwnerName,
tdfldONumberOANumberOStreet, and
tdfldOCityOStateOZipfldOwner4Zip
and a few other things from the report page (Direct - Report.mht).
the script will then dump/write this data into excel file on the local disk.
the script must run on a browser.
once the search results were generated the script will extract
tdfldOwnerName,
tdfldONumberOANumberOStreet, and
tdfldOCityOStateOZipfldOwner4Zip
and a few other things from the report page (Direct - Report.mht).
the script will then dump/write this data into excel file on the local disk.
the script must run on a browser.
Wordpress Contact Form
We require someone to add a besoke .php contact form to our existing website (wordpress based). The form must have a feature for users to upload documents.
We will supply the design & fields in word and jpeg format.
The form must also work with our Google conversion code.
We will supply the design & fields in word and jpeg format.
The form must also work with our Google conversion code.
Contact Form
need a contact form to send admin html mail exactly like attached image, but with extra field "contact number".
So 4 fields: name, email, contact number, message.
Also, send a "thank you" message to sender.
This is a simple job should take any gd coder 1 hour
Max bid 17 USD.
So 4 fields: name, email, contact number, message.
Also, send a "thank you" message to sender.
This is a simple job should take any gd coder 1 hour
Max bid 17 USD.
Script to Query the Database Over the Browser
>
Additional files submitted: (Files are only available for logged in users)
Direct+-+Report.mht
Direct+-+Results.mht
Additional files submitted: (Files are only available for logged in users)
Direct+-+Report.mht
Direct+-+Results.mht
PHP script to query mysql database and load entries into google calendar
lds) if needed.
Some very minor data manipulation will be required (date/time stored as integer seconds-since-epoch, only events with a particular field blank.)
I expect a PHP solution using Zend GData library is probably the easiest approach. Feel free to propose others.
I want the script to be able to run periodically via cron and add/delete/update information as necessary.
Some very minor data manipulation will be required (date/time stored as integer seconds-since-epoch, only events with a particular field blank.)
I expect a PHP solution using Zend GData library is probably the easiest approach. Feel free to propose others.
I want the script to be able to run periodically via cron and add/delete/update information as necessary.
Add drop down menu + contact form to website
I require a web developer to add a drop down menu and contact form to my website.
Must NOT be flash based as it needs to be 100% compatible with Safari and the iPhone / iPod touch browsers
I will forward the chosen developer my website
Delivery within 2 days
Payment via escrow
Must NOT be flash based as it needs to be 100% compatible with Safari and the iPhone / iPod touch browsers
I will forward the chosen developer my website
Delivery within 2 days
Payment via escrow
Push Php Data To (contact Form To Database Wordpress Plugin)
---
Platform: Wordpress
Database plugin: http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/
Order Plugin: http://tribulant.com/plugins/view/10/wordpress-shopping-cart-plugin
Your bid price & time frame is needed.
Platform: Wordpress
Database plugin: http://wordpress.org/extend/plugins/contact-form-7-to-database-extension/
Order Plugin: http://tribulant.com/plugins/view/10/wordpress-shopping-cart-plugin
Your bid price & time frame is needed.
Wordpress Plugin Contact Form
milar to existing plugins. Once contact form is saved a table will be created just for that form with fields that are the same as contact form fields.
Once the form is submitted the admin can view forms in admin sidebar with little numbers for new submissions. Once admin clicks on form the admin can then view/sort/delete/export form submissions on a per form basis.
Please contact me on the PMB for any questions, this will be an on going project to keep it current with WP.
Once the form is submitted the admin can view forms in admin sidebar with little numbers for new submissions. Once admin clicks on form the admin can then view/sort/delete/export form submissions on a per form basis.
Please contact me on the PMB for any questions, this will be an on going project to keep it current with WP.
Psd To Html + Css And Ajax Contact Form Needed Asap
ll provide all the graphics.
3 Pages include a homepage and 2 content pages,
We need this to be compatible with all browsers.
1. psd to html,CSS - 3 pages
2. contact form - when you click contact us, a dropdown ajax form is needed.
4 fields with validation: name, email, phone, Message box. all fields except phone are required fields.No database work.
form will send me the message and send a confirmation email to user. also a Thank you message on submit.
3 Pages include a homepage and 2 content pages,
We need this to be compatible with all browsers.
1. psd to html,CSS - 3 pages
2. contact form - when you click contact us, a dropdown ajax form is needed.
4 fields with validation: name, email, phone, Message box. all fields except phone are required fields.No database work.
form will send me the message and send a confirmation email to user. also a Thank you message on submit.
Wordpress Contact Form Styling
gn.
So:
1.) Change the validation error so it shows the red box-shadow when there is an error. I want to get rid of the default way that CF7 does this.
2.) Using jQuery or something, I want the select to look just like my design.
Needs to be cross-browser. IF, using CF 7 for this is too much trouble, I am willing to use another form processor. Those who can show me similar forms or just a really good form design they've done will get priority.
So:
1.) Change the validation error so it shows the red box-shadow when there is an error. I want to get rid of the default way that CF7 does this.
2.) Using jQuery or something, I want the select to look just like my design.
Needs to be cross-browser. IF, using CF 7 for this is too much trouble, I am willing to use another form processor. Those who can show me similar forms or just a really good form design they've done will get priority.
Add Web Form And Css Layout Work For Wordpress Website
ricelist-most-popular.pdf - This how each of the three pages layout should look. The content would as per the supplied spreadsheet.
Once you have completed the work the web pages must pass the AVG online web page scanner. They currently do and this is purely to protect the site from and malware via a wordpress plug in
http://www.avg.com.au/resources/web-page-scanner/
Once you have completed the work the web pages must pass the AVG online web page scanner. They currently do and this is purely to protect the site from and malware via a wordpress plug in
http://www.avg.com.au/resources/web-page-scanner/
Adjust Wordpress Pages To Reflect Theme Demo
ns/Bottom/Fonts- Same as home page
Additional Info-
The contact form in the bottom will be sufficient on this page as well
Contact us-
Layout- “Contact Us Layout”
Background/Background Pattern/ Buttons/Bottom/Fonts- Same as home page
Additional Info-
This should look exactly as the “Contact Us Layout,” but remove the google maps widget. Also add “Phone” as a requirement along with the Name, Email and Message on contact form
Additional Info-
The contact form in the bottom will be sufficient on this page as well
Contact us-
Layout- “Contact Us Layout”
Background/Background Pattern/ Buttons/Bottom/Fonts- Same as home page
Additional Info-
This should look exactly as the “Contact Us Layout,” but remove the google maps widget. Also add “Phone” as a requirement along with the Name, Email and Message on contact form
