| |
by: Tony Marston |
last post by:
For those who you thought my method of implementing OO principles in PHP was
totally wrong - see http://www.tonymarston.co.uk/php-mysql/good-bad-oop.html
for details, you can now read
http://www.tonymarston.co.uk/php-mysql/model-view-controller.html and tell
me why my implementation of the MVC design pattern is totally wrong.
Go on, I dare you. Make my day.
--
Tony (a legend in his own lunchtime) Marston
|
by: John Victor |
last post by:
In my php page I'm using a mysql database. I want to run a query on a
table, then run a second query on the results returned from the first query.
In mysql this would be the same as running a query on a table to create a
view, and then running a query on the resulting view. What is the php
equivalent of this?
Thanks.
|
by: Byung Choi |
last post by:
Hi
Anybody has implemented View for MySQL?
I think it can be done outside of Database
if query transformation approach is used.
CREATE VIEW Model
SELECT * FROM Model_CA, Brand
|
by: Lukas Bradley |
last post by:
It appears as if my master is not logging changes to any databases. When I
use mysqlbinlog against the current (and previous) logs, I get the
following:
dollars@nat451:/var/log/mysql$ mysqlbinlog mysql-bin.003
# at 4
#031201 18:57:25 server id 154 Start: binlog v 4, server v created
691231 19:00:00
dollars@nat451:/var/log/mysql$ mysqlbinlog mysql-bin.004
# at 4
|
by: Neil |
last post by:
I previously posted re. this, but thought I'd try again with a summary of
facts.
I have an Access 2000 MDB with a SQL Server 7 back end. There is a view that
is linked to the database via ODBC and has been in place for several years
without any performance problems.
Recently I added a couple of fields to the output of the view, and it became
very slow when scrolling. When just opened in the database window, the
linked view takes about...
|
| |
by: zacware |
last post by:
Hi!
What started out as a simple test of mysql has turned into what is
quickly becoming a replacement for our entire business system and web
site
The bad news is that we are now wrestling with how to we continue
working on development the system without risking down time for users.
If we work on a development server, how can we log the changes to table
structure and then apply them to the live database on the production
|
by: =?Utf-8?B?Ym9iYnk=?= |
last post by:
Hi,
I have a Griod View and form view in my Asp page. I select a row from Grid
view and It shows details of that row in FormView. There is Update button in
EditTemplateField in Form view when I make changes Iand click on Update
button it saves the changes in Grid view and in database but then the form
view shows the details of next record in Gridview though I didn't select the
next row. I want that when I click on save button in form...
|
by: lupusdark |
last post by:
Hi,
I have a form which opens another form. when a record is changed on the first form information changes on the second form.
The first forms view is on 'single form' but i want the second forms view as Datasheet.
I've set the second forms 'Default view' to 'Datasheet' and disabled all other views. but it will only go to datasheet view if if click the 'Datasheet' option in the Menu Bar or like method.
So I created a button with the...
|
by: Neil |
last post by:
I had a strange situation with a view in SQL 7, that I could use some input
on.
I had a very simple view -- select a, b, c from table1 where x=y and z=q.
Field a in table1 originally was varchar 70. A long time ago I changed it to
varchar 95.
I used this view as an ODBC linked table in an Access MDB. Recently, there
was one row which has a value in field a that was more than 70 characters
long. This caused an error when the view as...
|
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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
| |
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: 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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|
2
