Posts Tagged MySQL

Database Development

!) Modify one existing MySql database and refine the generated pages look. Create a small number of reports.
2) Create a new MySql database, some scheduled reports, simple query forms, payment pages to link to external Merchant accounts. Data will come from 1) above and external sites

Tags: , , , , , , , , , , , , , , , ,

PHP Expert For Various Projects

I need someone with excellent knowledge of PHP and mysql. I have several websites and I often need minor tweaks and updates for my websites. So, I need someone who can maintain my several websites as and when needed. I need a fix hourly rate and we can discuss fixed cost each time I need something done.

If this works out well, then I might also need you to build my several sites that I will be building in a few weeks from now.

Tags: , , , , , , , , , , , , , , , ,

Simple Directory Site

We need a simple directory site either built or tailored from existing scripts already available. The site should be designed just like Best of the Web (http://botw.org), the Open Directory Project (http://www.dmoz.org/). We are talking very limited CSS. A simple CMS with MySQL backend should be in place. The directory will serve over 100,000 listings from the start. We will provide the CSV files to populate. We will also provide the directory hierarchy which will start with a breakdown by regions followed by categories within the directory of offerings. A search capability is also required.

The site should again be very basic and simple looking. No fancy graphics, colors, or ads required. More details in a PM to quality bids.

Tags: , , , , , , , , , , , , , , , ,

PHP/Mysql Projects (various) – 30 Day Assignment

I have various PHP, MySQL, Linux projects in my company. The maximum salary is $1000 based on experience. I need someone who will work for one month (140 hours) on my projects. If everything is good, we may continue for more months.

Here are the requirements:

Minimum 5 years programming in PHP, MySQL on Linux.

You must speak English and be able to carry on a conversation through Skype text chat. If you can speak English over Skype voice then you will have an advantage.

Accept PayPal or Payoneer for payment

You must be capable of working during the USA business day.

You must be reliable. If I hire you to work for a month, you must be available. You would be expected to be available on Skype during the day even if you dont have anything to work on at that moment.

Tags: , , , , , , , , , , , , , , , ,

VBA Program To Extract Excel Data Ready For Mysql (Repost)

Hi,

Sorry this had been cancelled and reposted due to the incorrect budget being set on the first project.

I have the fun task of getting data which has been entered into Ms Excel spreadsheets over the past 5 years into a mySQL database.

The client uses excel spreadsheets to record customer body measurements as part of a personal training service. There are over 20 spreadsheet files, each with at least 50 sheets of data. The problem is the data is not set in a database friendly format. (see example attachment)

I got the client to enter to the userid into cell A1 on each spreadsheet. I need to get this data either onto another excel spreadsheet or into a CSV file ready to import. Im thinking the best way to do this would be to create a VBA program that grabs data from certain cells and places them sequentially onto database ready lines.

The DB structure for the mysql DB will be (tbl_measurements):
user_id INT(10)
mm_date DATETIME
mm_weight DOUBLE
mm_abdominal DOUBLE
mm_subscapula DOUBLE
mm_bicep DOUBLE
mm_tricep DOUBLE
mm_sum_of_4 DOUBLE
mm_diff_mm DOUBLE
mm_diff_per DOUBLE
mm_history DOUBLE
mm_shoulders DOUBLE
mm_chest_in DOUBLE
mm_chest_ex DOUBLE
mm_bicep_right_un DOUBLE
mm_bicep_right_flex DOUBLE
mm_bicep_left_un DOUBLE
mm_bicep_left_flex DOUBLE
mm_waist DOUBLE
mm_navel DOUBLE
mm_hips DOUBLE
mm_quad_right DOUBLE
mm_quad_left DOUBLE
mm_calve_right DOUBLE
mm_calve_left DOUBLE

So, what I need is a simple VBA program (or similar), that reads in a single excel file, loops though all cells on each sheet, and spits out either a excel file, or CSV file in the correct format. (i.e. ready to import into a mySQL database)

Tags: , , , , , , , , , , , , , , , ,

MYSQL Database Creation Needed

Database Situation

We are looking for someone that will work with us to build
a database to make it easier for our company to manage various nuances of our business. We are in the
telecommunications management business supporting hundreds of locations worldwide. We need a
mysql database that will allow us and our clients to access account, contract, and vendor information
through a web access portal on our web site. There are dynamics associated with telecommunications
that require slightly more robust database functionality. The goal of the database is to keep track
of the many facets of an organizations communication services and equipment. Since no two businesses
are exactly alike we need the flexibility to build a companys information based on what they have and
not a cookie cutter profile.

Please see attached document for more project details. Please email questions and your project bid. We are looking for a flat project fee, not to be paid hourly.

Tags: , , , , , , , , , , , , , , , , ,

Setup Mysql

setup mysql on a site.. its already written, I need it installed. easy task. if this is done quickly, Ill give other tasks..payment only after completion…

Tags: , , , , , , , , , , ,

Update Contents Of Mysql Php Db Using Excel File Provided

Need data in existing and functioning mysql database updated with new data that I will provide as an excel file. Old data is to be completely removed and replaced entirely with the new data in the excel file I will provide. You can see the databased involved at.
http://www.manvillerubber.com/jm_clipper_oil_seals_sizes_prices.php

Tags: , , , , , , , , , , , , , , , ,

PHP + MySQL + Smarty + JS Script – Changes Needed – ASAP

Hello,

Im looking for a good developer to do some changes and fixes in a PHP + MySQL + Smarty + JS Script

The maximum budget for this project is $30 USD. Changes to be done ASAP (understand this as NOW)

Ill provide the link of the script by PM.

After this urgent changes Ill deliver more changes to be done.

Thanks

Tags: , , , , , , , , , , , , , , , ,

CMS Website Directory Joomla

Create travel related website with menu system and various pages to be discussed in PM.
Php, mysql.
There is a mysql db with lot of content to use to insert content in site automatically and also create the directory structure.
Preferably using using joomla+rockettheme+k2 template or joomla+yootheme+zoo (have sites with these already installed)
Can suggest another CMS if better, easier, faster.
Professional look (top menu like in rockettheme or yootheme).
Skills wanted: PHP, Mysql, CMS, Html, Ajax, javascript, joomla, rockettheme, yootheme, ZOO.
Timeframe: 7 days
Budget: 200$

Tags: , , , , , , , , , , , , , , , ,

Script To Insert Data In Joomla

I have a mysql database with titles, article content and category structure information (few levels).
I need a script to insert it automatically into my joomla website using either an existing extension script or to modify an existing script or to write a script yourself.
End result should be the joomla site with content listed like in a directory with all the menus and articles inserted.
Need coder with the following skills:
Would need a coder with the following skills PHP, Mysql, CMS, Joomla, K2, and template, Rockettheme, Yootheme.

Tags: , , , , , , , , , , , , , , , ,

VBA Program To Extract Data From Excel Ready For Mysql

Hi,

I have the fun task of getting data which has been entered into Ms Excel spreadsheets over the past 5 years into a mySQL database.

The client uses excel spreadsheets to record customer body measurements as part of a personal training service. There are over 20 spreadsheet files, each with at least 50 sheets of data. The problem is the data is not set in a database friendly format. (see example attachment)

I got the client to enter to the userid into cell A1 on each spreadsheet. I need to get this data either onto another excel spreadsheet or into a CSV file ready to import. Im thinking the best way to do this would be to create a VBA program that grabs data from certain cells and places them sequentially onto database ready lines.

The DB structure for the mysql DB will be (tbl_measurements):
user_id INT(10)
mm_date DATETIME
mm_weight DOUBLE
mm_abdominal DOUBLE
mm_subscapula DOUBLE
mm_bicep DOUBLE
mm_tricep DOUBLE
mm_sum_of_4 DOUBLE
mm_diff_mm DOUBLE
mm_diff_per DOUBLE
mm_history DOUBLE
mm_shoulders DOUBLE
mm_chest_in DOUBLE
mm_chest_ex DOUBLE
mm_bicep_right_un DOUBLE
mm_bicep_right_flex DOUBLE
mm_bicep_left_un DOUBLE
mm_bicep_left_flex DOUBLE
mm_waist DOUBLE
mm_navel DOUBLE
mm_hips DOUBLE
mm_quad_right DOUBLE
mm_quad_left DOUBLE
mm_calve_right DOUBLE
mm_calve_left DOUBLE

So, what I need is a simple VBA program (or similar), that reads in a single excel file, loops though all cells on each sheet, and spits out either a excel file, or CSV file in the correct format. (i.e. ready to import into a mySQL database)

Tags: , , , , , , , , , , , , , , , ,

JAVA/MySQL Expert – Develop EMR Desktop Application

We are looking for Team or individual to develop EMR desktop application in JAVA/MySQL, which is similar to Open Source EMR developed in PHP & MySQL.

Identified open souce EMR is very simple application. It doesnt have much logic or data validations in the code/app. We are looking for very similar desktop application.

Please only bid if you are JAVA & MySQL expert and familiar with EMR applications (Medical Practice Management).

Thank You.

Tags: , , , , , , , , , , , , , , , ,

Facebook Application – Vouchers – PSD To APP – PHP & MYSQL.

REQUIREMENTS:

– We have a database of voucher codes, that need to be presented within Facebook
– We will provide PSD designs and guidance
– You need to link in with our MySQL database to create the app as we have designed
– There are tools like sharing, wall posting, e-mail collection etc

THANKS

Tags: , , , , , , , , , , , , , , , ,

$30 Project

Solve MySQL error and ensure all images are in gallary like before.

Tags: , , , , , , , , , , ,

New Team – FullTime PHP,MySQL,HTML,JAVASCRIPT,AJAX, And More

We are making a Team, to create a big Browsergame.
We looking for:

PHP, Ajax, MySQL,HTML, JAVASCRIPT, AJAX, JQUERY, ACTIONSCRIPT, FLASH, Designer

You need to work 5 Days/Week with 8 Hours/Day .
Please make the Bid for your Fulltime Price and what you Skills are!
We ONLY need HIGH SKILLED Persons..

Tags: , , , , , , , , , , , , , , , ,

Database & Server Configuration Memory – Site Is Down

our server is running out of memory upon immediate restart.
using the TOP command, we see that mysqld and apache (httpd) peg the CPU usage of the server.
This started happening yesterday at 11:30 PST.
Our server upon restart takes 4 minutes and works fine, then immediately goes into non-response state.
Log files on mysql dont show anything.
need someone to diagnose and fix

Tags: , , , , , , , , , , , , , , , ,

Need A Mysql Php Developer To Work With Us

Hi , We are looking for someone to work with us on our current project. This project will include several hours of work.
Please Message For Details

Tags: , , , , , , , , , , , , , ,

INTERNAL MONEY TRANSFER SYSTEM

I NEED SOME ONE TO DESGINE ASIMPLE WEB BASED INTERNAL AGENTS WEB SITE USING .NET,MYSQL OR MS SQL DATABASE. AND HOST IN MY SERVER
BASIC STEPS ARE
1. CREATE A WEB BASED POTRAL WHERE A AGENT LOGIN AND TAKES ATRANSACTION FROM A WALK IN CUSTOMER AND ENTERS IN THE SYSTEM
2.ADMIN THE PROCESS THE TRANSACTION TO THE SET OF AGENTS
3. CUSTOMER AND AGENT GETS THE RECPIT AND THE MONEY IS PROCESSED THROUGH AN INTERNAL GATE WAY
4. THE TRANSACTION PROCESSED CAN BE EXTRACTED BY EXCEL SHEET WHICH WILL BE PROVIDED

MORE DETAILS WILL BE PROVIED AFTER CHOSING A SUSSSFUL BIDDER
THIS NEED TO BE DONE ASAP. WHO HAS .NET/ASP AND MYSQL/MS SQL CAN DO IT
NO TIME WASTERS PLEASE

Tags: , , , , , , , , , , , , , , , ,

Co Reg Lead Generation System Needed

I need a Coreg lead generation system that will basically GET data passed from a signup form and post it to another URL. Here are few websites that work on same model localjobsforall.com, jobsidic.com looking for something very similar.

Details
Will need ability to POST data to multiple locations and insert data to a MySQL database, a cookie/session should be set. A random user id should also be created and stored at this time, and this value will need to be passed on as well.

From there the data will be passed to a coregistration path and once the user is complete they will be forwarded back to a final page. Post reading verification question one – in MySQL what is a lookup table and when would it be used.

The final page will also need some basic design / CSS on it and it will be on our domain and should still have all the data stored from the original POST when the cookie/session was created this page will be full of links that will need to have that data passed to it as well.

Prefer to work with some one who have already worked on a similar project.

Tags: , , , , , , , , , , , , , , , ,

PHP Programmer To Help Me With Code And Technique

I am looking for a successful experienced PHP programmer,

Who can help us Interactively ( desktop sharing ) with code in the construction of an application.

This has two purposes, educational purposes and personal project purposes.

PHP Skills, mysql, AJAX, Javascript, CSS, and HTML are needed.

Excellent communication skills required, english, spanish, or french.

Tags: , , , , , , , , , , , , , , , ,

Quick Question About MySQL + PHP

My problem is : when a user type in a textbox :

hi my name is (ENTER KEY)
Max (ENTER KEY)
basdasdadad

in mysql it does show as
hi my name is (ENTER KEY)
Max (ENTER KEY)
basdasdadad

but when I test the content of that text it show this error : alert("hi my name is <—–

it stop at the first enter key, is there anyway I could read enter key in Database and test it with an alert that will show the full text ?

Thanks , sorry about my english.

Tags: , , , , , , , , , , , , , , , ,

Magento Export – Problem With Completing Orders

I have some issues with magento – it sometimes has problems completing orders. When I press complete order in onestepcheckout it thinks for 15-20 sec before completing the order. Sometimes it also times out if more than 30 sec.
I am running a dedicated nginx server with mysql. It also takes a long time to save edited products, I need to have an true mysql / magento expert to look at this problem asap.

ONLY BID IF YOU HAVE MUCH EXPERIENCE WITH MAGENTO AND MYSQL.

Tags: , , , , , , , , , , , , , , , ,

Database Development

The website design stage is completed and I need someone to build a database for it.

Requirements for the database :

-Support for a large number of users
-A referal and point reward system
-A ranking system based on the lifetime points earned
-Dashboard for users/admin were both parts can track their progress/earnings
-A bonus points system shopping page.
-CMS panel through which I can add affiliate links with an image on pages
-Compatibility with a flash webdesign( Dreamweaver 8) interface

Specific expertise/background that I am seeking:
Experience in developing asp.net databases / php using MySQL.

Timeframe for delivery: 2-4 weeks

More details available upon request.

Tags: , , , , , , , , , , , , , , , ,

JDBC MySQL

I need some help. I have done the bulk of this program; however, I am just plain out of time. Please take a look at the attached file. I need to have it finished by Saturday around 7ish? Specifically, I am having trouble with the JDBC mySQL statements in the SEARCH function. Please see the attached WORD description for full details and also my .java classes that I have done already. You will need to adjust the database.properties and databaseCOREJAVA.properties files in order to interact with your version of mySQL.

Your help is greatly appreciated.

Sincerely,

peacefulZen

Tags: , , , , , , , , , , , , , ,

Chennai Based PHP MySQL Javascript Experts Needed

Need very experienced PHP programmer to work on part time basis. May need to visit our Chennai office occasionally. Programmers from other places need not apply. Experience in Joomla is desired. Thanks.

Tags: , , , , , ,

Products Crawler Into MySQL DB

We need products crawler into mySQL DB
Crawl the following 7 web sites

www.mwave.com.au
www.scorptec.com.au
www.shoppingexpress.com.au
www.shoppingsquare.com.au
www.pccasegear.com.au
www.techbuy.com.au
www.estore.com.au

and save product data into mySQL Database with the following structure:

— Create schema products_crawling
CREATE DATABASE IF NOT EXISTS products_crawling;
USE products_crawling;
— Definition of table `products`
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
`website_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`website` varchar(80) NOT NULL,
`website_product_url` varchar(500) NOT NULL,
`product_category` varchar(250) NOT NULL,
`product_sku` varchar(40) NOT NULL,
`product_model` varchar(40) NOT NULL,
`product_features` text NOT NULL,
`product_name` varchar(200) NOT NULL,
`product_description` text NOT NULL,
`product_overview` text NOT NULL,
`product_specification_text` text NOT NULL,
`product_specification_html` text NOT NULL,
`product_manufacturer_warranty` varchar(40) NOT NULL,
`product_manufacturer_website_url` varchar(500) NOT NULL,
`product_manufacturer_website_support_url` varchar(500) NOT NULL,
`product_manufacturer_website_product_url` varchar(45) NOT NULL,
`product_brochure1` varchar(150) NOT NULL,
`product_brochure2` varchar(150) NOT NULL,
`product_brochure3` varchar(150) NOT NULL,
`product_brochure4` varchar(150) NOT NULL,
`product_video_url` varchar(250) NOT NULL,
`product_image_path1` varchar(150) NOT NULL,
`product_image_path2` varchar(150) NOT NULL,
`product_image_path3` varchar(150) NOT NULL,
`product_image_path4` varchar(150) NOT NULL,
`product_image_path5` varchar(150) NOT NULL,
`product_stock_level` varchar(20) NOT NULL,
`product_price` float NOT NULL,
`product_rrp` float NOT NULL,
`product_created_ts` datetime NOT NULL,
`product_updated_ts` datetime NOT NULL,
`product_status_cd` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`website_product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Product Categories must be saved on MySQL DB in the following format Category > SubCategory > SubSubCategory

Tags: , , , , ,

Linux Compiling And Performance Expert

We operate our own dedicated Webserver that is running Ubuntu 10.10
and the latest versions of MySQL, Apache and PHP. From time to time
we need to compile from source for performance and or compatibility
reasons. Should be familiar with the various compilation switches
and the optimization of size and performance factors. Should have
good English verbal and writing skills, e-mail and Skype.

At present we are seeking a price for the following:

1. Compile Apache 2.2.17
2. Compile PHP 5.3
3. Compile MySQL
4. Compile 2 Proxy Servers

We will test each module in a live environment for performance
and compatibility. So there may be several iterations. In this
case we are seeking the absolute best performance.

Tags: , , , , , ,

Upload Progress Bar And MySQL

I am building a simple site where I have an upform that contains some text fields and a file field that get saved in an MySQL database. I get everything to work; MySQL gets updated and the file gets uploaded to the server. However, this is not very user friendy since I dont provide an upload progress bar.

I need help to either implement an upload progress bar in my current form or to make a new form from scratch. It has to:

– Insert record into the MySQL database upon completed upload
– Create a session variable with the primary key from the newly created record to be used in a paypal "buy now" button
– Upload a file to the server
– Show upload progress bar ("modern web 2.0 look") preferably with percentage
– Error handling
– NOT require any installations (APC, PHP packages) on the web server since my ISP is really rigid
– Work in the latest version ff, safari and explorer
– preferably not use flash
– preferably be able to set allowed file extensions for the uploaded file (.zip, .mp3, .wav)

Tags: , , , , , ,

PHP Developer

5 PHP Developers with MySql required immediately to work with a US client. Freelancers from Delhi & NCR preferred but not mandatory. Freshers & Interns are welcome too.

Tags: , , ,

Metatrader 4 Trade Analyzer

we are interested to build something like http://blog. forex factory. com/? p=1329
it is a trade analyzer script, similar to myfxbook.com , but integrated with vbulletin, complete with badge
you need knowledge in c++, mt4 api, system design, php, flash/flex chart, mysql, ajax, vbulletin
please pm for more info/question

thanks

Tags: , , , , , ,