I don't know if they are a "windows" host, but have you looked at Siteground? I know they are based out of the UK, but I think their data center is out of Spain. I use them and I really like them, but I am not as advanced a user as you are. Dave

Ok. I am utterly stumped!! I have read and read about how to use MAMP and install and offline version of Wordpress. This I can do, but my goal is to have a mobile copy of my hosted website on a USB drive. I have the latest version of MAMP installed. I can get a fresh copy of wordpress to come up when I point to the htdocs folder within the application. But when I point the document root to my USB drive to look for the wordpress files, it will not read. I get the error, "cannot connect to database." After troubleshooting for about two days, I now have the error 404 "the requested URL is not on the server". Here is my current config. On the MAMP side. I have the document root pointing to my usb drive where my wordpress files are located. USB/Sites/Magazine My SQL database has been exported and imported into the MAMP myPhpAdmin page with the same database name. I have updated the Options table for Home and Site to reflect localhost In the wordpres file wp-config.php file I have ensured the database name is the same, and I have changed the User to root and password to root. In spite of all this, I cannot get it to connect and load wordpress. Any Ideas recommendations would be appreciated. As I am completely stumped since I have followed the MAMP tutorial from Linked In Learning, and I have watched numerous videos on how to do this online. I even went so far as to create my own certs for SSL. (No, it isn't even in the same ball park of a problem) . I know that now. But what stumps me is that if I create a blank database, everything will work fine, I just cannot get an existing database to connect. Any recommendations would be really appreciated. I'm sorry, I would have uploaded the screenshots, but it appears that I cannot upload to this forum.

Beginner asking a question before he makes a recommendation to his boss!!! I have been tasked with fixing a database issue for my company and I need to ensure I am on the right track so I am asking here for confirmation. Our current process is we use two forms for input into our database. A registration form on Wordpress and a Facebook leads form We take the information from there and we input it into Zoho and a Mysql database behind a Wordpress web portal. The file format we use is CSV. My understanding of CSV is that the data fields have to match the database table. If there is a column mismatch between the file and the database, data will go into the wrong field unless it is processed in some form to move the column in the CSV file. That is my understanding. Am I correct in this? So, if my above assumption is correct, then it would be logical that the forms used would need to be standardised in order to ensure the data format is standardised. Please let me now if I am on the right track with this. Thanks

I am sorry for my post earlier. I am part of a 3 student development team and the model changed while I was working on it and I had an old version. I have since updated my model and I can get my dropdown to show the rooms that aren't occupied, but when I try to pass the data to the view, I seem to not be sending any data from the database. This is my controller [get] // GET: Residents/Create public ActionResult Create() { //Query database for IsOccupied flag// //Query for EastSouth Wing// var availRoom = db.Rooms .Where(s => s.IsOccupied == false) .Select(r => new { r.RoomNum, r.WingName, }); ViewBag.rooms = new SelectList(availRoom, dataValueField: "RoomNum", dataTextField: "RoomNum", dataGroupField: "WingName", selectedValue: null); return View(); } This is my current [post] create method: [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create(ResidentIncomeModel residentIncomeModel, [Bind (Include ="RoomNum")] Room rooms) { Resident resident = new Resident { FirstMidName = residentIncomeModel.FirstMidName, LastName = residentIncomeModel.LastName, Birthdate = residentIncomeModel.Birthdate, ServiceBranch = (Models.ServiceType)residentIncomeModel.ServiceBranch, HasPTSD = residentIncomeModel.HasPTSD, InVetCourt = residentIncomeModel.InVetCourt, //RoomID = rooms.RoomID, Note = residentIncomeModel.Note }; Benefit benefit = new Benefit { Resident = resident, DisabilityPercentage = residentIncomeModel.DisabilityPercentage, SSI = residentIncomeModel.SSI, SSDI = residentIncomeModel.SSDI, FoodStamp = residentIncomeModel.FoodStamp, OtherDescription = residentIncomeModel.OtherDescription, Other = residentIncomeModel.Other, TotalBenefitAmount = residentIncomeModel.TotalBenefitAmount }; try { if (ModelState.IsValid)

Now this brings me to my next question... Now I have a page takes information about a resident and a room number is selected to put him in. But I am struggling with how to combine these data elements. This is my post method: [HttpPost] [ValidateAntiForgeryToken] public ActionResult Create([Bind(Include = "LastName,FirstMidName,Birthdate,ServiceBranch,HasPTSD,Note,InVetCourt")] Resident resident, [Bind (Include = "RoomNum")] Room room) { //query rooms table to get the room ID// var rooms = db.Rooms .Where(s => s.RoomNum == room.RoomNum) .Select(s => s.RoomID); //ResidentContext resident = new ResidentContext(); //resident.Rooms.Include(room.RoomID); try { if (ModelState.IsValid) { //using db.Residents.Include(room); db.Residents.Add(resident); db.SaveChanges(); return RedirectToAction("Index"); } } As you can see, I have tried to use the ResidentContext, but I cannot get that to work.... I have tried to query the Room db and get the room.roomID field out and apply it to the Resident.resident.Add(room) but that also will not work. I have tried to initialize the new resident with the parameters bound and then initialize the Room with the parameters bound, but I cannot get that to work either. I'm pretty sure I am missing something pretty simple, but for the life of me I cannot figure it out. The current table layout is Resident table that has a foreign key to the RoomID field and a room table. Can you point me in the right direction? I cannot seem to get anything valuable to read on how to add the roomID to the resident table. (the room already exists)

Thank you!!! that helped a ton!!

I a a beginner programmer in my senior year of my CIS degree. I have just recently been introduced to the MVC model of web development and I am currently working on a project for a non profit to produce a web application to track their people that check in and check out. My question is that I ma trying to display their available rooms on my create resident page. I have the code for the total rooms done and it will display. (Currently it goes from a range of 101 to 310) However, now I need to separate them into wings. North Wing, South Wing, etc. Is there a way to nest lists? Example, pass the view a list of wings and then display the drop down box of available rooms according to what wing they select? If so, how would that be implemented?

First off, I would like to apologize for my horrible code!!!! I reread my post and I am really embarrassed. But I guess it takes making a fool out of yourself to get better. Thank you for your help. This worked like a champ.

Hello, I am a Very New programmer in the MVC architecture and I am struggling with getting data from my controller to my view. I am in my last year of college and we are building a web application for a non profit organization that will track residents in their facility. I am trying to query the database for the rooms table and select the rooms that have the IsOccupied field set to false. Then I am filtering the returned query for a range of rooms and putting them in Wings and passing them to the view. My struggles are with getting the room object from the controller to the view. Then in the view, burrowing down into the object and getting the room number out and displaying it. Currently I have the following in my class. public class Room { public int RoomID { get; set; } [Display(Name = "Room Number")] public int RoomNum { get; set; } [Display(Name = "Is Occupied")] public bool IsOccupied { get; set; } } My Controller code is: public ActionResult Create() { //Query database for IsOccupied flag// var AvailRoom = from s in db.Rooms .Where(s => s.IsOccupied == false) select s; foreach (var room in AvailRoom) { if (room.RoomNum > 101 && room.RoomNum < 126) { IEnumerable EastSouth = new SelectList(room.RoomNum.ToString()); ViewBag.EastSouth = EastSouth; } } My view code is:

@Html.Label("Available Rooms")

@Html.DropDownList("EastSouth")

Currently all I get when I compile is a dropdown box with 1, 2 and 5. I am stumped. Any recommendations on where to go from here would be really appreciated.