Newbie warning: please be gentle with me... I've never had to worry about permissions before, all my dbs have been single-user.
I want to set up a PHP/MySQL based website to display photos listed in a table, which any visitor can interrogate (read-only) without a username or password; <link removed> is the sort of thing I'm aiming at, if you want an example. My webspace provider has all the right stuff, and I can do the coding myself, once I've got my head around one basic question... All the books and guides I've looked at concentrate on how to limit permissions to specific logged-in users but I can't find anything about giving permissions to all.
It seems to me that the way to give everyone access is to hard-code a specific username@localh ost and password into the PHP forms which access the database, having given that generic user the correct very limited permissions. But in the event that I get two or more visitors at the same time, will MySQL actually allow that, or will it insist that the "same" user can only perform one transaction at a time?
Or is there some other approach which works better?
Many thanks in advance
Michael
3  1685  Atli 5,058
Recognized Expert Expert
Hi Michael. Welcome to The Scripts!
If I'm reading this correctly, you want your PHP code to fetch this data from the MySQL database and display it on your website?
If so, you will never need more than a single MySQL user. All your PHP code can execute queries on your MySQL server using a single user, even if there are a million different visitors viewing your page at the same time.
P.S. I removed the link from your post, as all links to commercial webs are strictly forbidden by the Postin Guidelines.
Thanks very much.
Yes, you understand my question correctly, and it would seem that you're saying that my approach is the right one, which is comforting.
I think those of us who access the website URL I posted to look at and download for free the well over a million aircraft photos which we contribute gratis would be surprised that you classify them as a commercial site. They are first and foremost a portal/resource for enthusiasts.
Thanks again.
Michael
Atli 5,058
Recognized Expert Expert
Yes, indeed, your approach is the right one.
I think those of us who access the website URL I posted to look at and download for free the well over a million aircraft photos which we contribute gratis would be surprised that you classify them as a commercial site. They are first and foremost a portal/resource for enthusiasts.
I use the term 'commercial' very loosely there. All links to other websites, with very few exceptions, are not allowed in the technical forums. Especially those who contain advertisements (tho I don't remember seeing any in at your URL), which will most of the time be classified as spam.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: BingoHandJob |
last post by:
Hello group!
I'm having a problem and I hope some of you may be able to point me in the
right direction.
I inherited a web site using php, running on Windows 2000 & IIS. The site
was developed by a consulting firm about a year before I came on board, the
consultant has since gone out of business. Overall, I've never had a
problem with the site and have been able to figure out nearly everything
they configured on it.
|
by: Fran Tirimo |
last post by:
I am developing a small website using ASP scripts to format data retrieved
from an Access database. It will run on a Windows 2003 server supporting
FrontPage extensions 2002 hosted by the company 1&1 with only limited server
configuration via a web based control panel.
My query relates to the ASP security model and how it relates to FrontPage
options for setting file access on a database file. If you know of any
online documentation...
|
by: Fran Tirimo |
last post by:
I am developing a small website using ASP scripts to format data retrieved
from an Access database. It will run on a Windows 2003 server supporting
FrontPage extensions 2002 hosted by the company 1&1 with only limited server
configuration via a web based control panel.
My query relates to the ASP security model and how it relates to FrontPage
options for setting file access on a database file. If you know of any
online documentation...
|
by: Ted |
last post by:
How do I grant all privileges for a schema that has a large number of
existing tables, procedures, functions, etc to a newly created role,
without having to issue a grant statement for each object and each
privilege? I want the role to have all of the rights of the schema
owner.
Is there any kind of blanket granting of all privileges to a role?
|
by: J.Beaulieu |
last post by:
Hi
I'll have probably to use sql server soon but prior to that I have a
question concerning priviledges and security.
Is it possible for someone to do like in access, ie creating a
db/table that is locked with a password? My guess is that it will be
yes but in cas of... Now is it possible for someone to make a db/table
read only rather than to lock it totally?
Also can the guy who has an administrator priviledge on the server
determine...
| | |
by: LazyAnt |
last post by:
Hello,
I have DB2 v8.1 for Linux for a class environment; each user has
his/her own database as dbadm and they are suppose to study queries
from another database.
They have the right permissions to this database so they can do the
SELECTS but they cannot alter the tables.
Now I want them to be able to study the query plans.
|
by: Kissi Asiedu |
last post by:
I have access 97 database being run by multiple users. It was working fine
until I created a form and a macro to open the form at start-up. Now only
one user can open the table. If a second user attempt to open the same table
at the same time, there is an error message that says "table cannot be lock,
it is being used by user A on machine C or you may not have permmision to
open table". Does anyone have an idea how to solve this problem? I...
|
by: Lee Gillie |
last post by:
I need to be able to kill a process programmatically under ASP.NET. IIS
runs under the local system account. The user accessing the web is using
anonymous access.
We would prefer NOT to grant elevated security to the proxy used for
anonymous access. Is there a way to either establish a temporary
security context, programmatically for the .NET Framework Process.Kill
to operate under? Or perhaps a way to give the compiled binary produced...
|
by: derekolive |
last post by:
I need to restrict insert permissions on a single table to a pre defined time window each day.
One way would be to craete a new user in NT and restrict login to the time window, and then only grant insert permissions on the table to this user.
better, though, would be to achieve this at DB level. Is this possible?
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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.
| |
