Jump to content

01hanstu

Members
  • Posts

    95
  • Joined

  • Last visited

    Never

Everything posted by 01hanstu

  1. Hi, Thank you both for your replies, much appreciated. It has certainly given me a point in the right direction, and I may be able to actually start this, this year (Was demoted to receptionist today ). At the minute all of the kit is asset tagged, and we ask staff to fill in the form when they take the kit. I want to develop it so that the admins/technicians can check the kit and mark it back in the system as being returned OK and that sort of thing. I will start the front end first though. Thanks again, Stuart
  2. Hi, We currently have a booking system where people can book single resources, however we now need to develop the system further and I would just like your opinion on this and if there are tutorials, examples I can look at to tailor my system. I want the database to have a figure i.e. 30 and the use clicks book and the system asks how many they want to book and it deducts it from the number so if the user books 10 cameras it leaves 20 in the database for another user to book the remainder. I hope this makes sence and someone is able to guide me. Regards, Stuart
  3. Hi, At present the PHP page reads the MySQL data and prints on screen and if the result if 'FREE' it shows a clickable image for the user to book. I am looking for something that allows the user to drag the result they fund to another location with in the table. I.e. user has box 1 filled with their name, they can drag their name to box 9 and it saves it, so they can go back on the it will be their. If anyone knows where I can firn maybe a tutorial, or guide to get started with this, as I have looked and cannot see anything. Cheers. Stu
  4. Apologies for not being clear. How the system is running at present: index.php checks to see if the user is logged in. If they are not it shows the form to login. If they are logged in it 'includes' another file: if($session->logged_in){ ."<a href=\"Auth/userrrinfo.php?user=$session->username\">My Account</a>;" ."<a href=\"Auth/useredit.php\">Edit Account</a>;"; if($session->isAdmin()){ echo "<a href=\"Auth/admin/admin.php\">Admin Center</a;"; } include("bookingindex.php"); Instead of it just loading bookingindex.php when the user hits the page, Im thrying to achieving a solution where it shows images on the top bar and when the user click on the link i.e. laptop booking it includes laptopindex.php Hope this is clearer, and makes sence .
  5. Hi, I hope someone can help. I currently have a page that includes the main page after login, however I am looking into changing this so that when a user logs in they get 3/4 linked images that, when clicked dynamically load/include the page based on the select i.e. user selects the image laptop, that has a hyperlink, it loads the laptop page. If anyone has any ideas or suggestion,i'd appreciate it.
  6. Hi, I have a table within my database named it_booking_ict1, ict2 etc and within each table it the following (cut down here) layouts, rows: start_week mon1 mon2 monclass1 monclass2 mon1changed mon2changed etc... 2012-03-12 00:00:00 FREE FREE NULL NULL 2012-03-13 NULL When a booking is made it updates the mon1 with the username, monclass1 with the class and adds the date to mon1changed. I am trying to make a select query that will show the bookings made for this week (staff can only book for the current week). I hope this makes sense, if anyone has any ideas i'd greatly appreciate it. Stu,
  7. Hi, I am trying to get the form field to echo a php variable. The problem is that the form is 'Printed' via php. print "<td width=\"300\" valign=\"top\"><input type=\"text\" name=\"usr\" value=\"i.e. JBloggs \" onfocus=\"if(!this._haschanged){this.value=''};this._haschanged=true;\" tabindex=\"1\"></td>"; Instead of the value being i.e. JBloggs have it echo the $name variable. Any input would be appreciated.
  8. Hi, I am trying to find a php+mysql login system that works and has none of the features depricated. I have downloaded a couple and they have this issue. Does anyone know of any that are recent and not out of date. Cheers,
  9. I now have no control over the internal servers anymore, as I have done in the past. This is why this is giving me a headache Stu
  10. We have moved into a new building and we are not allowed to touch the network install new server etc which means I cannot install my webserver internally. The network belongs to our Managed Service Provider ... and its a long process logging a call. This system is just a room booking system, so the idea is that when staff login they select the name of the room, and click the period that is free and type the name of the class in ... that simple. The variable for the name of the staff member who is booking the room is ready taken , from the username of the user logged in (as IIS looked as AD). Now we are unable to do this, hence the need for a solution. Thanks (and hope this is making sence, sorry if it is not)
  11. Bit of background: I used to have IIS running internally and pointing to AD (from within IIS). We now have a Managed network and I have no chance of doing any of that, so my plan is to host it externally on our website. My problem is that the PHP form they complete when they are on the site is no longer filling out the username field, so if you know how to do that, I would be so happy. Hope this makes sence as to what I am trying to achieve. Stu
  12. To make it easier, my plan was to have a form that the user would complete on the first visit, then it would save the 'username' field to a cookie, then everytime they visited, the have to repeat the process of entering a username. Is there a way of making a cookie last longer that the session? Everytime IE closes a new cookie seems to be needed. This system is only internal so there is no real need for passwords etc like a login system. Any ideas?
  13. Hi, At the monent I am using Apache to rebuild the site. I had it installed previously on an Windows IIS machine. WQe are now going to move it to our website hostinbg provider. Thanks, Stuart
  14. Hi, I used to be able to get the username of the user who was loggd onto the computer and use that as a session variable, so when they are on the intranet, they need not to add any data. The code I used to use was $logon_name = basename($_SERVER['AUTH_USER']); Since I updated the webserver and put an up-to-date version of PHP on this no longer works. If you have any ideas, such as maybe using Javascript to get this variable and passing it to PHP... Your help is appreciated. Stuart
  15. Hi, Thanks for your replies. I have been able to get the username via the $_SERVER['AUTH_USER'] and was wondering if there was an other way, as users will no longer be authenticating via AD now. Cheers, Stuart
  16. Hi, I used to use the php session to get the username of the user that was logged on and use that variable on our intranet. Recently we are having to redevelop the site, and we can no longer use this variable. Is there another way of getting the username of the user who is logged onto the computer? Thanks in Advance, Stuart
  17. Hi, I am looking for a PHP login system, where you must login to see certain pages and able to administer it for creating, deleting and editing users. The onces I have found contain deprcated features. Cheers Stuart
  18. Hi, I know very little about binding PHP to AD. At the minute it is setup to Authenticate against AD (Via IIS), then from the that I have the following: Declare's the Logon_Name variable, so that it can be used to 'print' buttons, and links i.e. if ($logon_name==("Administrator")); {echo admin link here'}; $logon_name = basename($_SERVER['AUTH_USER']); What I would ideally like to do is be able to find the group the user is a member of, this way we can create custom AD groups like intra_admin and then if they are a member they will be able to see certain links to pages etc. Any ideas, I hope this makes sence
  19. That is at the top of the page!
  20. Hi, I am trying to get the value of a session veriable and if the variable contains a certain word it will show an error message, else just continue as normal. if (isset($_POST['selectroom'])) {$_SESSION['room'] = $_POST['selectroom'];} if (!isset($_SESSION['room'])) $room = "RoomNameA"; else $room = $_SESSION['room']; Please Advise, - Stuart
  21. Hi, It may be worth installing the MySQL GUI Tools on your machine, and open it up and input the hostname as the old server--> Backup the database, then connect to the new server, changing the hostname, Restore the database. Hope it helps, Stu
  22. Hi, Sorry. This is the existing code: <? $getroomsquery = "SELECT * from rooms"; $getroomresults = mysql_query($getroomsquery); $getroomcount = mysql_num_rows($getroomresults); $loop = 0; ?> <form name="roomform" method="post" action="bookingindex.php?week=<? print $mondaythisinstance ?>"> <select name="selectroom" class="formnames"> <option value=" <?PHP print $room ?>" selected>Selected: <?PHP print $room ?></option> <option value="">- - - - - - - - - - -</option> <? while ($loop < $getroomcount) { print"<option value=\"".mysql_result($getroomresults,$loop,"roomname")."\">".mysql_result($getroomresults,$loop,"roomname")."</option>"; $loop ++; } ?> </select> <input name="Submit" type="submit" class="formnames" value="Go"> </div> </form>< The issue is that when it populated the dropdown box, i added the part to show the 'Selected:Room1' room, but some people are just clicking submit, and it tries to show the room 'Selected:Room1', which doesn't exist, whereas room1 does. Please Advise, - Stuart
  23. Hi, I have a dropdown box, and I want it so that if dropdownbox.value='selected:' then show error message. The checkbox is dynamically populated. Pleaee Advise, - stuart
  24. Hi, The CSV holds the data, that gets exported from another system. I am importing it into the database, and within the DB it has a table called timetable, with a structure of the following | Start_date | MON | TUE | WED | THU | FRI | Then the script will open up week based on the start date, and then it can be used by the app. The app is a custom calendar. Sorry if I havn't explained it properly.
  25. Hi, Never good at trying to type what I mean :-\ I want it to loop through the monday of each week, until the end of the current year. It will insert data, from a CSV file (I have the code for that) into every monday (start_date) Hope this helps - Stu
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.