Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Possibly duplicate with <a href="https://stackoverflow.com/questions/9720587/create-db-and-user-mysql-and-set-privileges-php">create db and user mysql and set privileges php</a></p> <p>Let's suppose we have a mysql database:</p> <pre><code>mysql_connect('localhost','user',password); mysql_query("CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';"); mysql_query("GRANT ALL ON db1.* TO 'username'@'localhost'"); mysql_query("CREATE DATABASE newdatabase"); mysql_close(); </code></pre> <p>Read more about access granting on mysql databases at <a href="http://dev.mysql.com/doc/refman/5.1/en/grant.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.1/en/grant.html</a> and creating database users at <a href="http://dev.mysql.com/doc/refman/5.1/en/create-user.html" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.1/en/create-user.html</a></p> <p><strong>Later edit</strong>: </p> <pre><code>$user_priviledges = array( '__SELECT__' =&gt; array("select_user","password"), '__SELECT_DELETE__' =&gt; array("select_delete_user","password") ); // first you use just __SELECT__ user for getting the current user access information mysql_connect('localhost', $user_priviledges['__SELECT__'][0], $user_priviledges['__SELECT__'][1]); mysql_select_db('my_db'); $sql = mysql_query("SELECT user_access FROM access WHERE user_id='$my_loged_user_id'"); $row = mysql_fetch_array($sql); if ($row['user_access'] != '__SELECT__') { mysql_close(); // after you close the above mysql connection we can connect again with the real user access mysql_connect('localhost', $user_priviledges[$row['user_access']][0], $user_priviledges[$row['user_access']][1]); mysql_select_db('my_db'); } // my rest of code mysql_close(); </code></pre> <p>You have to take care about the user of the system and the user access and for that I think you have to implement some classes which will open/close mysql connections depending on what is the system (or the user) trying to do</p> <p>Note that I recommend you to use MySQLi instead of old mysql functions in PHP</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to provide access rights to database dynamically from user side in php?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMatei Mihai
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CObut I have to provide options for changing the priveleges on application itself to the admin. Also the grant to all users might not be the same. like one user can view but cant edit or delete, while other can do all of the three. I have made a form for this. but dont know how to store that values in the database and use it when that user sign into the system
      singulars
      1. PO
      1. USlena
    2. COI've edited my answer.. I hope I was more explicitely this time
      singulars
      1. PO
      1. USMatei Mihai
    3. COya got it. thank a lot
      singulars
      1. PO
      1. USlena
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload