Php Mysql Script Adaptation
Bidders who have worked with “form mail” from www.tectite.com will be given priority – please advise in your bid message if you have experience with this script?
Full briefing attached, look forward to your bids.
Bidders who have worked with “form mail” from www.tectite.com will be given priority – please advise in your bid message if you have experience with this script?
Full briefing attached, look forward to your bids.
I want to install a php/mysql script to my hosting.
The script can be downloaded from nubuilder.com, and can be installed as per the pdf doc attached.
I need a simple script were I can add my domains and information about each domain. I used to do this with microsoft access, but sometimes other people need to add information or modify information for me and not everybody has access. Hope I made it clear enough, otherwise ask any questions.
Thanks
I have a file that is meant to be run via cron jobs, once I get it working right. It is all set up, but there is a problem with the MySQL query. The script works, but only for the first entry it pulls from the database. I want someone to figure out how to make it run for all the entries it pulls from the database.
Should be a very simple job for someone who knows what to look for. I have attached the file so you can view the code yourself.
I need a script written to insert a .cvs inventory file into Zencart for multiple product catogories and subcatagories and be able to be ran daily to update inventory availability.
I am looking for a programmer to find and install a clone PHP/MYSQL script of http://plrwholesaler.com.
I need a free membership website with a squeeze page as a homepage. Once the buyer subscribes to the free offer they are e-mailed a password to enter the backend of the site. Site will be free, so no payment processing is needed. You do not need to provide design or copy, just the script. If you can use WordPress to accomplish this, even better.
I am looking for a PRE BUILT php/mysql script that will allow someone to store their information, like name, address, phone number, email, etc etc.
It should also have the ability to edit the info. There should be some type of admin where the admin can see the list of users.
I should be able to easily add fields to the script. Preferably you can show me the mysql of the script so I can take a look.
I already have a existing script which takes wav file and converts to mp3 using Sox, assigns a random filename, puts the filename in a database, then uploads the file via ftp to the server.
Script was working 6 months ago. Now it is not. Programmer will have admin access.
Pretty short and simple script to be inserted into website. This is to send a sms message via a http call, loops over for as many names are listed in the text box and inserts the response of the http post to an existing mysql database.
1 Form will have 3 elements
1)TO = Text area = 10 digit numbers separated by comma (FROM will be parsed from page no form piece is needed) strings longer than 10 digits will be discarded
2)A text area (text limiting script provided)
3)Submit Button
Text button will then loop over as many 10 digit strings there are to a http string and replace spaces with % post the result to a mysql database already created, provided
The script will be similar to this format
sendsms.php?username=%(USERNAME)s&password=%(PASSWORD)s&from=+%(FROM)s&to=+%(TO)s&text=%(TEXT)s”"”
The script will have to be formatted using somethign similar to this… (this is part of another python script)
TEXT=TEXT.replace(‘ ‘,’%20′).replace(‘t’,'%20′).replace(‘rn’,'%0D’).replace(‘r’,'%0D’).replace(‘n’,'%0D’)
Responses are
Successfull SMS:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>1</result>
<resultstring>success</resultstring>
<description />
<endcause />
</SmsResponse>
Invalid number:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>0</result>
<resultstring>failure</resultstring>
<description>Invalid Number</description>
<endcause>19</endcause>
</SmsResponse>
Do not know if should queue this, or post while user is waiting?
I need a script written that selects a random user from the database of users that are logged into my website, and award them by inserting points into another field. This award needs to select a random person in the morning and a random person in the evening. It must work only when there are at least 5 people logged into the site. It must also keep a database feild of winners and also a page that querys the winners for the week will need to eb created. The script will be activated by cron job unless you know a better way.
Budget is very low for this since it will not take long at all, it’s simple array. But more work will definatly follow this job in the next few weeks if you do good.
Bidders MUST have yahoo messaner, and have a good understanding of English.
Pretty short and simple script to be inserted into website. This is to send a sms message to a group of people.
1 Form will have 3 elements
1)TO = Text area = 10 digit numbers separated by comma (FROM will be parsed from page no form piece is needed) strings longer than 10 digits will be discarded
2)A text area (text limiting script provided)
3)Submit Button
Text button will then loop over as many 10 digit strings there are to a http string and replace spaces with % post the result to a mysql database already created, provided
Responses are
Successfull SMS:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>1</result>
<resultstring>success</resultstring>
<description />
<endcause />
</SmsResponse>
Invalid number:
<?xml version=”1.0″ encoding=”utf-8″ ?>
- <SmsResponse>
<version>1</version>
<result>0</result>
<resultstring>failure</resultstring>
<description>Invalid Number</description>
<endcause>19</endcause>
</SmsResponse>
Do not know if should queue this, or post while user is waiting?
Marketplace Script upgrade PHP MYSQL
This Marketplace Digital downlaodable product selling site is Already live and there are 100s of Sellers/members in the database.
I am looking a professional php/MYSQL programmer with experience and work with commitment and on time with out any problems.
Features Required
1- Need to charge fee per sale in % percentage: For the following Memberships
Free:
Pro:
Premium:
For above feature requires
For Members Area:
One summary in Members area (will show monthly)
Date – Product – Price – Admin Fee
Total Sale:
Total Fee:
Admin Area
One summary in Admin Area (will show monthly)
S.no – Date- Member/Seller – Product – Sale – Admin Fee – Remove/Edit
In admin For every member will show payable balance i.e.
Total Sale:
Total Fee:
End of month Seller/Member will receive Fee invoice bill with paypal link to pay.
after payment members and admin area will show paid with date and balance will
go to 0.
- Required Cron Job for
i- To Send Invoice Automatically every end of every month
ii- For Sellers Product Subscription – Once a week script will send list of a new products added by the seller to all their subscribers.
All sumaries must requird paging.
2- FTP Upload for Digital Products for Pro and Premium Members only
- Pro/Premium Sellers/Members should be able to access our server their own specific area and upload their own products
and all for every product download link show in the members area so they can take that download
links to ad when post new product.
- Admin msut be able to control Maximum uplaod file plus Total Web Space Allocation per pro/Premium Member.
3- Need To Add Google Checkout Payment Processor for Members
So Members can choose which feature they want to use.
4- Mass Pay Feature Required for Admin To Pay commission
via paypal to all affiliate. Following Summary required.
- Affiliate Username – Paypal Email – Commissions – Paid/Unpaid
- CSV OR TEXT File downloadable Required
5- Stats Required For Admin:
How many products are posted on the site:
How Many Total Prodcuts Sold (Monthly):
Total That Months Sale on the Entire Site:
6- 3 Existing forms needs Captcha code for form security.
Please also PMB
——————
It will be your responsibility that when you add new upgraded features site wroks perfectly ok.
You msut be available on msn, yahoo or gtalk
Give comments for every feature so members and admin know how to use those features.
Work must be completed on time.
Work must be complete Error free.
You must test complete script.
You msut inform us about the progress on a regular base.
The data from my MySQL db is not displaying correctly on my real estate listing site. Users are unable to update their property listings.
I need that fixed and also the feed from the Multiple Listing Service is not updating. That should be just a minor adjustment of changing a url in script.
Also I need to make certain all security holes are closed,
There was a virus on the site that may have destroyed some of the code. I don’t have a full backup.
**********************************************************************
!+++ this is an adult website +++! – you must be 18 or older and agree to work on an adult content website.
- no gay content, basically you be looking at adult dvd box covers.
**********************************************************************
I have a ‘products’ table in mysql that contains a memo field that contains list of actors in comma separated value format.
e.g:
John Smith, John Doe, Hank Johnson, Jason, Frank Thomas, etc
What I need is a script that I can run via shell/crontab that will make make a list of all the individual actors and dump them into a new table.
Basically ‘table1′ contains thousands of movies with the actors in that movie in a memo field in CSV format. I need the script create a list of all the actors in every movie within the table, remove any duplicates within that list, then create/add the list of actors to a new table; ‘table2′. Once the script runs again via crontab, it should compare all of the actors in table1 with table2 and add any new actors it finds. that’s it
This is what the script should do exactly:
1) do a query within that table/column and find all of the actors and break them up individually – (the comma determines a new value).
2) remove all of the duplicates it finds.
3) dumps the new actors list into a new table, since there will be multiple movies with the same actor, we only want the actors to show up once in the new table.
4) the script must be able to run via crontab/shell
5) once the script reruns via crontab, it must look at table1 and table2 and add any new actors it finds, if it doesn’t find any new actors.. it doesn’t add anymore to the list in table2.
Basically what I’m trying to do is create an index listing page for all the available actors that are on the site
OK, here goes. I need a custom PHP/ MySQL “work order” script.
I’m swamped with work, and I need this done ASAP, preferably by Wednesday, at the latest.
You will receive full CPanel access to an empty site on my server to complete the project.
Work and testing MUST be done on my server – no exceptions.
Low bids with verifiable experience will be given preference.
By bidding, you agree that I own all rights to the script, and may use, modify, or sell it,
as I see fit.
I will pay immediately via PayPal upon acceptance of the script,
after testing as admin, agent, and user. No deposits, no escrow, no exceptions.
I will give a feedback rating of 10, if this is done to specifications and on time.
The MySQL database will have 4 tables and about 50 fields, total.
You will have full CPanel access, including Legacy File Manager and phpMyAdmin.
The tables are only suggestions – if you can use fewer tables, that’s fine.
Details:
Table 1:
users
Fields:
username
password
(note: users may only view their submitted work orders, updates, images, and docs)
Table 2:
admins
Fields:
username
password
priveleges
(note: admin has full access; agents may view work orders, add updates, images, and docs, but may not delete data)
Table 3:
uploads – admin and agents may upload photos of the work performed for users, as well as other documents. These documents will be written to an images folder and a docs folder. Users may upload images or docs with signup form
Table 4:
user_data – 27 unique fields, including the id field, which will be auto-incremented. actual fields will be provided to the winning bidder – several are date fields
The PHP files:
login.php – login for admins, agents, and users –
when a user logs in, user will be directed to index.php
when an admin or agent logs in, he will be redirected to admin/index.php
signup.php – signup form for users – I will provide a mostly-completed form. You will add uploads and change form as needed.
This form will write the 27 fields of user data, including the username and password, plus any uploads to the database and the appropriate folder.
index.php – when logged in, a user will be able to see his work order, updates, and images (with captions) that pertain to his work order.
user will be able to download docs that are attached to the work order
user will never be able to see other users’ work orders or information.
If user has multiple work orders, user will be able to select one from the group, via dropdown menu.
admin folder – accessed only by admin and agents.
index.php – admin/ agent will be able to view id number, completion status, username, and address for all work orders. admin/ agent can select a property to update and is taken to update.php
update.php – admin/ agent can view work order, write a text description of work done and upload unlimited “before” and “after” photos with captions, and documents with captions.
Information will be dated with date and time values.
admin/ agent can add more data to the update by accessing this page again -
old data is retained and not overwritten
delete.php – only admin can access – use javascript alert to confirm before deleting work order
admin.php – only admin can access – may create new agents or delete agents
Important: All files MUST have include statements for header.php and footer.php.
I will place a generic header and footer on the server in the public_html directory.
That’s it. Not too hard if you’re well-versed in PHP/ MySQL.
I hope to choose a winner this later evening, so bid soon.
P.S. I’m a provider on SL, with excellent feedback. Nothing recent, though, as I’ve been too busy.
Please only bid if you agree to the terms as stated and can complete this within 3 days.
I’m not interested in an open-source or pre-made script. This must be custom.
If you have any questions, please ask.
I have 2 tables :
Table 1 :
EAP PRODUCT
50 10
50 11
50 12
50 13
51 10
51 11
51 12
51 13
Table 2 :
EAP_ PRODUCT_
50 10
50 11
50 13
51 10
51 11
51 12
I would like a sql script that will identify that on table 1, the line “EAP = 50 and PRODUCT = 12″ is not showing on table 2
Same for “EAP = 51 and PRODUCT = 13″.
I want this script to show the missing lines for table 2.
I need a php app that will allow a visitor to my site to enter in a “gift card code” that will send the user to a page if the code is valid and to another if the code is not valid.
I would like to have the code entry page and an admin section.
admin section:
- provide the ability to generate as many random codes as needed, and allow me to export them as a .csv file for use on gift cards.
- provide the ability to setup the DB for those codes.
- provide the ability to have several gift cards, which means that a set of codes will only apply per type of card (card=product)
- each product will be able to configure a different success page and failure page.
I need a simple php/mysql script which calculates an amount using a few vars and queries. The page should have a preloader and should only be displayed when opened from a specific domain. It should also have a password field – if password does match the calculated value should be inserted into db. You will get detailed instructions – I prefer a fast delivery – urgent and needed asap!
NEEDS TO BE SECURE
PSD needs to coded
DESIGN: http://img41.imageshack.us/img41/7207/27877574.png
Main Features
- RSS Feeds for Lyrics & Spotify Playlist
- Displays YouTube video based on (Artist/Song title) using YouTube API (e.g. http://www.ibm.com/developerworks/xml/library/x-youtubeapi/)
- Display YouTube video image thumbnail
- Stores YouTube url in database so it doesn’t need to query for it in future (faster loading times)
- Search for Lyrics, Spotify Playlist
- Browse Lyrics & Spotify Playlist
- Browse Lyrics by alphabet letters
- Most viewed Lyrics/ Spotfy Playlist
- Display Most popular, newest added, top rated (in AJAX tab)
- Users register (captcha needed)
- SEO friendly URL’s
User Features
- Submit Lyrics
- Submit Spotify playlist URL (Title, Description, members name)
- Rate Lyrics & Spotify URL’s
- Comment on Lyrics and Spotify playlist
- Show user contribution next to their name e.g. (John Lyrics (500) Playlist (3) )
- Ability to add Lyrics & Spotify playlist to their own ‘favorites’
Admin Features
- Add/Edit/Delete Lyrics
- Add/Edit/Delete Spotify Playlist
- Add/Edit/Delete Users
- Edit/Delete Comments
- Add/Edit/Delete news to home page ability for users to comment
- Add/Edit/Delete Featured Lyrics/ Spotify Playlist to main page (shows latest added)
Please let me know the price for the following:
1) Create a new table in MySQL called “Sample Requests”.
2) Search another table for entries that have NEW data for specified fields (make, model and year).
3) Pull the new entries and copy them to the table “Sample Requests”
4) Email new sample requests, nightly, to specified email address in specified format
Thank you,
Peter
We have a Lead Generation Script written in PHP with mysql.
Please DO NOT bid unless you have excellent feedback rating and have experience working with PHP Scripts.
Project details:
1) Create Custom Form for our lead generation script. We can provide you with a snapshot of what the form needs to look like. Integrate this script into our Existing Database and backend system.
2) We have a SSL certificate installed you will also need to modify the script so it is SSL without the problems of having any Popups saying ‘this pages contains secure and non-secure items’.
Please DO NOT bid on this unless you have experience. Project needs completed As Soon As Possible.
Hi all, I need a script in a hurry (within the next 2 or 3 hours of posting this).
Sorry if this is not clear, feel free to ask me questions!
It does not need to be pretty it does not need to be complex, it just needs to be functional!
I need a simple system with 3 tables in a MySQL database, the first table will house the details of a customer, the second table will house the details of an event and the third table will link them via a customer id and appointment id to form an appointment card if you will. The user will need to add, remove, edit and view records from each table, the user does not need to be able to query the database but I will need a function so that customers with booked appointments can be listed with the event and appointment details.
The customer table will need custID, title, first name, last name, address 1, address 2, address 3, postal code, telephone number fields
The event table will need eventID, event name, event length and price fields.
the appointment table will need apptID, date, time, location1, location2, location2, postal code, custID(booking the event) and eventID(what the customer has booked).
Looking for a coder to develope a sight from a script that I have in mind The end user demo is located here: http://demos.kubelabs.com/kubelance and the administrator back-end demo here: http://demos.kubelabs.com/kubelance/adm (USER: demo PWD: demo)
I will need the script slightly altered to add afew features and the home page layout to look like Craigs list
Once the site is completed, I don’t mind apying a monthly fee for extra tweeks and bugs that may be in the site work
I need a script which reads a xml api and compares the values with a mysql database and makes in some steps certain updates in the mysql database.
I need that script asap.
Before I select the bid, I`ll provide the exact manual of the project for the programmer to be sure that it can be done.
I have a script that loads any table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.
It works great except it doesn’t handle null values of Blob fields. It inserts them back in as empty or 0 instead of null. So instead of [BLOB - NULL] It gets copied as: [BLOB - 0 B].
Here’s the current code:
<?
define ( “EW_CONN_HOST”, “localhost”);
define ( “EW_CONN_USER”, “root”);
define ( “EW_CONN_PASS”, “”);
define ( “EW_CONN_DB”, “sl_nulls”);
* ==[ Note: This is where I define the table on which to copy records, the record ID to copy from, and the fields to change
// Which record to select
$whereStmt = ' SiteUserID="43"';
// Which fields to change
$replaceArray = array( "SiteUserID" => 44 );
copyRecord($whereStmt, $replaceArray, "sitesettings" );
function copyRecord( $whereStmt, $replaceArray, $tableName )
{
$mysql_link = mysql_connect( EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS );
mysql_select_db( EW_CONN_DB, $mysql_link );
$sql = "select * from $tableName where ".$whereStmt. " ;";
$result = mysql_query($sql, $mysql_link)
or die('Query failed:[$sql]<br>Error is: ‘ . mysql_error( $mysql_link ) );
if ($result)
{
// the next row should have the at symbol in front of mysql but I can’t put it because of scriptlance rules.
if ( mysql_num_rows($result) > 0)
{
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array
foreach ( $row as $key_ => $value )
{
$slashedrow[ $key_ ] = addslashes( is_null( $row[ $key_ ] ) ? “{[i_am_Null]}” : $row[ $key_ ] );
}
// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array ‘$namesAndValues’ will be affected
foreach ( $replaceArray as $theName => $theValue )
{
$slashedrow [ $theName ] = addslashes( $theValue );
}
// Rebuild the field list and the value list for the insert
$fieldList = implode(“,”, array_keys($slashedrow) );
$valueList = “‘” . implode(“‘,’”, $slashedrow) . “‘”;
$valueList = preg_replace( “~’{[i_am_Null]}’~msi”,”NULL”,$valueList );
// Run the query
// echo (“Trying to insert into $tableName ( $fieldList ) values (‘$valueList’)”);
// echo $sql
mysql_select_db( EW_CONN_DB, $mysql_link );
$sql =”insert into $tableName ( $fieldList ) values ( $valueList ) ;”;
$result = mysql_query( $sql, $mysql_link )
or die( ‘Query failed:[$sql]<br>Error is: ‘ . mysql_error( $mysql_link ) );
}
}
}
?>
Please make sure you can fix the problem with the data given in the project description. To successfully complete this project, the blob fields shouild be copied exactly including NULL if they are NULL.
This needs to be done within 24 hours of awarding the project.
I have a script that loads a table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.
It works great except it doesn’t handle null values well. It inserts them back in as empty or 0 instead of null.
I need someone to fix it tonight.
Here’s the code:
// This is where I define the table on which to copy records, the record ID to copy from, and the fields to change
$whereStmt = ‘ SiteUserID=”43″‘;
$replaceArray = array( “SiteUserID” => $conn->Insert_ID() );
copyRecord($whereStmt, $replaceArray, “sitesettings” );
function copyRecord($whereStmt,$replaceArray,$tableName){
$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql =”select * from $tableName where “.$whereStmt;
$result = mysql_query($sql) or die(‘Query failed: ‘ . mysql_error());
if ($result) {
// the next row should have the at symbol in front of mysql but I can’t put it because of scriptlance rules.
if ( mysql_num_rows($result) > 0) {
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array
foreach ($row as $key => $value) {
$slashedrow[$key] = addslashes($row[$key]); }
// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array ‘$namesAndValues’ will be affected
foreach ($replaceArray as $theName => $theValue) {
$slashedrow [$theName] = addslashes($theValue);}
// Rebuild the field list and the value list for the insert
$fieldList = implode(“,”, array_keys($slashedrow) );
$valueList = implode(“‘,’”, $slashedrow);
// Run the query
// echo (“Trying to insert into $tableName ( $fieldList ) values (‘$valueList’)”);
$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql =”insert into $tableName ( $fieldList ) values (‘$valueList’)”;
$result = mysql_query($sql) or die(‘Query failed: ‘ . mysql_error());
}
}
}
This code should work with any database where the table has a UserID field as the key. I will not provide a connection to the actual database as it is not needed.
Corrected code shoud be delivered within 24 hours of being awarded the project.
I have a script that loads a table, puts all fields and values of a defined row in an associative array, applies an array of changes then writes the data back to the DB as a new record.
It works great except it doesn’t handle null values well. It inserts them back in as empty or 0 instead of null.
I need someone to fix it tonight.
Here’s the code:
[code]
function copyRecord($whereStmt,$replaceArray,$tableName){
$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql ="select * from $tableName where ".$whereStmt;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
if ($result) {
// the next row should have the at symbol in front of mysql but I can't put it because of scriptlance rules.
if ( mysql_num_rows($result) > 0) {
$row = mysql_fetch_assoc($result); // get the (1st) row as an associative array
foreach ($row as $key => $value) {
$slashedrow[$key] = addslashes($row[$key]); }
// Run down the passed list of fields we want to modify in the record.
// Replace any existing value with the new value.
// Only fields in the passed array '$namesAndValues' will be affected
foreach ($replaceArray as $theName => $theValue) {
$slashedrow [$theName] = addslashes($theValue);}
// Rebuild the field list and the value list for the insert
$fieldList = implode(",", array_keys($slashedrow) );
$valueList = implode("','", $slashedrow);
// Run the query
// echo ("Trying to insert into $tableName ( $fieldList ) values ('$valueList')");
$link = mysql_connect(EW_CONN_HOST,EW_CONN_USER, EW_CONN_PASS);
mysql_select_db(EW_CONN_DB, $link);
$sql ="insert into $tableName ( $fieldList ) values ('$valueList')";
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
}
}
}
// This is where I define the table, record ID and fields to change
$whereStmt = ' SiteUserID="43"';
$replaceArray = array( "SiteUserID" => $conn->Insert_ID() );
copyRecord($whereStmt, $replaceArray, "sitesettings" );
[/code]
This is what I’m looking for:
I want a MySQL database with the following fields:
I have an autoresponder app. On a post submit it will add info to a user account and send an email out through a perl script. I need the script to be altered to be able to add the user post submit to multiple accounts between 1 to 5 if possible.