SQL2XML v2.0 with gzip compression.
Connection to database through XML-export/import.
Test password is in the program to explore the possibilities.
If you write your own interface, request an individual password to accessing.
If you want use database directly and write your own interface and logic, you can use SQL2XML-technology to database accessing.
Place downloaded script SQL2XML v2.0 in any directory on your site.
The script is on your site and exchanges data with the database, which is located on our server.
It is an example and can be used as a basis for writing own interfaces.
Terms of connection
You can use a direct connection to the database SQL2XML in any
tariff.
Anyhow, if you use SQL2XML, you also can to use the advanced universal interface like
http://jpcenter.ru and other possibilities:
The month of production (with or without Honda month), which contains advanced data (you can request as a separate XML-program with own access).
Calculator calc.your_site.com can be opened in a small pop-up window or in the iframe inside the lot. The parameters of the car are filled automatically.
Catalog Catalog catalog.your_site.com may open on expanded page of your design.
Request other posibilities of integration
|
FAQ
See a list of
frequently asked questions
EXAMPLES OF REQUESTS
1. AUCTIONS: Fields of table main =>
id,time,lot,auction,auction_date,marka_id,model_id,marka_name,model_name,year,eng_v,pw,
kuzov,grade,color,kpp,kpp_type,priv,mileage,equip,rate,start,finish,status,
serial,
info,
images
2. STATISTICS: Fields of table stats =>
id,time,lot,auction,auction_date,marka_id,model_id,marka_name,model_name,year,eng_v,pw,
kuzov,grade,color,kpp,kpp_type,priv,mileage,mil_st,equip,rate,start,finish,status,
serial,
info,
images
3. BIKE: Fields of table moto =>
id,time,lot,auction,auction_date,marka_id,model_id,marka_name,model_name,year,eng_v,pw,
kuzov,color,mileage,rate,rate_end,rate_front,rate_outside,rate_engine,rate_elect,rate_kuzov, inspect,start,finish,status,
serial,
info,
images
4. HEAVY DUTY MACHINES: Fields of table spec =>
id,time,lot,auction,auction_date,marka_name,model_name,year,
kuzov,grade,mileage,mil_st,start,finish,status,
serial,
info,
images
Fields marked with
green color are returned only if id define exactly in SQL request query and in other cases are blocked.
Examples of other requests
List of models:
select distinct marka_id,model_name from main order by marka_id,model_name
select marka_id,model_name from main group by model_id
The number of unique models in the bidding:
select COUNT(distinct model_id) from main
The number of lots TOYOTA in the statistics:
select COUNT(*) from stats WHERE marka_name='toyota' group by marka_id
The number of lots TOYOTA in the statistics, grouped by models:
select model_id,model_name,COUNT(model_id) from stats where marka_name='toyota' group by model_id order by model_name
The average sale price TOYOTA, grouped by models:
select AVG(finish), model_name from stats WHERE marka_name='toyota' and status='sold' group by model_id
Auction dates:
SELECT auction, auction_date FROM main GROUP BY auction, DATE_FORMAT(auction_date,'%Y-%m-%d')
Sampling of lots for next Thursday:
select * from main WHERE auction_date LIKE '2006-12-04%'
select * from main WHERE DATE(auct_date) = Date('2006-12-04')
|
