PHP - Text Storage And Database Selection

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.

Just curious, how would you go about rendering and storing this in a database. For example a simple small maze.      With each keypress, the user is moved up,down,left,right like 1 inch. (1 block). Which is easy to do with jquery, etc. But how would go about storing the data in a databse (can update the position per update or using websockets), but essentially so maphacks are impossible and everything is saved/read from the server.   Would the storage data be something like [0,0,0,1,0,0,1,1,1,1,0,1] I imagine or what?
Edited by Monkuar, 01 December 2014 - 09:32 PM.

I am trying to do age validation for a beverage site, and losing my mind.  First time trying local storage (to persist across browser sessions) and I assume I have something screwed up.  Anyone able to help me figure out how to make this work?

<?php
    if( isset( $_POST['yes'] ) )
    {
    	localStorage.setItem('age_verification', 'true');

        if( isset( $_GET['url'] ) )
        {
            die( header('Location: ' . $_GET['url'] ) ); 
        } 
        else
        {
            die( header('Location: index.php') );
        }
    }
    elseif( isset( $_POST['no'] ) )
    {
    	localStorage.setItem('age_verification', 'false');
    }
	var age_verification = localStorage.getItem('age_verification'); //new
	if (age_verification = "false" || age_verification = "null") die( header('Location: http://www.bing.com') );	
?>

Above is the code for the file checkagenew.php which I call from other pages using the below:

<?php
	if (localStorage.age_verification) { localStorage.setItem('age_verification', 'null'); }
	var age_verification = localStorage.getItem('age_verification');
	if (age_verification = "false" || age_verification = "null") die( header("Location: checkagenew.php?url=http://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]") );
?>  

Obviously there is a form included in the top part (not shown) that has a submit for yes/no which triggers the $_POST validation... I did not include that for brevity.

My users table on my forum is what gets checked everytime a user refreshes to authentic them.    When killing a monster, I want users to be able to grab items and it will insert them into their inventory. I have this part done already. But I want them to have a plethora of loot available that drops from a mob, and once they click the specific item it will then be inserted into their inventory (server database).   I'm storing the Temporary Item Data in a PHP session variable. Once they kill a monster, the Tempory Item Data variable get's filled with the specific loot and then the user will have the option to choose what items they want to go into their inventory.   My problem is, if they open the game in a new browser they will get a new session id. Since I'm authenticating them through my users table, can I just make a new column called session_id and just use php's session_id() before every session start so no matter which browser they're on they will have the same session right?    You might think, well why dont you just store the temporary item data in a mysql field or rows instead? I want to try to minimize mysql usage as much as possible, as players will be CLICKING a lot to kill mobs, it is most likely very mysql demanding as well and I want to be intuitive about it. I just want to use temporary session data for the loot. Then once the user clicks an item they want, it is EXTRACTED from their tempory item data variable, then I will use MYSQL to insert those items into their inventory.    Is this a fair and intuitive way to do temporary data for item loot? For example, in action RPG's like Path of Exile you kill a group of mobs and you see a shit ton of loot on the floor. (I imagine that loot is just temporary waiting for someone to pick it up right?) Once you do pick it up, mysql is then called to save it right? That's the same logic I have with my web based game. Is using a session variable to store that temporay loot.   Is this an intuitive way to do this, or are there other ways?
Edited by Monkuar, 24 November 2014 - 01:24 AM.

after authenticating username and password,i have a parameter like:
$_SESSION['logged']=1

should i be storing this as a cookie?..if yes, then can anyone modify cookie, to have this parameter as "1", and gain access?

hi i was wondering if anyone has any idea how to read text from a database and if that text = "mytexthere" then goto header("Location: index.php"); sorry i have no code on this post reason is all the code i have tried on my own is crap

I have text field in database, where I have let's say 5000 words.
I  want to split this text having 5000 words in pages, each one having 500 words.
How can I realise this ?
A practical example would be appreciate  !
Thank you in advance.

Hi guys

I have created a profile page where users can update their profile.

what I need to do is to echo back the users details in the inout text

I have name and telephone number

any ideas how to do it? here is my code

<?php
session_start();
include ("global.php");


//username session
$_SESSION['username']=='$username';
$username=$_SESSION['username'];


//welcome messaage
echo "Welcome, " .$_SESSION['username']."!<p>";

  if ($_POST['register'])
    {
     //get form data
     $name = addslashes(strip_tags($_POST['name']));
     $telephonenumber = addslashes(strip_tags($_POST['telephonenumber']));



   
$query = "UPDATE  users   SET name = ' $name' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  users   SET telephonenumber = ' $telephonenumber' WHERE username='$username'";
$result = mysql_query($query);



}


?>

    <form action='updateprofile.php' method='POST'>
    Company Name:<br />
    <input type='text' name='name'><p />
     <input type='text' name='telephonenumber'><p />
 
    <input type='submit' name='register' value='Register'>
    </form>


_______

the reason i want to do this is because when user is updating the name field the empty input text for telephone number ovverides the telephone number field in the database.

I would aprreciate your help guys,

