PHP - Php To Save Form Entrys To Server In Textfile Help!!!!!

Hi, I'm kind of new to this forum, so I'll just go ahead and write a little about myself and my project.
18 year old from Sweden, still in school. thats pretty much all about me, so my project:
the past months I've been developing a JavaScript game with php backend. To communicate between server and client i use JSON. This has been working great. There's just one little problem, storing all the data. At first everything was stored in textfiles. all the sensitive data was ofcourse encrypted. To organize the data i used different characters like the star (*) etc. But the big problem was that i was forced to deparse all data and the puzzle it back together. This bugged out sometimes, when the wrong data was received and bugged out the whole system. Thats when i decided to go with MySQL. This was great, and much more simple. there's just one problem. the system needed to be capable of holding 1000 players online at once which did not work since the server was forced to handle 4000 php request/second. Before i "only" needed to handle less than 500 php requests/second. So I began thinking of a solution.

My idea is:
*JavaScript sends the data to the php script.
*The php script checks that the file holding the data requested isn't already opened.
*The php script opens the file and decodes the content.
*The php script loops through the object and finds the index the person is looking for.
*The data in this "index-object" is changed to the value received in the first step.
*The data is encoded to json and saved to the file.

for one of the things I will use this for is player position.
So the player send his/her position to the php-script when he moves.
But when the player wants to get the other players data, its read directly from the file!

The only question is: Do you think thiswill be able to work?
Thank you for taking the time to answer!
//Daniel

Hello,

Im using a wordpress blog which has links to filesonic i want to be able to mass update all the links to another host, Ive made a script that will do it for a single link but i can't think how to get it to do it for more than 1 link in the post.

sometimes there are files like 1211.part1.rar 1211.part2.rar, It updates the part1 fine but dosen't update part 2. Any ideas how i can alter my script to replace the part2 files aswell?

Code: [Select]
<?php

if($_POST[newlinks]) {
$query = "SELECT * FROM wp_posts WHERE post_status = 'publish'";
$result = mysql_query($query);
while($row=mysql_fetch_assoc($result)) {

$find = $row['post_content'];

  preg_match("/http:\/\/www.filesonic.com\/file\/(.*?)\/(.*?).rar/", $find, $matches);
  
    $newlinks = preg_split('~\s+~s', $_POST['newlinks']);
      rtrim($newlinks, "\n\t\r");
    
    foreach ($newlinks as $newlink) {
      $new_number = explode('/', $newlink);
      $new_number = end($new_number);
      $new_number = str_replace(".rar", "", "$new_number");


      if($matches[2] == $new_number && isset($newlink) && strlen($newlink) > 1) {
         $newsql = preg_replace("/http:\/\/www.filesonic.com\/file\/(.*?)\/(.*?).rar/", $newlink, $find);
            $updatesql = "UPDATE wp_posts SET post_content = '$newsql' WHERE ID = '$row[ID]'";
            if(mysql_query($updatesql) or die(mysql_error())) {
              echo "Success! Replaced http://www.filesonic.com/".$matches[1]."/".$matches[2].".rar with $newlink ID: $row[ID]<br />";
           }
       }
    }

}

} else {
echo "<form method=\"POST\" action=\"update-links.php\">";
echo "<br /> <strong>Enter the new links to try and replace old ones</strong> <br />";
echo "<textarea rows=\"16\" name=\"newlinks\" cols=\"84\"></textarea>";
echo "<input type=\"submit\" value=\"Submit\" name=\B1\">";
}
?>

Hi there, trying to create a function more out of lazyness an timesaving than anything
im sure it has to do with something combining the use of INSERT and x++ in an array, but im failing at figuring out the right way of doing it to achieve the right combination of effects.

in simple

need to create a 600x600 grid of co-ordinates where x starts at 1, ending in 600 with y starting at 1 and ending in 600

so basically a cubed set of entrys, (360,000 rows) not even sure thats possible lol..

the table only needs to contain the colums of id, x , y , ownerid (where id is auto inc)

any suggestions, as you can tell its a pain-staking long case of affairs to create with a manual VERY long sql statement, trying to figure out a better way of doing this.
help please?

Thanks

also i want to change this array:

$a=array('a','b','c','d','e','f','g');

to this:

$a=array('a','b','c');

i found out that i can unset the last ones, but is there an other way to do that? faster?

I have html form and verify post data via pgp
how can I save someone data if some one fill incorrect information

Hi All,

Come a little stuck with an issue and hoping someone can shed some light on it.

Basically, I have a form that pulls down the list of users and then pulls down a list of jobs that can be assigned to them. I can get the form to pull all this down, but when I post the data, I am unsure of how to process this for each user and insert into the database.

I have tried adding the [] onto the field name, but this doesn't work as one of the dropdowns that you choose the position for, populates another dropdown of site addresses you are allocating too.

I have attached the Script to see if anyone is able to assist with any guidance.

