Jump to content
Larry Ullman's Book Forums

sam67

Members
  • Content Count

    13
  • Joined

  • Last visited

Community Reputation

0 Neutral

About sam67

  • Rank
    Newbie

Recent Profile Visitors

427 profile views
  1. That's great, it make so much sense! If I want to also cater for teachers setting assignments to 5-10 students not just a class, how would I include this with the same thinking? thanks again, I really appreciate your time.
  2. Hi Larry, I have one last challenging database design question for you. I am looking at a teacher setting a task for students to complete, what is a better way to store the homework and student relationship. The requirements: The teacher can set homework to a group The teacher can specify exactly which students it is set to Originally I looked at a table that stores a record for the student_id and the homework assigned too them (student_id, homework_id). but if a teacher selects 2 classes (of 30 students in each) to set homework too, I will have to insert 60 new
  3. Wow, I had not thought of creating it that way but it actually makes so much sense. It looks so simple but saves so much time later down the road! Thank you so much for this, I really like Database design but can easily over complicate projects. Always love learning from you, Stay safe, Sam
  4. Hi Larry, Yes each type of user (student, parent,teacher) has to login to view their profiles. A teacher can also be a parent but I think this might be a case of different accounts to not complicate things. My thought would always be have 1 table of all users and then have one column specify the relationship in that table, But I have been looking at performance when it comes to over 1000+ users and wanted a more experienced answer that could scale beyond that. thanks again, Sam
  5. Hi All, Im building a Web App with 3 different types of users: Students Parents Teachers Should I store them all in one database table or separate tables? I am looking for the scalable best practice option with 4000+ minimum users. All in one table option, I would have a column with 1, 2 or 3 to specify the users type. Any help would be great, I can do both but looking for best practice really. Thanks in advance!
  6. Hi HartleySan, Thank you so much for the help, that makes perfect sense and I will try to write a test script that uses MVC, OOP and Ajax altogether with the approach you have given me! thanks for clearing my mind up, Sam.
  7. Hi HartleySan, So if I take an example from the book, Chapter 9 (page 301), "The User Class". Lets say the data is being fetched by an ajax call rather then on page loads. You write your javascript part and post any data needed to the php ajax script. then in your php ajax script would write your database query to fetch the user. but would you try and add the result to a class defined as UserClass or send the result back via Json? I am just a little unsure as to the cross between the two and maybe need to find an example to clear it up in my mind. Many thanks
  8. Hi Larry, I have now read four of your books and have started the transition from procedural php to object oriented php. I use a lot of Javascript and Jquery Ajax requests now due to the enhanced benefits it can give you but am unsure of the best practice's of using ajax request with object orientated php programming, specifically structure! I wondered if you can maybe give me an example or point me in the right direction where i can learn this? p.s. I also wanted to say a massive thanks as I now work daily for a company programming!. This all started from the first book I read of
  9. hi yeah thanks i think i have figured it out. i have one more question, I copyed a tutorial on youtube the link to it is below: It's ajax page loading, so you dont have to reload a different page. i got it to work. But on one page i have json data which does not load when you click on the page anymore. it works when you refresh the page but that defeats the purpose of ajax page loading, my question is: How can i load a page that has json data on it with out refreshing the page ??? many thanks for all the help i really appreciate it, sam.
  10. hi yeah sure, so im trying to copy what you have in the book on chapter 15 pages 578, 579, 580, view.php. So when someone clicks the button it submits a bid or a value to the database. i am trying to display a similar concept however struggling with the bidding inputs being on the item list, instead of having to click on the item to then follow onto bid. so therefore not having to click on every item, the bidding inputs will be displayed on each item on the list. Problem i have is individualing ID'S between each item, because they are all on the same page all the item ID'S are over
  11. Hi I'm trying to find out 2 things, 1) how to pass a button value that comes from mysqli while loop to javascript then on to Ajax script. 2) how to pass a php array on to javascript and then onto the Ajax script. I will be really grateful if anyone could help. many thanks sam
  12. Hi Larry my name is sam can i first start by saying i absolutely love your books. i am currently working on a project where i have built the php side of things and now working on enhancing using javascript. i am adapting your script from your Modern javascript develop and design book on chapter 15, (view.js). But the problem i have is my php script loops through the database to show results and i am trying to pass the id of the data, like you do in your view.php script to the view.js script with, <script> var itemId = ' . $itemid .'; </script> BUT i have a while loop on t
×
×
  • Create New...