Hello all! I am somewhat new to PHP and SQL, but I think I have a basic understanding of how the language works. I have read through a million different websites and forums, and have tried a million different ways but am just not getting anywhere!

This is what I am trying to do... I have a text link that I want to click through to an outside URL from my website. This outside URL was already entered into an SQL database, and I just cant seem to get the text link to bring up the outside URL from the database. This is what I have so far...

1.) My webpage that I am working on is www.mywebsite.com/articles.php
2.) I want the text "Read more..." on this webpage to click through to an outside URL, like "http://www.google.com", which was already entered into an SQL database under the title of "article_link" in a new window
3.) So I would like for "Read more..." to click through the outside URL that was entered into "article_link" in the database

Code: [Select]
<?php
echo <p><a href="\' . $article_link . '\" target="_blank">Read more...</a></p>;
?>
Nothing I have tried has worked so far, nothing clicks through to the outside URL in the "article_link" entry from the database. Sorry if I am being redundant, I have been at this all day! Please help and thank you in advance!!

How to text a phone number in database
as well as record recieved textmessages into mysql database.

Any help here? i've been googling for ages.

Hi, very new to all this, so don't really know too much!

I have been trying to edit some code to be able to retrieve some blocks of text from a database, then edit them and post them back.

I have managed to retrieve them, however I can't seem to be able to post them back to the database edited.

This is the code I'm using:
Code: [Select]
<?php
require_once('config.php');

$con = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if (!$con){
die('Failed to connect to server' . mysql_error());
}

mysql_select_db(DB_DATABASE);

$ide15 = $_POST[idf];
$query15 = "SELECT id,titleus,aboutus FROM about WHERE id = 1";
$result15 = mysql_query($query15) or die ("Query:<br />$query15<br />Error:<br />".mysql_error()); 

while ($row15 = mysql_fetch_assoc ($result15)) {
$title15 = htmlentities ($row15['titleus']);
$news15 = nl2br (strip_tags ($row15 ['aboutus'], '<a><b><i><u>'));


echo "<form class ='addform' action='editabouttext.php' enctype='multipart/form-data' method='post'>";
echo "<p>Uttsav Title:<br /><input class='titlefield' type='text' name='title' value='$title15' /></p><br />";
echo "<p>Uttsav About:<br /> <textarea name='news' rows='1' cols='15'>$news15</textarea></p><br />";
echo "<p><input name='submit' type='submit' value='Submit' /></p>";
echo "</form>";
}

if ($_POST['submit'])
{
  
  mysql_select_db(DB_DATABASE);
  
  $upid = $_POST[idf];
  $uptitle = $_POST[title];
  $upnews = $_POST[news];
  $upimage = $_FILES['userfile']['name'];
  
  $sql = "UPDATE about SET titleus = '$uptitle', aboutus = '$upnews', WHERE id = '1'";
  
  mysql_query($sql);
  
  if ($_POST['submit'])
  {
  
  echo "<p class='admintext'>Your project thumbnail has now been edited - <a href='about.php'>View The About Page</a></p><br />";
  $name = $_FILES['userfile']['name'];
  $type = $_FILES['userfile']['type'];
  $size = $_FILES['userfile']['size'];
  $tmpname = $_FILES['userfile']['tmp_name'];
  $ext = substr($name, strrpos($name, '.'));
  
  if (strstr($type, "image"))
  {
  move_uploaded_file($tmpname, "images/portfolio/".$name);
  }
  
  }
}
  
?>

I am using an apache server at the minute and have had this code working for other pages and scenarios, yet can't get it working on this, I think it may have something to do with the id of the post, but as I am only going to be using one post that will just get edited I took out the WHERE id = $ide15 and put in WHERE id = 1 as this is the id of the only post!

Any help would be much appreciated! as I said, just starting to get to grips with things like this!

Thank you

Martin

Hello all,

I have three text fields ( hosteladmissionnumber,branch & Semester) and three text boxes in a form. When i provide the hostel admission number , the corresponding branch semester must be acquired from the registrationtable in DB and fill it in text boxes. How can i do it? any help would be appreciated. Thanks. I have pasted the code below.
[syntax=php]
<?php
session_start();
  $hostad=$_POST['hosteladmissionno'];
   $sem=$_POST['student_name'];
   $sem=$_POST['semester'];
$con=mysql_connect('localhost','root','');

if(!$con)
{
die('Unable to connect'.mysql_error());
}
mysql_select_db('hostel',$con);
//i have to insert the hosteladmission in payment too..but no need to insert semester and branch
$r1="INSERT INTO payment(hosteladmissionno) values ('$hostad')";
mysql_close($con);
?>
/HTML PART

<form action='payment.php' method='POST' name='form1'>
    <center>
 <table>
<tr><td><b>Admission No:</b></td><td><input type='text'  name='hosteladmissionno'></td></tr>
<tr><td><b>Student Name:</b></td><td><input type='text'  name='student_name'></td></tr>
<tr><td><b>Semester:</b></td><td><input type='text'  name='semester'></td></tr>

[/syntax]

This topic has been moved to Application Design.

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