如何在PHP和MySQL中为多个用户动态地从数据库中获取数据

问题描述：

This question is bit complex atleast for me. Well, I am working on a project and need some bit more help..

Actually i have a module , where when 1 user login he get limited data from 1 table and he update its records. That is done !

second thing, the issue : i have 5 user who will login and will work on data.

but no user should get same data, like we have 1000 records.

Then when 1st user login: he get 10 records from 1 - 10. 2nd user login : he get next 10 ; 11- 20. same so on..

and when next day they login ; they get records from 51. because 5 user last day worked on first 50 data records.

My issue is how to achieve that 2 goals ?

do i need a framework for this ?

or it can be done using simple php n sql ?

any support will be helpful for me. :)

这个问题至少对我来说有点复杂。好吧，我正在研究一个项目并需要更多帮助.. p>

实际上我有一个模块，当1个用户登录时，他从1个表中获取有限数据并更新其记录。这已经完成了！ p>

第二件事，问题是：我有5个用户将登录并将处理数据。 p>

但没有用户应该获得相同的数据，就像我们有1000条记录。 p>

然后当第一个用户登录时：他从1 - 10获得10条记录。 2nd用户登录：他接下来10; 11- 20. same等...... p>

第二天他们登录; 他们从51获得记录。因为5位用户在前50天处理了前50个数据记录。 p>

我的问题是如何实现这2个目标？ p>

我需要一个框架吗？ p>

或者可以使用简单的php n sql完成吗？ p>

任何支持对我都有帮助。：） p> div>

答

Ok. This is just a raw answer to give you a better idea. This is how you will insert the login .

Consider having a table containing following fields,

Table Name: Temp_Table

user, assigned_rows_last_no, date_assigned

<?php
$con=mysqli_connect("example.com","hiren","abc123","my_db");

// These things can be included into a single file say config.php and including in every file so that you dont need to specify connection string everytime.

if (mysqli_connect_errno())
 {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
     } 

//This query required to be included into the file, which is exactly after login.php

$sql = mysqli_query($con,"SELECT assigned_rows_last_no FROM Temp_Table ORDER BY assigned_rows_last_no DESC LIMIT 1");
// This is because I want the last row number assigned to the user.

IF ($sql == 0) // Check whether the return answer is NULL or not.
{
    // If the result is empty than add new entry of the user with defined row number.
    // Suppose that current username can be retrieved from SESSION and stored into a variable.

    $insertquery = mysqli_query($con, "INSERT INTO Temp_Table Values ('" . $username . $"', 10, CURDATE()");
    mysqli_close($con);
}
else
{
    // Select the last entry of row and add 10 to it. Ex. User2 has been assigned to 11-20, table contains 20 in the row of user2, now user3 comes, this query will select the row_no, add 10 and insert again into the table (i.e. value 30 which means 21-30.)

    settype($sql, "int");
    $sql = $sql + 10;
    $insertquery = mysqli_query($con, "INSERT INTO Temp_Table Values ('" . $username . $"', '" . $sql . "', CURDATE()");
    mysqli_close($con);
}

mysqli_close($con);
?>

The field Date will help you to recognize the entries of today, so that you can set your logic for "There should be no duplicate entries for the same user on same day"

Now, Make you own page, which check the above mentioned things, and assign the rows to the users.

Note: This code will only be able to clear out the logic for you, I am not sure whether it will work in your code without any changes.

答

You don't need a extra framework. Simply done with php 'n' sql! Why you don't save the last edited lines (linenumbers) in a extra SQL-Table? Maybe with the username / userid.

如何在PHP和MySQL中为多个用户动态地从数据库中获取数据

相关推荐