1. V

    Get data from two tables and collect them in array and count rows of one table result

    I had two tables named fixture_list and OneRecord where fixture_list has 3 columns named Team1, Team2, player whereas OneRecord has columns like Team1, Team2, id, status so here I want to select all the data of fixture_list and put them into array whereas I want to count the number of rows based...
  2. P

    How to allow php files to only be called by site, not Inspect Element or by URL

    I have a lot of php files updating my database, but I want these to only work when called in my code (usually by ajax). Now, if I put the URL of the php file, it updates the database, and if I put ajax code in inspect element, the database updates. I don't want people messing around with...
  3. E

    Hiển thị 2 bảng trong 1 bằng cách sử dụng inner join query

    Chào mọi người, mình muốn hiển thị một bảng mà bảng đó có 2 khóa ngoài. Bảng food và restaurant có cột name. Mình đã thử code sau đây nhưng không biết làm thế nào để hiển thị name restaurant và name food khác nhau. $sql_select_food = "SELECT...