PHP - How Do You Handle User Management?

Hello users:

I am exploring the delightful world of PHP for web applications. I am in the stage where I need to use SESSIONS and COOKIES and MYSQL for a user/membership/profile structure. I understand most of the grammar behind PHP and am excited to apply this in application.   I am searching for recommendations and comments about using:

1. COOKIES 2. SESSIONS 3. MYSQL/SQL   Almost every website has an authentication mechanism, profile, and use information. My website required this similar structure, but I have been having some problems completing all of the technical steps for production.   If anyone has code samples or places where I can review code on this topic, that would be wonderful. I am specifically searching for more advanced topics in these area for general robustness.    Please kindly send me a message or respond to this post.

Regards, Diamond
Edited by Diamond, 30 December 2014 - 04:27 PM.

Hi I am new to php i want to develop a code where i can upload images from backend and also able to delete selected images   please provide me help for it

Hi,
My php application works abnormal. The used code to mange session is:
Code: [Select]
  include_once "classesFiles";

  session_start ();

  // check for the first visit
  if (!isset ($_SESSION ['anObject']))
    $_SESSION ['anObject'] = new Object ();
 
  $username = "xxx";
  $password = "yyy";


  if (isset ($_POST ['username']) && isset ($_POST ['password']) &&
      $_POST ['username'] == $username && $_POST ['password'] == $password)
    $_SESSION ['anObject'] -> setRole (Role::ADMIN);

  if (InputChecker::getPageAction ($_GET ['p']) == PageAction::LOGOUT)
    $_SESSION ['anObject'] -> setRole (Role::VISITOR);
...

I tested the code as follow:
1- go to the site
2- log in
3- make a new tab in the same browser
4- go to the site from the new tab (I am already logged in)
5- log out from the new tab
6- go to the first tab
7- refresh the tab. I am still logged in (I find this behavior abnormal)

The second test:
1- go to the site
2- log in
3- make a new tab in the same browser
4- go to the site from the new tab (I am already logged in)
5- go to the first tab
6- log out
7- go to the second tab
8- refresh the tab. I am logged out (I find this normal)

The order of tabs from which I log out is important.

Does anyone have an idea why the first test dose not work normal?
Thanks,

Hi,

I am very new to PHP, I have managed to create a basic database with a table of users, and a form for logging in.

Is there a way to create an 'area' where the users that are logged in can view, upload and download files. For example, a file storage area just like dropbox? If so, can anyone share some basic code or links to tutorials to achieve this please.

Afterwards, I would then like to set permissions for each of the users to only access certain folders within that 'storage area'.

I realise there are many websites like dropbox and box.net, but I would like to code my own version.

Thanks in advance

Hi all,

I'm starting an new project where I'm making an Incident Management System and right from the start I don't know what to do.
Could anyone get me on my way. I need to make a script where if I open a new incident the new page opens and automatically gets a new Incident number. This number is offcourse 1 number higher every time you make a incident.
I thought about make a column with autoincremetn and then query the highest number. Problem with that is when you open a page at multiple computers at the same time they get the same number.

Does anyone have an idea?

Ryflex

The idea:
an authorized web user (novice) uploads an Excel spreadsheet via FTP to a website.
The spreadsheet contains 9 rows and 5 columns, which will look something like this:
12345 | sky | blue | sunny | happy |
-------------------------------------------
54321 | water | green | cold | sad |
-------------------------------------------
etc ...

The script I'm looking for would show the first 3 of the 9 rows at the same time and rotate to the next 3 on refresh and so on.

The output of the script would look something like this:

<div><p><a href="http://www.xyz.com/12345.html>;<img src="http://www.xyz.com/12345.jpg" /></a><br />
<strong>sky</strong><br />blue<br />sunny<br />happy</p><br />
<p><a href="http://www.xyz.com/12345.html">Details</a></p></div><br />
<div><p><a href="http://www.xyz.com/54321.html>;<img src="http://www.xyz.com/54321.jpg" /></a><br />
<strong>water</strong><br />green<br />cold<br />sad</p><br />
<p><a href="http://www.xyz.com/54321.html">Details</a></p></div>

etc...

the script structure would always be the same but the values of each div would change based on the row values of the spreadsheet.
Can this be done?

Hello,   I'm looking for server management software, preferably free or low cost. I did some googling but could not come up with a good solution for what I need. I manage a small data center and currently keep all server information (IPs, Rack ID, Client ID, etc) in an excel sheet. Does anyone know of something that I can manage the server information more efficiently?   Thanks

I have a general knowledge of PHP. I was wondering if anybody knew of a script that when a user logs in, they have their own unique page setup, but it is the same page.

Basically so a client could log in and see the information about their purchase, or website construction etc.

Any scripts to build off of?
Thanks

Before reading: I already have a system in place for inventory management. I use it with a rpg_items database with a field called 'item_slot', etc and it works wonderfully.

My issue is. I think it would be intuitive if I were to store a basic 20 slot 0 iteration in a field under the users table for each character. So I can just check against that, instead of querying the whole rpg_user_items table, (which will have thousands, hundreds of thousands of users items) to just check if a user's inventory is full, that is not intuitive. I'd rather just check if a field name has no open 0's instead with php. (This ofcourse will be updated dynamically upon a user moving their items to different slots).


Let's say I have this array, and it's stored in a field called userinventory in the users table:
 

0,0,0,0,0
0,0,0,0,0
0,0,0,0,0
0,0,0,0,0

This is pretty easy to read. there is 20 slots, 5 on reach row. That's 20 inventory slots a user has access to.

This is supposed to represent something like this:



I can store this in the MYSQL field as 'userinventory'.

Now, how do I go about dynamically each specific 0 (ZERO) in this Block? I'm going to call this a block.

I will need to label it accordingly.

Paint time.

Here u go



How do I use PHP to dynamically update a block like this based upon user input? (A 1, A 2, A3, B2, B1, etc)

To check if a user's inventory is full would be easy. I can just explode them by ',' and use count to see if it's greater than 20. My problem is about updating each individual block to represent a users inventory.

So, if there is a 1 there, an item would be there. That's all I'm trying to do.

I could ofcourse, create what 20 (5x4) if functions to place them at each individual block, but that wouldn't be intuitive and be extremely confusing.
Edited by Monkuar, 23 January 2015 - 09:08 PM.

I want to purchase cloud servers from DigitalOcean, however I know very little about managing and maintaining servers (I just develop the websites). I know what I need without knowing how to do it.

I'm going to MAKE this task very simple for you. I am just not that experienced with php yet to conquer this specific task.

Let me get you started with some examples of how easy the client side of this is.

Copy and paste this and run it as index.php on your dev server:
 

<script src="http://code.interactjs.io/interact-1.2.2.min.js"></script>
<script>
	function qs(expr){return document.querySelector(expr)}
</script>
<style>
.fadeIn{animation-name:fadeIn;-webkit-animation-name:fadeIn;animation-duration:.7s;-webkit-animation-duration:.7s;animation-timing-function:ease-in-out;-webkit-animation-timing-function:ease-in-out;visibility:visible!important}@keyframes fadeIn{0%{transform:scale(0);opacity:0}60%{transform:scale(1.1)}100%{transform:scale(1);opacity:1}}@-webkit-keyframes fadeIn{0%{-webkit-transform:scale(0);opacity:0}60%{-webkit-transform:scale(1.1)}100%{-webkit-transform:scale(1);opacity:1}}
.InventoryTest{
	border:1px solid #D3D3D3;border-bottom:0;width:24px;height:24px;float:left;padding:3px;border-right:0;
}
.itemdrag{position:relative;z-index:1}
 