$userClient = "VARIABLE OF WHO IS LOGGED IN";  
<form action="actions/assign.php" method="post">
	  <?php 
	  $sql = "SELECT * FROM Engineers where Engineer_Company = '".addslashes($userClient)."' and userType = '5'";
	  $result = mysqli_query($db, $sql);
	  
	  while($row = mysqli_fetch_assoc($result)) {
		  		$userSID = $row["userID"];
		  echo '<tr>
		  			<td>'.$row["userName"].'    
					
					<input type="hidden" class="form-control"  id="usersID[]" name="usersID'.$row["userID"].'" value="'.$row["userID"].'">
					<input type="hidden" class="form-control"  id="date" name="date" value="'.date('d-m-Y').'">
</td>
					<td>';
		  
		  			$sql1 = "SELECT * FROM job_orders where companyID = '".addslashes($userClient)."'";
					$result1 = mysqli_query($db, $sql1);
	  				echo "<select style='width: 250px;' id='job$userSID' name='job$userSID'>";
		  			echo '<option value="">-- Please Select --</option>';

	  				while($row1 = mysqli_fetch_assoc($result1)) {
		  				echo '<option value="'.$row1["jobID"].'">'.$row1["jobtitle"].'</option>';
					}
	  
	  	  echo "</select>";	  
		  echo '</td>
		  
		  
		  <td>'; 
				  
	
		  
    $query = $db->query("SELECT * FROM Engineer_Company WHERE Company_ID = '".addslashes($userClient)."'");
    $rowCount = $query->num_rows;

        if($rowCount > 0){
			echo '    <select name="company'.$userSID.'" id="company'.$userSID.'" style="width: 250px;">
        <option value="">-- Select Company --</option>';
            while($row = $query->fetch_assoc()){ 
                echo '<option value="'.$row['Engineer_Company_ID'].'" class="form-control form-control-sm">'.$row['Engineer_Company_Name'].'</option>';
            }
			echo '</select>';
        }
   
		  
		  
		  echo'</td>
		  
		    <td>
			
			<div class="form-group">


    <select id="site'.$userSID.'" name="site'.$userSID.'"  style="width: 250px;">
        <option value="">-- Select Site --</option>
                              </select>
           
	
	
	
    </div>
			'; 
				  
	echo'</td>
    </tr>';

		  
		  echo '    <script type="text/javascript">
$(document).ready(function(){
    $("#company'.$userSID.'").on("change",function(){
        var diag_id = $(this).val();
        if(diag_id){
            $.ajax({
                type:"POST",
                url:"ajax-client-side.php",
                data:"diag_id="+diag_id,
                success:function(html){
                    $("#site'.$userSID.'").html(html);
                }
            }); 
        }
    });
    

});
</script>';
	  }
	  ?>

  </tbody>
</table>
	
			<input class="btn btn-dark float-right" type="submit" value="Allocate">

			  </form>
			

Cheers!

Well, folks, thanks to all the help, I've narrowed my problem
down to needing a way to allow a variable value to traverse
into subsequent calls of a function.

I have a simple integer - "companyID", and it's set in "actionfile.php"
which is called by two forms.  The first time it's called by Form A,
it's set.  I'd LIKE to put it into $_SESSION, but apparently $_SESSION
is zeroed out before I can use it in the second call to "actionfile.php"
by Form B.  A new form/function call is a new session?

I've tried setting it to global and static, to no avail.

Anything more elegant than writing the value to SQL for later
retrieval?

Thanks!

Mark

Hey guys!
I have the following script to create an excel file, the thing is that I dont want to be asked if I want to open or save the file when accessing the php file...I just want the php file directly to save the excel file.

Heres the code:


$filename = "test.xls";
$contents = "testdata1 \ntestdata2 \ntestdata3 \n";
header('Content-type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;


Is there a way instead of using the header function, use something like: fopen, fwrite, fclose ?

Thanks in advance!
Cheers,

This topic has been moved to HTML Help.

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

Greetings! I'm new in phpmysql.

Am making signup form with three users (Admin, office and student), that when student is selected there will be another form that need to fill up and the data is saved in different table. Below are my codes when the data of admin and office are submitted.
Code: [Select]
mysql_query("INSERT INTO tbl_user (user_Id,user_Password,user_Fname,user_Lname,user_Sex,user_Level,user_Program)
                VALUES               ('$userid','$password','$fname','$lname','$sex','$level','$program')");

these things here are codes for student when submitted
Code: [Select]
mysql_query("INSERT tbl_studenroll (user_Id, course_Id, ap_Id, se_Sem, se_Yearlevel)
VALUES     ('$userid','$course', '$acadyear', '$sem', '$year')") or die(mysql_error());

             $seID = mysql_query ("SELECT max(se_Id) AS mxSEid FROM tbl_studenroll")or die (mysql_error());
             $seID1 = mysql_fetch_assoc($seID);
             $seID = $seID1['mxSEid'];

             $offcourse = mysql_query("SELECT office_Id FROM tbl_offcourse WHERE course_Id = '$course'")or die (mysql_error());
             while ($row = mysql_fetch_array($offcourse))
             {
$off = $row['office_Id'];
          mysql_query("INSERT tbl_data (se_Id,office_Id,user_Id,course_Id) VALUES ('$seID','$off','$userID','$courseID')") or die(mysql_error());
             }

sEE that I am saving in three tables at the same time when student is selected.
How can I do it? I want to save only what for students and for other users..I tried my codes but when I submit data from office, it saves data to studenroll, but in 0 value. hope I am clear, help me guys! thank you in advace.

I am trying to get this form to submit, but it doesn't go anywhere.

I checked the browser console and I see "Failed to load resource: the server responded with a status of 500 (Internal Server Error)". Can someone help me resolve this error?

 

CODE:

<html>
<head>
<title>PICK 5 :: 13 Ticket System (3 of 5 WHEEL)</title>
<style>
.wrap{
text-align:center;
width:900px;
margin: 0 auto;
}

.row{
margin: 18px 0;
}

.input{
border:1px solid #ccc;
width:800px;
float:left;
margin:10px;
}

.output{
width:700px;
margin:0 auto;
text-align:left;
}

.output .str{
}

.output .number{
font-weight:bold;
margin-right:5px;
}

.clear{
clear:both;
}
</style>
</head>
<body bgcolor="#F5F5F5">

<div class="wrap">
<form method="post" action="">

<div class="row"><p><span style="font-weight: bold; color: #0000FF;">PICK 5 :: 13 Ticket System (3 of 5 WHEEL)</span></p>
<p>(Guaranteed <span style="font-weight: bold; color: #0080ff;">3-WIN</span>, if 5 of the numbers drawn are in your set of 15 numbers)</p>
<label>Please enter 15 numbers and separate them with a comma ","<br></label>
<input type="text" name="num" value="<?= isset($_POST['num'])?$_POST['num']:'1,2,3,4,5,6,7,8,9,10,11,12,13,14,15' ?>" />
</div>

<div class="row"><input type="submit" name="submit" value="Go" /> </div><br>

<?php

if(isset($_POST['submit'])){
$num = $_POST['num'];
$num_array = explode(',',$num);
$alpha_array = array('A',  'B',  'C',  'D',  'E',  'F',  'G',  'H',  'I',  'J', 'K', 'L', 'M', 'N', 'O');

$array1 = array();

for($i=0; $i<15; $i++)
{
$array1[$alpha_array[$i]] = trim($num_array[$i]);
}


$array2 = array(

array('A', 'B', 'C', 'L', 'M'), // Start 15# (3if5 Wheel) - 13 Lines
array('A', 'B', 'D', 'H', 'I'), // Where .. (A1, B2, C3, D4, E5, F6, G7, H8, I9, J10, K11, L12, M13, N14, O15)
array('A', 'C', 'G', 'H', 'O'),
array('A', 'E', 'K', 'N', 'O'),
array('A', 'F', 'G', 'J', 'L'), // LINE 5
array('B', 'D', 'F', 'L', 'O'),
array('B', 'E', 'F', 'G', 'I'),
array('B', 'H', 'J', 'K', 'N'),
array('C', 'D', 'E', 'F', 'J'),
array('C', 'I', 'K', 'L', 'N'), // LINE 10
array('D', 'G', 'K', 'M', 'N'),
array('E', 'F', 'H', 'L', 'M'),
array('F', 'I', 'J', 'M', 'O'), // LINE 13


);

$data = "";
foreach($array2 as $arr){
$data1 = "";
foreach($arr as $a){
$data1 .=  $array1[$a] . ', ';
}

$data[] = rtrim($data1,', ');
}
?>

<div class="output">
<?php
foreach($data as $k=>$v){
echo '<span class="number">'.($k+1) . '.</span><span class="str">' . $v . '</span><br>';
}

}

?>
</div>

<div class="clear"></div>

</form>
</div>

</body>
</html>

 

Edited February 25, 2019 by requinix
please use the Code <> button when posting code.

I have a website that a user fills out there login information which we then post to another website outside of our system.  The website where the information is being posted is doing an IP check.  They are trying to check for our server IPs instead of the users IPs.  Since the POST is coming from the user, there is no way to get the server IP (that I know of...right?).  As a work around for this, I'm trying to initially post to another script on our server which will then repost the information using PHP.  This way the IP will be from our server instead of the user.

I've tried using curl, and while that allows me to pull the content of the webpage, it does not redirect the user to the page after the login.  I've also tried using header() but I'm pretty sure that solution will not work either.  So does anyone know how I can send post information to a website on my server using php and have it send the user to the resulting page?

Thanks

Hi, I have a some online backup software call ahsay, I' am looing to create a API call with a form in PHP

Please check out this link www.123-backup.com/obs-admin-guide.pdf

this is the guide to create a api for the  online backup (page 69)

Would some be intrested in creating this api call and php form for me ?

p.s please see attached image this is something i'am looking for.

if so how much would it be please email me if you want more info!

I have a question regarding my email form submission. The email seems to work fine, but the recipient of the email can view my server information (see attached image for example) there are many website hosted on my server and i would like to hide the server info on form submissions. does anyone know of a way to do this? thanks