PHP - Persisting An Object Over Multiple Requests

Hi,

I am trying to make a web interface for a robot, I have written php to send/recieve values via a serial port to my robot. They work.

I am now tring to develop my web interface.

I'm using java to generate http requests client side in the form of;
Code: [Select]
/request?command=Forward&param1=254
I was wondering how I can parse the command and param1 in php sereverside?

Or is there a better alternative?

Hello!

I'm trying to understand exactly how http requests relate to a php script. 

1)  What would be considered a large amount?
2)  How can I see how many I have for a given page?

Thank you,

Eric

I created an app for my website, set action (read) and object (article), and placed the objects code (META tags in the head) at the article page on my website.

Now, I want to know how to send a cUrl request whenever a user reads an article on my website, so it'll feature on his wall.

When I press the "get code" link near the action, that's what I get:

Code: [Select]
curl -F 'access_token=***' \
 -F 'article=http://example.com' \
    'https://graph.facebook.com/me/yellowheart:read'

(There's an actual access token of course).

Now, how do I make it happen?

Daniel

I have script on my web hosts server built into pages that will be offered to the public, eg: index.php will have some script amongst the html, this script calls other webpages on the net eg: wiki.org

Now my question is, when that script runs when somebody accesses that page, will the website eg: wiki.org record the users browser info and ip who called my index page or will it record the webhosts server details as the one making the requests?

Purpose: Building a search function for a site, that's supposed to be fast, give results as a user types.

Queries would be something like: "brand1 brand2 brand3" .

My idea is , instead of querying the database on each ajax request. A keyed array is created once. Like: ['brand1' => id , 'brand2 => id2 ]. This array is stored in memory. The next time a query is sent, the array which is instantly available in memory, and can be simply queried $storedArray['brand1']to fetch any existing ids instantly. The array size would be about 750 Kb. 60000 rows.

I don't have much experience with caching , so looking for advise whether what I am trying to do even makes any sense or necessary. I know there are solutions like memcache. But not sure if my tiny project requires them. Also does opcache help here ? Would serializing the array be too slow ? 

Please ask if any questions.

Thanks

Hi all,

Something i forget to ask all the time, but now i don't.
While reading again about image sprites, it tells that it's nice because it decreases the amount of http requests.
Now I thought what about all those requires and includes of php aren't they doing the same thing? Not to mention OOP which would not exist without the 2(4).

Does anyone know if this indeed increases the amount of http requests. And if so, if there is a certain good practise to lower the amount, by just combining functions in 1 file.

I would love to hear from some guru's 

It's been a while since I've needed to whip anything substantial up from scratch, so my scripting is a little (lot) fast and loose (weird/inefficient) here.

I'm trying to mock up a script that's essentially a quiz/survey. There are a handful of topics, each with a few screens of yes/no questions. At the end, it returns a list of recommendations based on the answers gathered.

The script is posting back to itself. Using print_r ($_SESSION), it seems like all of the post values for the first screen of questions are being assigned to the session array as expected. When the second screen of questions is answered, their values are assigned as well, but the values for the first set go away completely. This continues through subsequent screens, with the values from the previous screen present and all others before missing.

I'd really appreciate a look at my code to see if you tell me the cause or error(s).

Thanks!


<?php
session_start;
include('_config.php');

// database connect
$dbc = mysqli_connect($CFG->dbhost, $CFG->dbuser, $CFG->dbpass, $CFG->dbname);

// set to section 1, page 1 if no values are in _POST array
  if (($_SERVER['REQUEST_METHOD'] ==  'GET') || (!isset($_POST['section']))) {
   $section = 1;
   $page  = 1;
  }
  else {
// something was posted, so...set those values in session variable
foreach($_POST as $key => $data) { 
$_SESSION[$key] = $data; 
}
// debug: display contents of the session array
print_r ($_SESSION);

// which section and page?
   $section = (int) $_POST['section'];
   $page  = (int) $_POST['next'];
  }

// check if last topic
$query = "SELECT * FROM hw_topics";
$data = mysqli_query($dbc, $query);
  if ($section == mysqli_num_rows($data)) {
    $last_section = true; 
  }
  else {
    $last_section = false;
  }

// get current topic name and info
$query = "SELECT topic, display_name, pages_in_topic FROM hw_topics WHERE topic_id = '$section'";
$data = mysqli_query($dbc, $query);
if (mysqli_num_rows($data) == 1) {
  $row = mysqli_fetch_array($data);
  $topic_display_name = $row['display_name'];
  $pages_in_topic = $row['pages_in_topic'];
  }

// test if last page in topic
$topic_pages = $row['pages_in_topic'];
if ($page == $topic_pages) {
    $last_page_in_section = true;
  }
  else {
    $last_page_in_section = false;
  }

// set form action (set to this script or to recommendations when last section is complete 
if (($last_section == true) && ($last_page_in_section == true)) {
    $form_action = $CFG->reccomend;
  }
  else {
    $form_action = $_SERVER['PHP_SELF'];
  }

// get current page headline
$query = "SELECT page_headline FROM hw_pages WHERE topic_id = '$section' AND page_number = '$page'";
$data = mysqli_query($dbc, $query);

if (mysqli_num_rows($data) == 1) {
  // The headline row was found so display the headline
  $row = mysqli_fetch_array($data);
  $page_headline = '<h2>' . $row['page_headline'] . '</h2>';
  }


// Grab the question data from the database to generate the list and form fields
$query = "SELECT question_id, question_number, question_text FROM hw_questions WHERE topic_id = '$section' AND page_id = '$page' ORDER BY question_number";
$data = mysqli_query($dbc, $query);
$questions = array();
  while ($row = mysqli_fetch_array($data)) {
    array_push($questions, $row);
  }

include($CFG->includesdir.'/header.php');
?>
<div id="head">
<h1>Assessment<?php if (isset($topic_display_name)) { echo ': <em>' . $topic_display_name  . '</em>'; } ?></h1>
<p class="paging">Page <?php echo $page; ?> of <?php echo $pages_in_topic; ?></p>
</div><!-- #head -->
<div id="content">
<p class="instr">Please complete this survey. We'll generate a list of recommendations and resources for your organization.</p>

<div id="questions">
<?php echo $page_headline; ?>
<form method="post" action="<?php echo $form_action; ?>">

<table border="0" cellpadding="0" cellspacing="0">
<thead>
<tr>
<td></td>
<td class="qtext"></td>
<td class="qanswer">yes</td>
<td class="qanswer">no</td>
<td class="pad"></td>
</tr>
</thead>

<?php 
if ($questions) { 
    // display question rows
    foreach ($questions as $question) {
      echo '<tr>';
      echo '<td class="qnumber">' . $question['question_number'] . '.</td>';
      echo '<td class="qtext"><p>...' . $question['question_text'] . '</p></td>';
      echo '<td class="qanswer"><div class="radio" id="box-yes"><input type="radio" value="yes" name="qid_' . $question['question_id'] . '" id="qid_' . $question['question_id'] . '" class="radio" /></div></td>';
      echo '<td class="qanswer"><div class="radio" id="box-no"><input type="radio" value="no" name="qid_' . $question['question_id'] . '" id="qid_' . $question['question_id'] . '" class="radio"';
      $field_name = 'qid_' . $question['question_id'];
      if (isset($_SESSION[$field_name])) {
        echo ' checked="checked"';
      }
      echo ' /></div></td>';
      echo '<td class="pad"></td>';
      echo '</tr>';
    }
  }
  else {
    echo '<tr>';
    echo '<td colspan="3" class="qtext"><p>No questions found in the database for this page.</p></td>';
    echo '<td class="pad"></td>';
    echo '</tr>';
  }
?>
</table>

<ul id="controls">
<?php 
if ($last_page_in_section == true) 
  { 
  $section++; 
  $page = 1; 
  } 
  else {
  $page++;
  }
  echo '<input type="hidden" value="' . $section . '" name="section" />';
  echo '<input type="hidden" value="' . ($page) . '" name="next" />';
  if (($last_section == true) &&  ($last_page_in_section == true)) {
    echo '<li><input type="submit" value="Submit Answers and Get Recommendations" name="submit" id="submit" /></li>';
  }
  else {
    echo '<li><input type="submit" value="Next Page" name="submit" id="next" /></li>'; 
  }
?>
</ul><!-- #controls -->
</form>
</div><!-- #questions -->

<?php
mysqli_close($dbc);
include($CFG->includesdir.'/footer.php');
?>

I have a Soup object in a Bowl object in a Microwave object.

The Microwave object has the methods:

receiveItem(Bowl $b)
cookItem(???)

I want the Microwave to be able to set the Soup->temperature but I'm not how to do that?

Make sense?



TomTees

This topic has been moved to MySQL Help.

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

First, Happy X-Mas to all!


I want to do a form for entering dog-show results. On first site of form the user is able to enter how many dogs for each class (there are youth and open class for example) he want to insert. So on second site there will be formfields for every dog in every class, created with php. User should be able to take dogname from jquery autocomplete - this works for multiple fields. But i need the according id to the dogname - and actual only one id is given - the first one is changing by choosing from autocomplete in next fields...

Data came from a json array like

0: {dogidindatabase: "9892", value: "Excalibur Khali des Gardiens de la Cour ",…}
dogidindatabase: "9892"
label: "<img src='../main/img/female.png' height='20'>Excalibur Khali des Gardiens de la Cour   "
value: "Excalibur Khali des Gardiens de la Cour   "
1: {dogidindatabase: "15942", value: "Excalibur from Bandit's World Kalli",…}
dogidindatabase: "15942"
label: "<img src='../main/img/male.png' height='20'>Excalibur from Bandit's World   Kalli"
value: "Excalibur from Bandit's World   Kalli"

all i need is inside ...


the script in form is

<script type='text/javascript'>
		//<![CDATA[
		$(function() {
		
				$(".dog").autocomplete({
				source: "xxx.php",
				minLength: 3,
				select: function(event, ui) {
					$('#dogidindatabase').val(ui.item.dogidindatabase);
					}
			});
			
			$["ui"]["autocomplete"].prototype["_renderItem"] = function( ul, item) {
				return $( "<li></li>" ) 
  				.data( "item.autocomplete", item )
  				.append( $( "<a></a>" ).html( item.label ) )
  				.appendTo( ul );
			};
	
		});
		//]]>
</script>

and the form looked like

<input type='text' name='dog' class='dog' value='".strip_tags(${'dogname' .($countbabymale+1)})."' size='35' data-required='true' /><br>
	
<input class='readonly' readonly='readonly' type='text' id='dogidindatabase' name='dogidindatabase' size='5'  />

I changed in script and form id='dogidindatabase' to class, but it doesn´t work.   Testsite is under http://www.wolfdog-d...how.php?lang=de (only german at first) - Insert a number (higher than 1) under baby 3-6 (first box, the others are not working for testing); submit to get to page 2; you see all post-variables (for testing). Try to insert a dogname in first input-field (choose "exc") and insert first one - the id is under dogname. In second dogname inputfield you can choose second dog - the id for the first one changes to id of seond one ....   How can i get both for every dog?

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work? 
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:


$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) { 
          
   $username = $dp['username'];
 $nickname = $dp['nickname'];
 $pwd1 = $dp['password']; 
 $mail = $dp['email'];
 $ip_add = $dp['ip'];
 $wsID = $dp['userID'];
 $registerdate = $dp['registerdate'];
 $birthday = $dp['birthday'];
 $avatar = $dp['avatar'];
 $icq = $dp['icq']; 
 $hp = $dp['homepage'];
 
echo $username." = 1 username only? :(";
      

// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');
                
include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";
      
       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');        
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');
       
       }



So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

This seems to be a bit of a challenge but I am creating a multiple page form and on one of the pages I have a select field. I would like the user to have the ability to select multiple options but I am using some functions to move the data in hidden fields from page to page. I don't think my functions are jiving with my my foreach loop cause I keep getting an invalid argument error.

Thanks in advance for any help.

Here is my function:

    function setSelected($fieldName, $fieldValue) {
        if(isset($_POST[$fieldName]) && $_POST[$fieldName] == $fieldValue) {
            echo 'selected="selected"';
        }
    }

And here is my loop:

    $selections = "";
   
    if(isset($_POST["selections"])) {
        foreach ($_POST["selections"] as $selection) {
            $selections .= $selection . ", ";
        }
    }

Hello all,

   I am trying to learn OOP in PHP so please forgive my ignorance. I seem to be having difficulty inserting data into my database from checkbox items. My database has a column for each each fruit. I would like for each column to be populated with either a one(1) for checked or a zero(0)  for not checked. Currently, my attempts have failed. I can either get all checkboxes to insert all zeros or I can get the first column to insert a one(1) while the others as zeros. Is there anybody here that can help me figure out what I am doing wrong and help me to re-work my code so I can get this to work? If anybody can help me using OOP methods that would be fantastic. Thank you all in advance.

 

$preffruit->create_preffruit(array(

  'fruit_apple' => escape(Input::get(['fruit_selection'][0]) ? 1 : 0),
  'fruit_orange' => escape(Input::get(['fruit_selection'][1]) ? 1 : 0),
  'fruit_banana' => escape(Input::get(['fruit_selection'][2]) ? 1 : 0),
  'fruit_pear' => escape(Input::get(['fruit_selection'][3]) ? 1 : 0),
  'fruit_kiwi' => escape(Input::get(['fruit_selection'][4]) ? 1 : 0)

  ));

<input type="checkbox" name="fruit_selection[]" value="fruit_apple">
<input type="checkbox" name="fruit_selection[]" value="fruit_orange">
<input type="checkbox" name="fruit_selection[]" value="fruit_banana">
<input type="checkbox" name="fruit_selection[]" value="fruit_pear">
<input type="checkbox" name="fruit_selection[]" value="fruit_kiwi">



public function insert_preffruit($table, $fields = array()) {
			
			$keys = array_keys($fields);
			$values = '';
			$x = 1;			
			
			foreach($fields as $field) {
				$values .= '?';
				if($x < count($fields)) {
					$values .= ', ';
				}
				$x++;
			}		
				
				$sql = "INSERT INTO preffruit (`user_id`, `" . implode('`, `', $keys) . "`) VALUES (LAST_INSERT_ID(), {$values})";		
			
			if(!$this->query($sql, $fields)->error()) {
				return true;
			}			
			
			return false;
		}

 

Edited September 23, 2020 by ke-jo

Ok so i want to grab an id from the checkbox then grab the option drop down associated with that check box and update a mysql row here is my code so far

any help is awesome help taaaanks guys

<?php
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query = "SELECT * FROM tickets ORDER BY id DESC";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result))
{

print "<input name='delete[]' value='{$row['id']}' type='checkbox'>";
mysql_connect("localhost", "root", "root") or die(mysql_error());
mysql_select_db("db1") or die(mysql_error());
$query2 = "SELECT * FROM admin";
$result2 = mysql_query($query2) or die(mysql_error());
print "<form name='namestoupdate' method='post' action='update.php'>\n";
print '<select>';
while($row2 = mysql_fetch_array($result2))
{
if ($row2['priv']==prov){print '<option value="'.$row2['user'].'" name="prov['.$i++.']">'.$row2['user'].'</option>';}
}
print '</select>';
print "<input type='submit' value='submit' />";
print "</form>";
}
?>


Visual aid

I am trying to export multiple csv files to download from 2 separate tables in my database.

Some background:
I have a web app that links to a phpmyadmin database. There are 2 tables in the database (entering and exiting). These tables hold the phone inventory information of employees currently entering or exiting the organization.

The fields in my tables a

location, firstname, lastname, username, extension, mac, type

What I am trying to do is export the data in these 2 tables to CSV (which I have working now) but I need to have multiple CSVs for each.

For example, for my exiting table, I need to have one CSV export all the fields in the table and I also need another CSV to export just the location and username field. I have a simple html form with a submit button which is currently working now:

<form action="exportexiting.php" method="POST" style="width: 456px; height: 157px">
   <div>
   <fieldset>
   <legend style="width: 102px; height: 25px"><strong>Entering CSV:</strong></legend>
   <input name="Export" type="submit" id="Export" value="Export">
   </fieldset><br/>
   </div>
</form>


This links to my exportexiting.php file:

<?php
$host = 'localhost';
$user = 'root';
$pass = 'xxxx';
$db = 'PhoneInventory';
$table = 'exiting';


 
// Connect to the database
$link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
 
require 'exportcsv.inc.php';

 
exportMysqlToCsv($table);
 
 
 
?>

Then to exportcsv.inc.php:

<?php
 
function exportMysqlToCsv($table,$filename = 'export.csv')
{
    $csv_terminated = "\n";
    $csv_separator = ",";
    $csv_enclosed = '';
    $csv_escaped = "\\";
    $sql_query = "select * from $table";
 
    // Gets the data from the database
    $result = mysql_query($sql_query);
    $fields_cnt = mysql_num_fields($result);
 
 
    $schema_insert = '';
 
    for ($i = 0; $i < $fields_cnt; $i++)
    {
        $l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,
            stripslashes(mysql_field_name($result, $i))) . $csv_enclosed;
        $schema_insert .= $l;
        $schema_insert .= $csv_separator;
    } // end for
 
    $out = trim(substr($schema_insert, 0, -1));
    $out .= $csv_terminated;
 
    // Format the data
    while ($row = mysql_fetch_array($result))
    {
        $schema_insert = '';
        for ($j = 0; $j < $fields_cnt; $j++)
        {
            if ($row[$j] == '0' || $row[$j] != '')
            {
 
                if ($csv_enclosed == '')
                {
                    $schema_insert .= $row[$j];
                } else
                {
                    $schema_insert .= $csv_enclosed .
               str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;
                }
            } else
            {
                $schema_insert .= '';
            }
 
            if ($j < $fields_cnt - 1)
            {
                $schema_insert .= $csv_separator;
            }
        } // end for
 
        $out .= $schema_insert;
        $out .= $csv_terminated;
    } // end while
 
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Length: " . strlen($out));
    // Output to browser with appropriate mime type, you choose
    header("Content-type: text/x-csv");
    //header("Content-type: text/csv");
    //header("Content-type: application/csv");
    header("Content-Disposition: attachment; filename=$filename");
    echo $out;
    exit;
 
}
 
?>



Again, this is working perfectly for only exporting all the data from the exiting table into one CSV file. My question is, how can I make my one submit button export the 2 CSV files that I need?


Thanks for the help...