.InventoryTest:nth-child(9n+9){
	border-right:1px solid #D3D3D3
}
.InventoryTest:nth-last-child(-n+9){
 border-bottom:1px solid #D3D3D3;
}
.itemdrag{position:relative;z-index:1}
</style>
	<?php 
		error_reporting(E_ERROR);
		//Display 63 boxes (Fits with the css nth-child tags to look pretty! lol)
		for($i = 1; $i < 64; $i++){
			if ($i == 1){ // Slot positions 1 Dimensions: 3x3 (lengthXwidth)
				$item1 = '<div class="itemdrag" item_id='.$i.' data-cslot='.$i.'><img src=http://i.imgur.com/3azYLNf.png></div>';
			}elseif($i==4){ // Slot position 2 Dimensions 2x1 lengthXwidth)
				$item1 = '<div class="itemdrag" item_id='.$i.' data-cslot='.$i.'><img src=http://i.imgur.com/l3y0W7d.png></div>';
			}else{$item1 = '';}
			
			

			$inventoryboxes .= '<div class="InventoryTest" data-slot='.$i.'>'.$item1.'</div>';
		}
	?>
	<div style="width:300px">
	<?php echo $inventoryboxes ?>
</div>

<script>
	
	  
// target elements with the "draggable" class
interact('.itemdrag')
  .draggable({
  
    // enable inertial throwing
    inertia: true,
	onstart: function (event) {
		
		},
 
    // call this function on every dragmove event
    onmove: function (event) {
      var target = event.target,
          // keep the dragged position in the data-x/data-y attributes
          x = (parseFloat(target.getAttribute('data-x')) || 0) + event.dx,
          y = (parseFloat(target.getAttribute('data-y')) || 0) + event.dy;

 
      // translate the element
	  target.style.position = "relative";
	  target.style.zIndex="2500";
      target.style.webkitTransform = target.style.transform ='translate(' + x + 'px, ' + y + 'px)';
	
 
 
      // update the posiion attributes
      target.setAttribute('data-x', x);
      target.setAttribute('data-y', y);
    },
    // call this function on every dragend event
    onend: function (event) {
	  var target = event.target;
 
		target.removeAttribute("style");
		target.removeAttribute("data-x");
		target.removeAttribute("data-y");
  
    }
  });
  
interact('.InventoryTest').dropzone({
	
	
  // only accept elements matching this CSS selector
  accept: '.itemdrag',
  // Require a 75% element overlap for a drop to be possible
  overlap: 0.40,

  // listen for drop related events:

  ondropactivate: function (event) {
  var draggableid = event.relatedTarget;
    // add active dropzone feedback
	// Is this and item that can be equipped?

	if (event.relatedTarget.getAttribute('item-type') != "Misc"){
	 //qs('#shadow'+draggableid.getAttribute('item-type')+'').style.display='none';
	}
		
	
	
	
    event.target.classList.add('drop-ACCEPT');
  },
  ondragenter: function (event) {
    var draggableElement = event.relatedTarget,
        dropzoneElement = event.target;

    // feedback the possibility of a drop
	

    dropzoneElement.classList.add('drop-target');
    draggableElement.classList.add('can-drop');
    //draggableElement.textContent = 'Dragged in';
  },
  ondragleave: function (event) {
    // remove the drop feedback style
	
    event.target.classList.remove('drop-target');
    event.relatedTarget.classList.remove('can-drop');
    //event.relatedTarget.textContent = 'Dragged out';
  },
  ondrop: function (event) {
	var dragid = event.relatedTarget;
	if (event.target.hasChildNodes()) {
	//console.log(event.target.childNodes[1]);
	return;
	}
	
	var slotp = event.target.getAttribute("data-slot");
	var slotp2 = event.relatedTarget.getAttribute("data-cslot");
	var shadowid = qs('#shadow'+dragid.getAttribute('item-type')+'');
	var item_id = event.relatedTarget.getAttribute("item_id"); // <-- The one being dragged
	
	//We need to show the shadow gear again.
	(shadowid) ? shadowid.style.display='inline-block': '';
	

	
 
	
	
	qs('[data-slot="'+slotp2+'"]').innerHTML='';
	qs('[data-slot="'+slotp+'"]').appendChild(event.relatedTarget);
	
	event.target.childNodes[0].setAttribute("data-cslot", slotp);
	
	//We do our ajax functions here, just log the information for now:
	console.log(" item_id="+item_id+"&slot_go="+slotp+"  ");
 
 
	
	
	event.relatedTarget.className += ' fadeIn';
	

	
	
	//console.log(event.relatedTarget);
	//console.log(event.target);
    //event.relatedTarget.textContent = 'Dropped';
  },
  ondropdeactivate: function (event) {
    // remove active dropzone feedback
    event.target.classList.remove('drop-ACCEPT');
    event.target.classList.remove('drop-target');
  }
});
</script>


	

