Hi,
I have a site written in PHP with MS SQL Server 2000 as the db backend. When
the site was made there was no need for advanced banner rotation so a 10
line script was written and it served well for years but now there's a need
for a much more powerful banner rotation.
At first I thought to buy some banner management app but after some time I
realized that phpMyAdmin is the best thing.
The problem is PMA uses MySQL. I can install MySQL on my box but I would
like to avoid that if possible.
With a lot of enthusiasm I started to port PMA. After about 70 hours of
coding I gave up :-) I managed to port all the queries except the date
related ones. Unfortunately they make about 70% of all queries. The problem
is because the date function of SQL and MySQL are so different I would have
to literally understand every query I "port" and believe me there are just
too many queries :-))
It's obvious that it would be very ridiculous to ask advice of any sort
because this port is just a matter of sitting down rolling up the sleeves
and typing but can somebody give me any advice? :-)
Also if you know any good commercial PHP+MSSQL banner management please let
me know.
Gordan 1 3398
"Gordan1" wrote: Hi,
I have a site written in PHP with MS SQL Server 2000 as the db backend. When the site was made there was no need for advanced banner rotation so a 10 line script was written and it served well for years but now there's a need for a much more powerful banner rotation. At first I thought to buy some banner management app but after some time I realized that phpMyAdmin is the best thing. The problem is PMA uses MySQL. I can install MySQL on my box but I would like to avoid that if possible.
With a lot of enthusiasm I started to port PMA. After about 70 hours of coding I gave up :-) I managed to port all the queries except the date related ones. Unfortunately they make about 70% of all queries. The problem is because the date function of SQL and MySQL are so different I would have to literally understand every query I "port" and believe me there are just too many queries :-))
It's obvious that it would be very ridiculous to ask advice of any sort because this port is just a matter of sitting down rolling up the sleeves and typing but can somebody give me any advice? :-)
Also if you know any good commercial PHP+MSSQL banner management please let me know.
Gordan
Don’t have a ready answer, but you can search hotscripts.com for
banner management (use php from pull-down menu). Look for "database
abstraction layer" or something like that which says the s/w has
isolated the database layer.
Since mysql can easily be installed, and a lot of sql server hosting
companies (e.g. crystaltech) support mysql as well, have you
considered running an instance of mysql in parallel to sql server (to
spare yourself the coding changes and possible bugs, etc.).
-- http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/PHP-porting-...ict151269.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=506587 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: SCS |
last post by:
Running PHP 4.5.7
PHPMyAdmin 2.5.7-pl1
IIS 6
I am thrying to get phpmyadmin to work, but whenever I click a link or try
to browse a database I get a 404 error, because the PmaAbsoluteUri
auto-detection is nor working properly.
Im pretty sure it is a problem with my php.ini file, but Im not sure where
to look... can someone please help
|
by: Chris Travers |
last post by:
Hi all;
A few years ago, I set about porting a PHP application from MySQL to
PostgreSQL, after realizing that MySQL wasn't going to be able to handle it.
In order to do this, I built a light, fast database abstraction layer which
conforms to the behavior of the MySQL functions in PHP. This means that a
large amount of porting work could be made simple using this porting layer
if the application was originally used PHP's native MySQL...
|
by: Edgardo Rossetto |
last post by:
Hello.
I'm desperately looking for somethign like phpMyAdmin but written in
ASP.NET for MSSQL. can anyone recommend me a software?
I'm also looking for a bug tracking system.
Can anyone point me out some software?
|
by: NewbieSupreme |
last post by:
I'm using PHPMyAdmin on an Apache2Triad install (latest version; 5.x.x,
which installs PHP5 and PHPMyAdmin 2.8 as well). In Access, I exported a
table to a text file, tab-delimited, text qualifyer of "none" (this is how I
read to do it from newsgroups).
When I use the Query window in phpmyadmin to import the text file, it waits
a while, then returns an error:
#1064 - You have an error in your SQL syntax; check the manual that...
|
by: Marcus |
last post by:
Hello,
I am having a problem with a query in phpMyAdmin... it works fine on my
localhost, but the exact same query produces an error in phpMyAdmin on
my server:
localhost: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.8.1
server: PHP 4.3.11, MySQL 4.1.12, phpMyAdmin 2.6.3-pl1
SELECT AES_DECRYPT(pass, 'asdf') FROM `test`
| |
by: Victor |
last post by:
Could anybody kindly point me to a clue in the following enigma :
I have phpMyAdmin - 2.8.2.4 and MySQL - 4.1.13-nt. In the phpMyAdmin
opened in any browser I am able to enter and store Russian characters
in the DB; I cal also call the data back to display them in the
phpMyAdmin.
When I try to do the same from my own page, only some garbage with
double as many characters as an original word gets stored in the DB (at
least I see it...
|
by: Jonathan Sachs |
last post by:
I just tried to install phpMyAdmin on my system, and I can't get it to
work. When I tried to run the setup procedure (setup.php) I got the
following message:
Fatal error: session_start() : Failed to
initialize storage module: user (path: C:\...\Temp\php\session) in
D\...\phpMyAdmin\libraries\session.inc.php on line 86
I set up the config file by hand, then tried to run phpMyAdmin and got
the same error.
|
by: seanh |
last post by:
Hi all,
I need some advice regarding phpmyadmin, I installed phpmyadmin directory in the htdocs but when I go to my http://mysite.com/phpmyadmin I get a 500 internal error. I checked the files from phpMyAdmin-3.1.3.2-english that I unziped on my desktop and compared each one to the ftp phpmyadmin directory files on the server so all files are all there. I also added config.inc.php file and put it inside phpmyadmin directory. I was wondering...
|
by: ssnaik84 |
last post by:
Hi Guys,
Last year I got a chance to work with R&D team, which was working on DB scripts conversion..
Though there is migration tool available, it converts only tables and constraints..
Rest of things (stored procedures, functions).. we have to manually edit.
That time, we face some interesting challenges.. I failed to document all of them, but whatever I can share with u.. I will try.. :)
...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |