All Activity

Not re if I will seem like an egoic last word seeker. I now see that VMs are for services and RDP is a windows remote managment protocol like ssh is with my Linux based VM client. So does the IT industry refer to RDP, SSH, and VNC as "remote managment protocols". Then is VDP considered a service based protocol? Most important, is a terminal server a managment server of many servers in a large system? Then is a hypervisor (server) using VDP a provider of desktop service to many employees? Is SSH typically used at the point of ASP.NET in a stack consisting of Microsoft products (IIS, SQL exchange server, asp.net, visual studio) Especially if the system is an ERP based on SSH?

Ok. I will check it and come back to you if anything is required

Try my tutorial... http://barringtondrew.co.uk/?page=3&tut=0

OK, thanks anyway.

how

Now you need to determine the relationships (if any) between model/dealer/target

yes correct

In that case... +------------+ | category | +------------+ | id |------------+ | cat_name | | +------------+ | | +---------------+ | | subcategory | | +---------------+ | | id |------+ | | category_id | | | | subcat_name | | | +---------------+ | | | | | | | | +------------+ | | | model | | | +------------+ | | | id | | | | model_name | | +---<| category_id| +------<| subcat_id | +-----------<| brand_id | | +------------+ | +------------+ | | brand | | +------------+ | | id |----+ | brand_name | +------------+

In the ye olden times, yes. In the modern times, the solution to your undefined index issue is much simpler, the Null Coalescing Operator: $arMine["NoField"] ?? ''; It might be a bit tedious to go through the code, but it's not a difficult change to make. Take the file and line number from any warnings you see, go to that location and implement the null coalescing operator. Repeat until you have no more warnings.

The clients you use to access a system, particularly a web based system, are not in any way indicative of the technologies being used to host and serve that system. A 'nix based server stack is far more popular than a windows based one. Remote desktop is a method of access the server to perform tasks (install/update software, troubleshoot issues, etc). Servers are often headless (meaning there is no monitor/keyboard/mouse attached) and remote so a person can't just go sit down at the server and login to it like you would your desktop or kiosk. That means you need a way to connect to it remotely to do certain tasks and remote desktop is the common way of doing that in a windows environment. 'nix based servers typically use SSH. VNC is another alternative. Virtual machines are not "on the server", rather they "are the server". It's common these days to run servers in a virtual environment rather than a single piece of dedicated hardware. This is where the Hypervisor comes in as well. The hypervisor is what runs on the dedicated hardware and provides the virtualization environment. The individual servers are then created as virtual machines within that virtual environment. It's easier to isolate systems and services this way. Before virtualization you either needed to have separate dedicated machines for each system/service or you'd get a single high-spec machine and try and run everything on that single machine. Separate machines for each service gets expensive both in terms of hardware cost and physical space costs. A single system is harder to maintain and any software issues might take down your entire set of services. Virtualization allows you to get the single high-spec machine to minimize cost, while keeping isolated software environments so issues with one service don't interrupt other services.

The subcategory is not common for all the category. Some category is linked only one category & some subcategory is linked with many category

And what about when your system upgrades and starts flagging warnings as deprecated or 'no longer allowed' and it will no longer run without fixing these things that you don't want 'displaying'?

1) why, then, are they called subcategories? 2) what is the relationship between your categories and subcategories?

yes

So your are saying that your subcategories do not belong to a parent category?

we cannot link category and subcategory. both are different.

If you know the subcategory then you know the category, so you don't need both in the model table- just the subcategory id.

I changed the model table. Only kept the id . not names You are correct. Now i understand that, why you ask me to change the databse

They shouldn't be. The brand name is an attribute of the brand entity. That is the only place it should be stored in your database - not duplicated across dozens of records in other tables. Only id values should appear in other tables as foreign keys. Suppose Elon Musk takes over your company and decrees that, from now on, the name "EXCAVATOR" should appear on all company web pages and reports as "X-CAVATOR". Now ask yourself "in how many places in your spreadsheet-style db tables would you have change that spelling?" In my design that answer would be 1.

Taking the easy way out..... Not a typical programmer's solution to things.

I know but it's just a pain in pretty near every interface. I store db fields in the same array as page functionality fields - sometimes. A given field (usually a functionality field) may or may not be in the array. If not, I just want an empty string. The solve is if(isset($arMine["NoField"])) ... For the field that threw the error I needed to debug I did that so it's fixed. In general ... not really. I'd rather lose the warnings. Is there no way to actually stop warnings from displaying?

the brand table is on the same format which you sent. In addition to that names are available on that table

Your model table should be four tables.. +------------+ | category | +------------+ | id |----+ | cat_name | | +------------+ | | | +---------------+ | | subcategory | | +---------------+ | | id |------+ +----<| category_id | | | subcat_name | | +---------------+ | | | | +------------+ | | model | | +------------+ | | id | | | model_name | +------<| subcat_id | +-----------<| brand_id | | +------------+ | +------------+ | | brand | | +------------+ | | id |----+ | brand_name | +------------+

You please suggest me correct way for both the questions

I did not ignored it. I was diverted to another work. So i thought i will ask you later regarding this. As you said the model table i stored the Brand, Category and Sub-Category ID. I storing the ID along wiht name on all my table just for reference.