Now, go there and drag and move the belt around in the inventory. They should update accordingly. Example:


Press F12 and check your console. You should see upon each item being moved, it's logging their slot it was moved.

What I need?

I need this where items CANNOT overlap each other in the inventory. The items need to be piped from mysql and positioned to the appropriate position in the inventory. You need to be experienced in Javascript and PHP for this. InteractJS because if you check the example above, the armor is being dragged, but you cannot drop it on anything because interactjs doesn't know it's that big.

If you look at Diablo 2's inventory system, and Path of Exile's or Diablo 3's, you can get an idea of what I'm looking for. Let me know if you're interested in this and what price.

There is a field in my rpg_user_items table called slot_position and slot_size. slot_size represents the widthxheight of the item. (in this example and code above, it's 3x3 (armor) and 2x1 (belt).
Edited by Monkuar, 24 January 2015 - 08:39 PM.

Trying to a. check if dir exists if not create it, and b. save an uploaded file to that directory.  Nothing however is working but I'm pulling no errors, heres the code:



$test_pic = $_POST['test_pic'];
// I've also tried       $test_pic = $_FILES["test_pic"];     : with no success
if (is_uploaded_file($test_pic)) {
if (!file_exists("tests/uploads/" . $test_name . "/")) {
$create_test_folder = (mkdir("tests/uploads/" . $test_name));
if (!$create_test_folder) {
echo "cant create folder";
die;
}
}
$target_path = ("tests/uploads/" . $test_name . "/" . $test_name . "_1");
if (($_FILES["test_pic"]["type"] == "image/gif")
   || ($_FILES["test_pic"]["type"] == "image/jpeg")
 || ($_FILES["test_pic"]["type"] == "image/jpg")
 || ($_FILES["test_pic"]["type"] == "image/png")
 && ($_FILES["test_pic"]["size"] < 50000)) {
if (!copy($test_pic, $target_path)) {
echo "cant copy picture";
die;
}
} else {
echo "file type or size bad";
die;
}
}


and I understand its not at all public-safe but I'm just wanting to get it to work before I throw in the security.  Thanks for the help!

I've made a site for a client and they like it.  They asked me who does the updates me or them?  So I know they want to make the updates themselves.  Do anyone know the best place I can learn how to create a CMS? I would prefer video tutorials.  Thanks.

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=350218.0

Hey, all!

I posted a thread before about a content management system for my news, and so far the php script works fine. I would like to add additional features to this system, though, and was wondering if anyone could help.

Here's the code for all the files needed for the news content management system to work...

1.) First, is the mysql table, called "mynews" with the fields:

"id" - primary key; auto-increment. "title" - the title of the news article. "user" - the person who posted the article (would be me in all cases) "message" - the body of the article; this would contain the actual news. "url" - the url to the full article. "time" - time and date the article was posted, or added to database. "type" - the type of news, like 'update', or 'random'.
2.) Next, is the code to connect to the database in mysql, called "dbconnect.php":

Code: [Select]
<?php 
    $username = "your username"; //your username 
    $password = "your password"; //your password 
    $host = "your hostname"; //your mySQL server 
    $database = "your database name"; //The name of the database your table is in 

         mysql_connect($host,$username,$password) or die("Error connecting to Database!<br>" . mysql_error()); 
 //connect, but if there is a problem, display an error message telling why there is a problem
 
         mysql_select_db($database) or die("Cannot select database!<br>" . mysql_error()); 
 //Choose the database from your mySQL server, but if there is a problem, display an error telling why 
?>
3.) Third, is the forms for posting new articles, called "postnews.php":

Code: [Select]
<form action="process.php" method="post" id="news">
        <h1>Post New Article</h1>
        <p>Please fill out all of the following fields:</p>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td class="cmsNewsformText">Type*:</td>
            <td><font size="1">
              <input name="type" type="text" class="cmsNewforms" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">News Topic/Title*: </td>
            <td><font size="1">
              <input name="title" type="text" class="cmsNewforms" value="enter title of article" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">Username*:</td>
            <td><font size="1">
              <input name="user" type="text" class="cmsNewforms" value="enter username" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">Url*:</td>
            <td><font size="1">
              <input name="url" type="text" class="cmsNewforms" value="enter url of news article" size="50" />
            </font></td>
          </tr>
          <tr>
            <td class="cmsNewsformText">Message*:</td>
            <td><font size="1">
              <textarea name="message" cols="43" rows="10" class="cmsNewforms">enter body of article
      </textarea>
            </font></td>
          </tr>
        </table>
        <p> <font size="1">
          <input name="Submit" type="submit" class="Button1" value="Submit" />
        </font> </p>
      </form>
4.) Fourth, is process.php. This script sends the data entered by the administrator (me) on "postnews.php" to the database, and displays a message saying that the information was sent successfully.

Code: [Select]
<?php
 $user=$_POST['user']; 
 $title=$_POST['title']; 
 $message=$_POST['message']; 
 $type=$_POST['type']; 
 $url=$_POST['url']; 
 mysql_connect("your hostname", "your database name", "your password") or die(mysql_error()); 
 mysql_select_db("cmsnewsacp") or die(mysql_error()); 
 
 $sql = sprintf("INSERT INTO mynews (user, title, message, type, url)
VALUES ('%s', '%s', '%s', '%s', '%s')",
mysql_real_escape_string($user),
mysql_real_escape_string($title),
mysql_real_escape_string($message),
mysql_real_escape_string($type),
mysql_real_escape_string($url));
$result = mysql_query($sql); 
 
 
 Print "The article has successfully been posted"; 
 ?>
5.) And lastly, here's the script for displaying the news on the home page:

Code: [Select]
<?
include("dbconnect.php"); //include the file to connect to the database
$getnews = mysql_query("SELECT * FROM mynews ORDER BY id DESC"); //query the database for all of the news

while($r=mysql_fetch_array($getnews)){ //while there are rows in the table
extract($r); //remove the $r so its just $variable

echo("
<span class=NewsID>$type</span> <span class=h2>$title</span><br><br>
<em>posted by <strong>$user</strong> on $time</em><br>
<span class$message<br><br />
<font color=0099FF><a href=$url>Read more - $url</a></font><br><br><p>");

}

?>
Now that you've got all the code, let's take a look back at the table "mynews" with its fields. See "url"? This variable would contain the url I type in the forms on "postnews.php" and would be called to form a "Read more" link at the end of each article displayed on the home page. The question I have here, is how can I modify this script to where everytime a new 'article' is added to the database, a new page is created with the article and the url I specified? Also, I want to limit the amount of characters of the article, so that it'll only display a little bit on the home page, with a "read more" link that takes them to that page.

Now last but not least, how in the bloody fudge do I script pagination into this script?