PHP - How To Submit A Series Of Post In Php

hi i need help on posting multiple inputs in a single button...while using mysql_fetch_array
here is my codes:

<?
$re6 = mysql_query('select username from users where course = "BSIT" and yearlevel = "FOURTH"');
?>
<br />
<h1>Post Grade</h1>
<h1>IT, Fourth Year</h1>
<br />Please fill the following form to send The Grade<br />
<?
$n = 0;
while($row = mysql_fetch_row($re6))
{
echo'<form action="grade_post.php" method="post">';
echo'Recipient<span class="small">(Username)</span><input type="text" value="'.$row['username'].'" readonly="readonly" id="recip" name="recip[' . $n . ']" />';
echo'Subject<input type="text" value="'.htmlentities($otitle, ENT_QUOTES, 'UTF-8').'" id="title" name="title[' . $n . ']" />';
echo'<input type="hidden" value="FOURTH" id="year" name="year[' . $n . ']" />';
echo'<input type="hidden" value="FIRST" id="sem" name="sem[' . $n . ']" />';
echo'Grade<input type="text" id="message" name="message[' . $n . ']" ><br />';
++$n;
}
?>


i get all my recipients in every input type, but when i tried to post it in my database not all of them are posted rather only one of them are posted in my database ...what i want to happen is that all of my recipients in every input type will be posted in my database with different ids'...help pls...

Hello.

I hope one of the PHP/HTML gurus here can help me. I have a web page that has been altered a bit to add some Google Analytics stuff and I've moved it to a 2nd directory. The original one works fine, the 2nd one won't post the form when I click the submit button.

1st URL https://www.theneutralizer.info/neutralizer
2nd URL: https://www.theneutralizer.info/neutralizer2

I have changed the action property to the correct script, and it does exist. But the problem is when clicking the button nothing happens.

Anyone have any ideas? I can send the PHP code if needed, but since it's HTML output, it should work the way it is displayed in the browser.

David

What im trying to do is create a file with the name "triangular_10.txt" where the number in the file name is the number the user entered. From there I want the text file to have the triangular series of numbers. So if the user enters 10, it'll display the first 10 numbers of the triangular series. So far the file name change is working.

The algorithm is here that I used for PHP:http://www.codecodex.com/wiki/Calculate_a_triangle_number

eg . user enters 10. Result in txt file is first 10 numbers in the triangular series = [1, 3, 6, 10, 15, 21, 28, 36, 45]

This is what I have so far but Im not having any luck! At the moment its only writing the number I entered on to the txt file and nothing else! Any ideas?

$number = $_POST['number-entered'];


    foreach ( range(1, 1000) as $i ) {  
    $triangle_numbers[] = $i * ( $i + 1 ) / 2;  

 } 
    //make a file
    $contents = fopen('gs://a1-task22020.appspot.com/triangular_' .$number. ".txt", "w");
    fwrite($contents, $number);

    //open the file

    $contents = fopen('gs://a1-task22020.appspot.com/' . $contents, 'w');

    // re-open the document if you put something in it
    fwrite($contents, $number);

    fclose($contents);


}
}

 

I have a table that shows all the users in my table. Each user is either a user or an admin. I have radio buttons for each user determining if they are a user or an admin


Right now I have each RB group named userlevel0, userlevel1, userlevel2 etc..

How can I get all the groups dynamically? I attempted an html array but failed.

Hii,   I created a view with few selected data from table. I provided link to title to have redirection on editing page. I am passing variables to dynamic editing page. In editing page, I created a form which is filled automatically using id. Now on submission of updated form I redirected it to another php page for back-end processing. But now I am not getting data of inputs from editing page. POST and GET both are not working. I don't understand why is it not passing values.   Login ► View Data ► Select Data To Update ► Update Is not working here 
Edited by Parth_Innovator, 05 December 2014 - 12:57 PM.

Image name will come from database.
It can be displayed in divs or table cells.
Which is better using divs or table cells?
Can anyone post sample code?
http://img28.imageshack.us/i/44233003.png/

I have a series of string which can have a value or empty. I want to display them with echo.

echo $string1 $string2 $string3; satisfies my need, as it shows available values, but with this method, I will get a PHP notice in my error_logs. What is your suggestion? Do I need to use "if (empty)" or "if(isset)"? The point is I have numerous strings and in each run only few of them have value.

I have a series of echo statements containing html and php elements. Is it possible to somehow store the following statements in one variable by concatenating and later print that variable.
The variable should print out the statements as it is printing now.


Code: [Select]
<?  echo "USER banned:<b>";
 echo '<a style="text-decoration: none;" href="'.$forumurl.'1acpanel/user.php?do=edit&u='.$banuserid.'"<fontcolor="#4822aa" face="verdana" size="2">'.$banusername.'</font></a><br>';

echo "</b>USER Banned By:<b>";

 echo '<a style="text-decoration: none;" href="'.$forumurl.'1acpanel/user.php?do=edit&u='.$banneruserid.'"><font color="#4822aa" face="verdana" size="2">'.$bannerusername.'</font></a><br>';
 echo "</b>Banned on:<b>".$bandate."</b><br>";
echo "Reason:<b>".$reason."</b><br><br>";
?>

I have some data where each has a timestamp when is was measured, and not all data points will be necessarily measured at the same time.

 

                Time |    Value1 |    Value2 |    Value3 |    Value4
 2020-12-15 00:05:07 |           |      27.6 |           |          
 2020-12-15 00:30:27 |           |           |        26 |          
 2020-12-15 01:20:10 |      53.9 |      25.2 |           |          
 2020-12-15 02:09:44 |           |      26.4 |           |      60.2
 2020-12-15 02:43:19 |        33 |      49.2 |           |          
 2020-12-15 03:04:44 |      30.8 |           |           |        42
 2020-12-15 03:21:46 |           |        54 |           |          
 2020-12-15 03:47:19 |      52.8 |           |      53.3 |          
 2020-12-15 04:26:20 |           |           |      27.3 |          
 2020-12-15 04:45:10 |      37.4 |           |           |          
 2020-12-15 05:24:25 |           |        42 |           |          
 2020-12-15 05:34:49 |      36.3 |           |      41.6 |          
 2020-12-15 05:36:04 |      24.2 |           |           |          
 2020-12-15 06:06:47 |      49.5 |           |           |          
 2020-12-15 07:00:07 |           |           |           |        49
 2020-12-15 07:59:17 |           |      27.6 |           |          
 2020-12-15 08:14:45 |           |           |      48.1 |      51.8
 2020-12-15 08:26:36 |           |           |      53.3 |          
 2020-12-15 08:54:23 |      50.6 |           |           |          
 2020-12-15 09:46:53 |           |           |      58.5 |      43.4
 2020-12-15 10:25:03 |           |           |           |      36.4

 

I am trying to obtain the total value (i.e. value1 + value2 + value3 + value4) and since there is no common time interval, come up with an arbitrary one such as one hour.  It doesn't need to be exact and one option is to linearize each sample between each of their individual timestamps, but ideally I can do a little better.  It has been many, many years, and I recall that least squares regression used to be used for things like this, but I think I would need to the process the entire series for each which I expect would require many polynomials.  I've never used R and it might be an option if necessary.  Not sure if there is anything baked into PHP which would be great.    Any ideas?  Thanks

                Time |Total Value
 2020-12-15 00:00:00 |      27.3
 2020-12-15 01:00:00 |      48.4
 2020-12-15 02:00:00 |        21
 2020-12-15 03:00:00 |        22
 2020-12-15 04:00:00 |        49
 2020-12-15 05:00:00 |        38
 2020-12-15 06:00:00 |        49
 2020-12-15 07:00:00 |        29
 2020-12-15 08:00:00 |        49
 2020-12-15 09:00:00 |        46
 2020-12-15 10:00:00 |        36

 

Hey Guys. I am working with a form that shows the grand total on the checkout page. The value of the grand total is inside a hidden field. When click on  submit, the _POST array doesn't get back the last value of the grand total. I need to hit the button twice to get the last value. The weird thing is when I  echo the value of the grand total it display the latest value, but not with the POST array   For example. If the grand total is $10.00 and I click on submit. It will show the POST['grand_total'] as empty. If I click on submit again it will show the grand total of $10.00. Below is my code that I am working with. Any help would be really appreciated.

if(isset($_POST['submit'])) {
/* Doesn't show if i put it after if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}

}

//A bunch of other html/php code. Another class calculates the subtotal assigns it the variable $subtotal



$cart_totals = new cartTotals($subtotal, $discounted_amount,$post_values->tip); // Cart class is shown below

/* Doesn't show if i put it before if($_POST['submit'] */
if(isset($_POST['grand_total'])) {
echo $_POST['grand_total'];
}
echo  "<input name='grand_total' type='hidden' value='$cart_totals->grand_total'  />"; // Shows the grand total after second from submission
echo "$cart_totals->grand_total"; // Shows grand total after the first submission

Cart Totals Class

class cartTotals  {

	public $subtotal;
	public $sales_tax;
        public $tip;
	public $grand_total;
        public $discount_amount;
	public $href_page;
	public $invalidCouponMessage;
	const  TEST_ENVIORMENT = FALSE;


	/**
	 * [ Function gets constructed in the order summary where the [$discount_amount= ""]  arg does need to be passed.
     * But does get passed in when called on the checkout.php page. Therefore we set the default value to an empty string.]
	 * @param [float] $subtotal   [subtotal get passed in from the parent class coreCartFunction]
	 * @param string $discount_amount [The class checkCouponCode calculates this discount amount based on the
     * subtotal and the discount amount. It gets instantiated on the clients side and passed is this construction function.
     * This is all done on the checkout page.]
	 */

    /*The way the construct function works is by invoking all the methods the passed arguments
    When the methods get invoked the do all the work and set the properties its values. The properties then get echoed out
    on the client side.  */
	
    function __construct($subtotal="", $discount_amount= "", $tip=""){
    
    $this->subTotal($subtotal, $discount_amount);//SubTotal method takes the discount amount and subtracts it from the subtotal.
    $this->salesTax($subtotal, $discount_amount);
    $this->tip = $tip;
    $this->grandTotal();
	}

    private function subTotal($subtotal,$discount_amount) {

            $rounded_subtotal = round($subtotal-$discount_amount,2);
            $money_format_subtotal =  money_format('%i',$rounded_subtotal);
            $this->subtotal = $money_format_subtotal;
    }


    private function salesTax($subtotal, $discount_amount =""){
	$sales_tax = (STORE_SALES_TAX)?(float)STORE_SALES_TAX:8.875;
	$sales_tax =(($this->subtotal)*$sales_tax)/100;
	$sales_tax = round($sales_tax,2);
	$this->sales_tax = $sales_tax;
	}


	public function Tip() {
    //global $post_values;
    //$last_tip_selected = $post_values->tip > 0 ? $post_values->tip : "" ;
	$tip_output = "<select id='tip' name='tip'>";
 	for($tip=0.00; $tip<=11.75; $tip+=0.25){
 	if( $tip == "2") {$selected = " selected";} else {$selected ="";}
       $formatted_tip =  money_format('%i',$tip);

	$tip_output .= "<option {$selected} id='selected_tip' value='$formatted_tip'>"."$".$formatted_tip ."</option>".PHP_EOL;
		}

		$tip_output .= "</select>";
		return $tip_output;

    }

    private function grandTotal(){
        $grand_total = round($this->sales_tax+$this->subtotal+$this->tip,2);
        $grand_total_formatted =  money_format('%i',$grand_total);
        $this->grand_total = $grand_total_formatted;

    }

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once.  Is that possible to do? 

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

 

Edited January 13, 2019 by imgrooot

Hi.  Pretty straight forward I guess but as the name suggests am a newbie.  I have a form that requires the user to enter certain parameters.  If the values are blank it submits to itself and loads the error messages.  What I want to do is create PHP code that submits the form to a different url.  What I thought was create two forms (the second with hidden fields replicating the first form), each form having a different url in the action"" code.  What I cant work out is the PHP IF ELSE code to submit form 2 if Form1 is is validated correctly.  This is the PHP code relevant to the form validation.  Help?

<?php
      //If form was submitted
      if ($_POST['submitted']==1) {
          $errormsg = ""; //Initialize errors
          if ($_POST[width]){
             $title = $_POST[width]; //If title was entered
          }
          else{
             $errormsg = "Please enter width";
          }
          if ($_POST[drop]){
             $textentry = $_POST[drop]; //If comment was entered
          }
          else{
             if ($errormsg){ //If there is already an error, add next error
                $errormsg = $errormsg . " & content";
             }else{
                $errormsg = "Please enter drop";
             }
          }
      }

      if ($errormsg){ //If any errors display them
          echo "<div class=\"box red\">$errormsg</div>";
      }

      //If all fields present
      if ($title && $textentry){
         //Do something
          
echo 'THIS IS WHERE I WANT THE CODE TO SUBMIT FORM 2 or SUBMIT FORM 1 TO A DIFFERENT URL';
      }   
      ?>

ok i want to be able to delete the post only if there the one who posted aka blabbed here is the script , please help. if im not clear please tell me!

Code: [Select]

<?php



// Start_session, check if user is logged in or not, and connect to the database all in one included file

include_once("scripts/checkuserlog.php");



if (!$_SESSION['idx']) { 

    $msgToUser = '<br /><br /><font color="#FF0000">Sorry but you must be logged in to view this page!</font><p><br><div align="right"><a href="register.php">Join Here</a></div><form id="signinform" action="login.php" method="post" enctype="multipart/form-data" name="signinform">

    <fieldset>

    

      <legend>Log in</legend>

     

      <label for="login">Email</label>

      <input type="text" id="email" name="email" />

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

      

      <label for="password">Password</label>

      <input type="password" id="password" name="pass" />

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

      

      <label for="remember_me" style="padding: 0;">Remember me?</label>

      <input type="checkbox" id="remember" style="position: relative; top: 3px; margin: 0; " name="remember"/ value="yes" checked="checked">

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

      

      <br />

      

      <input type="submit" style="margin: -20px 0 0 287px;" class="button" name="commit" value="Sign In"/> 

    </fieldset>

  </form></p>';

    include_once 'msgToUser.php'; 

    exit(); 

} else if ($logOptions_id != $_SESSION['id']) {

    $msgToUser = '<br /><br /><font color="#FF0000">Only site members can do that</font><p><a href="register.php">Join Here</a></p>';

    include_once 'msgToUser.php'; 

    exit(); 

}

// Include the class files for auto making links out of full URLs and for Time Ago date formatting

include_once("wi_class_files/autoMakeLinks.php");

include_once ("wi_class_files/agoTimeFormat.php");

// Create the two new objects before we can use them below in this script

$activeLinkObject = new autoActiveLink;

$myObject = new convertToAgo;

?>

<?php 

// ------- INITIALIZE SOME VARIABLES ---------

// they must be initialized in some server environments or else errors will get thrown

$id = "";

$username = "";

$firstname = "";

$lastname = "";

$mainNameLine = "";

$country = "";    

$state = "";

$city = "";

$zip = "";

$bio_body = "";

$website = "";

$youtube = "";

$facebook = "";

$twitter = "";

$twitterWidget = "";

$locationInfo = "";

$user_pic = "";

$blabberDisplayList = "";

$interactionBox = "";

$cacheBuster = rand(999999999,9999999999999); // Put on an image URL will help always show new when changed

// ------- END INITIALIZE SOME VARIABLES ---------



// ------- ESTABLISH THE PAGE ID ACCORDING TO CONDITIONS ---------

if (isset($_GET['id'])) {

     $id = preg_replace('#[^0-9]#i', '', $_GET['id']); // filter everything but numbers

} else if (isset($_SESSION['idx'])) {

     $id = $logOptions_id;

} else {

   header("location: index.php");

   exit();

}

// ------- END ESTABLISH THE PAGE ID ACCORDING TO CONDITIONS ---------



// ------- FILTER THE ID AND QUERY THE DATABASE --------

$id = preg_replace('#[^0-9]#i', '', $id); // filter everything but numbers on the ID just in case

$sql = mysql_query("SELECT * FROM myMembers WHERE id='$id' LIMIT 1"); // query the member

// ------- FILTER THE ID AND QUERY THE DATABASE --------



// ------- MAKE SURE PERSON EXISTS IN DATABASE ---------

$existCount = mysql_num_rows($sql); // count the row nums

 if ($existCount == 0) { // evaluate the count

     header("location: index.php?msg=user_does_not_exist");

     exit();

}

// ------- END MAKE SURE PERSON EXISTS IN DATABASE ---------



// ------- WHILE LOOP FOR GETTING THE MEMBER DATA ---------

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

    $username = $row["username"];

    $firstname = $row["firstname"];

    $lastname = $row["lastname"];

    $country = $row["country"];    

    $state = $row["state"];

    $city = $row["city"];

    $sign_up_date = $row["sign_up_date"];

    $sign_up_date = strftime("%b %d, %Y", strtotime($sign_up_date));

    $last_log_date = $row["last_log_date"];

    $last_log_date = strftime("%b %d, %Y", strtotime($last_log_date));    

    $bio_body = $row["bio_body"];    

    $bio_body = str_replace("'", "'", $bio_body);

    $bio_body = stripslashes($bio_body);

    $website = $row["website"];

    $youtube = $row["youtube"];

    $facebook = $row["facebook"];

    $twitter = $row["twitter"];

    $friend_array = $row["friend_array"];

    ///////  Mechanism to Display Pic. See if they have uploaded a pic or not  //////////////////////////

    $check_pic = "members/$id/image01.jpg";

    $default_pic = "members/0/image01.jpg";

    if (file_exists($check_pic)) {

    $user_pic = "<img src=\"$check_pic?$cacheBuster\" width=\"218px\" />"; 

    } else {

    $user_pic = "<img src=\"$default_pic\" width=\"218px\" />"; 

    }

    ///////  Mechanism to Display Real Name Next to Username - real name(username) //////////////////////////

    if ($firstname != "") {

        $mainNameLine = "$firstname $lastname ($username)";

        $username = $firstname;

    } else {

        $mainNameLine = $username;

    }

    ///////  Mechanism to Display Youtube channel link or not  //////////////////////////

    if ($youtube == "") {

    $youtube = "";

    } else {

    $youtube = '<br /><br /><img src="images/youtubeIcon.jpg" width="18" height="12" alt="Youtube Channel for ' . $username . '" /> <strong>YouTube Channel:</strong><br /><a href="http://www.youtube.com/user/' . $youtube . '" target="_blank">youtube.com/' . $youtube . '</a>';

    }

    ///////  Mechanism to Display Facebook Profile link or not  //////////////////////////

    if ($facebook == "") {

    $facebook = "";

    } else {

    $facebook = '<br /><br /><img src="images/facebookIcon.jpg" width="18" height="12" alt="Facebook Profile for ' . $username . '" /> <strong>Facebook Profile:</strong><br /><a href="http://www.facebook.com/profile.php?id=' . $facebook . '" target="_blank">profile.php?id=' . $facebook . '</a>';

    }

    ///////  Mechanism to Display Twitter Tweet Widget or not  //////////////////////////

    if ($twitter == "") {

    $twitterWidget = "";

    } else {

    $twitterWidget = "<script src=\"http://widgets.twimg.com/j/2/widget.js\"></script>

<script>

new TWTR.Widget({

  version: 2,

  type: 'profile',

  rpp: 5,

  interval: 6000,

  width: 218,

  height: 160,

  theme: {

    shell: {

      background: '#BDF',

      color: '#000000'

    },

    tweets: {

      background: '#ffffff',

      color: '#000000',

      links: '#0066FF',

    }

  },

  features: {

    scrollbar: true,

    loop: false,

    live: false,

    hashtags: true,

    timestamp: true,

    avatars: false,

    behavior: 'all'

  }

}).render().setUser('$twitter').start();

</script>";

    }

    ///////  Mechanism to Display Website URL or not  //////////////////////////

    if ($website == "") {

    $website = "";

    } else {

    $website = '<br /><br /><img src="images/websiteIcon.jpg" width="18" height="12" alt="Website URL for ' . $username . '" /> <strong>Website:</strong><br /><a href="http://' . $website . '" target="_blank">' . $website . '</a>'; 

    }

    ///////  Mechanism to Display About me text or not  //////////////////////////

    if ($bio_body == "") {

    $bio_body = "";

    } else {

    $bio_body = '<div class="infoBody">' . $bio_body . '</div>'; 

    }

    ///////  Mechanism to Display Location Info or not  //////////////////////////

    if ($country == "" && $state == "" && $city == "") {

    $locationInfo = "";

    } else {

    $locationInfo = "$city &middot; $state<br />$country ".'<a href="#" onclick="return false" onmousedown="javascript:toggleViewMap(\'google_map\');">view map</a>'; 

    }

} // close while loop

// ------- END WHILE LOOP FOR GETTING THE MEMBER DATA ---------



// ------- POST NEW BLAB TO DATABASE ---------

$blab_outout_msg = "";

if (isset($_POST['blab_field']) && $_POST['blab_field'] != "" && $_POST['blab_field'] != " "){

    

     $blabWipit = $_POST['blabWipit'];

     $sessWipit = base64_decode($_SESSION['wipit']);

     if (!isset($_SESSION['wipit'])) {

         

     } else if ($blabWipit == $sessWipit) {

          // Delete any blabs over 50 for this member

          $sqlDeleteBlabs = mysql_query("SELECT * FROM blabbing WHERE mem_id='$id' ORDER BY blab_date DESC LIMIT 50");

          $bi = 1;

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

              $blad_id = $row["id"];

              if ($bi > 20) {

                   $deleteBlabs = mysql_query("DELETE FROM blabbing WHERE id='$blad_id'");

              }

              $bi++;

          }

          // End Delete any blabs over 20 for this member

          $blab_field = $_POST['blab_field'];

          $blab_field = stripslashes($blab_field);

          $blab_field = strip_tags($blab_field);

          $blab_field = mysql_real_escape_string($blab_field);

          $blab_field = str_replace("'", "'", $blab_field);

          $sql = mysql_query("INSERT INTO blabbing (mem_id, the_blab, blab_date) VALUES('$id','$blab_field', now())") or die (mysql_error());

          $blab_outout_msg = "";

          }

}

// ------- END POST NEW BLAB TO DATABASE ---------



// ------- MEMBER BLABS OUTPUT CONSTRUCTION ---------

///////  Mechanism to Display Pic

    if (file_exists($check_pic)) {

    $blab_pic = '<div style="overflow:hidden; height:40px;"><a href="profile.php?id=' . $id . '"><img src="' . $check_pic . '" width="40px" border="0" /></a></div>'; 

    } else {

    $blab_pic = '<div style="overflow:hidden; height:40px;"><a href="profile.php?id=' . $id . '"><img src="' . $default_pic . '" width="40px" border="0" /></a></div>'; 

    }

///////  END Mechanism to Display Pic    

$sql_blabs = mysql_query("SELECT id, mem_id, the_blab, blab_date FROM blabbing WHERE mem_id='$id' ORDER BY blab_date DESC LIMIT 20");



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

    

    $blabid = $row["id"];

    $uid = $row["mem_id"];

    $the_blab = $row["the_blab"];

    $the_blab = ($activeLinkObject -> makeActiveLink($the_blab));

    $blab_date = $row["blab_date"];

    $convertedTime = ($myObject -> convert_datetime($blab_date));

    $whenBlab = ($myObject -> makeAgo($convertedTime));

    

                $blabberDisplayList .= '

                    <table style="background-color:#FFF; border:#999 1px solid; border-top:none;" cellpadding="5" width="100%">

                    <tr>

                    <td width="10%" valign="top">' . $blab_pic . '</td>

                    <td width="90%" valign="top" style="line-height:1.5em;"><span class="greenColor textsize10">' . $whenBlab . ' <a href="profile.php?id=' . $uid . '">' . $username . '</a> said:</span><br />

            ' . $the_blab . '</td>

            </tr></table>';

    

}

// ------- END MEMBER BLABS OUTPUT CONSTRUCTION ---------



// ------- ESTABLISH THE PROFILE INTERACTION TOKEN ---------

$thisRandNum = rand(9999999999999,999999999999999999);

$_SESSION['wipit'] = base64_encode($thisRandNum); // Will always overwrite itself each time this script runs

// ------- END ESTABLISH THE PROFILE INTERACTION TOKEN ---------



// ------- EVALUATE WHAT CONTENT TO PLACE IN THE MEMBER INTERACTION BOX -------------------

// initialize some output variables

$friendLink = "";

$the_blab_form = "";

if (isset($_SESSION['idx']) && $logOptions_id != $id) { // If SESSION idx is set, AND it does not equal the profile owner's ID



    // SQL Query the friend array for the logged in viewer of this profile if not the owner

    $sqlArray = mysql_query("SELECT friend_array FROM myMembers WHERE id='" . $logOptions_id ."' LIMIT 1"); 

    while($row=mysql_fetch_array($sqlArray)) { $iFriend_array = $row["friend_array"]; }

     $iFriend_array = explode(",", $iFriend_array);

    if (in_array($id, $iFriend_array)) { 

        $friendLink = '<a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'remove_friend\');">Remove Friend</a>';

    } else {

        $friendLink = '<a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'add_friend\');">Add as Friend</a>';    

    }

    /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    $interactionBox = '<br /><br /><div class="interactionLinksDiv">

           ' . $friendLink . ' 

           <a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'private_message\');">Private Message</a>

          </div><br />';

          $the_blab_form = '<div style="background-color:#BDF; border:#999 1px solid; padding:8px;">

          <textarea name="blab_field" rows="3" style="width:99%;"></textarea>

          <strong>Write on ' . $username . '\'s Board (coming soon)</strong>

          </div>';

} else if (isset($_SESSION['idx']) && $logOptions_id == $id) { // If SESSION idx is set, AND it does equal the profile owner's ID

    $interactionBox = '<br /><br /><div class="interactionLinksDiv">

           <a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'friend_requests\');">Friend Requests</a>

          </div><br />';

          $the_blab_form = ' ' . $blab_outout_msg . '

          <div style="background-color:#BDF; border:#999 1px solid; padding:8px;">

          <form action="profile.php" method="post" enctype="multipart/form-data" name="blab_from">

          <textarea name="blab_field" rows="3" style="width:99%;"></textarea>

          <input name="blabWipit" type="hidden" value="' . $thisRandNum . '" />

          <strong>Blab away ' . $username . '</strong> (220 char max) <input name="submit" type="submit" value="Blab" />

          <div align="right">

          </form></div>';

} else { // If no SESSION id is set, which means we have a person who is not logged in

    $interactionBox = '<div style="border:#CCC 1px solid; padding:5px; background-color:#E4E4E4; color:#999; font-size:11px;">

           <a href="register.php">Sign Up</a> or <a href="login.php">Log In</a> to interact with ' . $username . '

          </div>';

          $the_blab_form = '<div style="background-color:#BDF; border:#999 1px solid; padding:8px;">

          <textarea name="blab_field" rows="3" style="width:99%;"></textarea>

          <a href="register.php">Sign Up</a> or <a href="login.php">Log In</a> to write on ' . $username . '\'s Board

          </div>';

}

// ------- END EVALUATE WHAT CONTENT TO PLACE IN THE MEMBER INTERACTION BOX -------------------



// ------- POPULATE FRIEND DISPLAY LISTS IF THEY HAVE AT LEAST ONE FRIEND -------------------

$friendList = "";

$friendPopBoxList = "";

if ($friend_array  != "") { 

    // ASSEMBLE FRIEND LIST AND LINKS TO VIEW UP TO 6 ON PROFILE

    $friendArray = explode(",", $friend_array);

    $friendCount = count($friendArray);

    $friendArray6 = array_slice($friendArray, 0, 6);

    

    $friendList .= '<div class="infoHeader">' . $username . '\'s Friends (<a href="#" onclick="return false" onmousedown="javascript:toggleViewAllFriends(\'view_all_friends\');">' . $friendCount . '</a>)</div>';

    $i = 0; // create a varible that will tell us how many items we looped over 

     $friendList .= '<div class="infoBody" style="border-bottom:#666 1px solid;"><table id="friendTable" align="center" cellspacing="4"></tr>'; 

    foreach ($friendArray6 as $key => $value) { 

        $i++; // increment $i by one each loop pass 

        $check_pic = 'members/' . $value . '/image01.jpg';

            if (file_exists($check_pic)) {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="' . $check_pic . '" width="54px" border="1"/></a>';

            } else {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="members/0/image01.jpg" width="54px" border="1"/></a> &nbsp;';

            }

            $sqlName = mysql_query("SELECT username, firstname FROM myMembers WHERE id='$value' LIMIT 1") or die ("Sorry we had a mysql error!");

            while ($row = mysql_fetch_array($sqlName)) { $friendUserName = substr($row["username"],0,12); $friendFirstName = substr($row["firstname"],0,12);}

            if (!$friendUserName) {$friendUserName = $friendFirstName;} // If username is blank use the firstname... programming changes in v1.32 call for this

            if ($i % 6 == 4){

                $friendList .= '<tr><td><div style="width:56px; height:68px; overflow:hidden;" title="' . $friendUserName . '">

                <a href="profile.php?id=' . $value . '">' . $friendUserName . '</a><br />' . $frnd_pic . '

                </div></td>';  

            } else {

                $friendList .= '<td><div style="width:56px; height:68px; overflow:hidden;" title="' . $friendUserName . '">

                <a href="profile.php?id=' . $value . '">' . $friendUserName . '</a><br />' . $frnd_pic . '

                </div></td>'; 

            }

    } 

     $friendList .= '</tr></table>

     <div align="right"><a href="#" onclick="return false" onmousedown="javascript:toggleViewAllFriends(\'view_all_friends\');">view all</a></div>

     </div>'; 

    // END ASSEMBLE FRIEND LIST... TO VIEW UP TO 6 ON PROFILE

    // ASSEMBLE FRIEND LIST AND LINKS TO VIEW ALL(50 for now until we paginate the array)

    $i = 0;

    $friendArray50 = array_slice($friendArray, 0, 50);

    $friendPopBoxList = '<table id="friendPopBoxTable" width="100%" align="center" cellpadding="6" cellspacing="0">';

    foreach ($friendArray50 as $key => $value) { 

        $i++; // increment $i by one each loop pass 

        $check_pic = 'members/' . $value . '/image01.jpg';

            if (file_exists($check_pic)) {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="' . $check_pic . '" width="54px" border="1"/></a>';

            } else {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="members/0/image01.jpg" width="54px" border="1"/></a> &nbsp;';

            }

            $sqlName = mysql_query("SELECT username, firstname, country, state, city FROM myMembers WHERE id='$value' LIMIT 1") or die ("Sorry we had a mysql error!");

            while ($row = mysql_fetch_array($sqlName)) { $funame = $row["username"]; $ffname = $row["firstname"]; $fcountry = $row["country"]; $fstate = $row["state"]; $fcity = $row["city"]; }

            if (!$funame) {$funame = $ffname;} // If username is blank use the firstname... programming changes in v1.32 call for this

                if ($i % 2) {

                    $friendPopBoxList .= '<tr bgcolor="#F4F4F4"><td width="14%" valign="top">

                    <div style="width:56px; height:56px; overflow:hidden;" title="' . $funame . '">' . $frnd_pic . '</div></td>

                     <td width="86%" valign="top"><a href="profile.php?id=' . $value . '">' . $funame . '</a><br /><font size="-2"><em>' . $fcity . '<br />' . $fstate . '<br />' . $fcountry . '</em></font></td>

                    </tr>';  

                } else {

                    $friendPopBoxList .= '<tr bgcolor="#E0E0E0"><td width="14%" valign="top">

                    <div style="width:56px; height:56px; overflow:hidden;" title="' . $funame . '">' . $frnd_pic . '</div></td>

                     <td width="86%" valign="top"><a href="profile.php?id=' . $value . '">' . $funame . '</a><br /><font size="-2"><em>' . $fcity . '<br />' . $fstate . '<br />' . $fcountry . '</em></font></td>

                    </tr>';  

                }

    } 

    $friendPopBoxList .= '</table>';

    // END ASSEMBLE FRIEND LIST AND LINKS TO VIEW ALL(50 for now until we paginate the array)

}

// ------- END POPULATE FRIEND DISPLAY LISTS IF THEY HAVE AT LEAST ONE FRIEND -------------------

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<meta name="Description" content="Profile for <?php echo "$username"; ?>" />

<meta name="Keywords" content="<?php echo "$username, $city, $state, $country"; ?>" />

<meta name="rating" content="General" />

<meta name="ROBOTS" content="All" />

<title>Site Profile for <?php echo "$username"; ?></title>

<link href="style/main.css" rel="stylesheet" type="text/css" />

<link rel="icon" href="favicon.png" type="image/x-icon" />

<link rel="shortcut icon" href="favicon.png" type="image/x-icon" />

<script src="js/jquery-1.4.2.js" type="text/javascript"></script>

<style type="text/css">

<!--

.infoHeader {

    background-color: #BDF;

    font-size:11px;

    font-weight:bold;

    padding:8px;

    border: #999 1px solid;

    border-bottom:none;

    width:200px;

}

.infoBody{

    background-color: #FFF;

    font-size:11px;

    padding:8px;

    border: #999 1px solid;

    border-bottom:none;

    width:200px;

}

/* ------- Interaction Links Class -------- */

.interactionLinksDiv a {

   border:#B9B9B9 1px solid; padding:5px; color:#060; font-size:11px; background-image:url(style/headerBtnsBG.jpg); text-decoration:none;

}

.interactionLinksDiv a:hover {

    border:#090 1px solid; padding:5px; color:#060; font-size:11px; background-image:url(style/headerBtnsBGover.jpg);

}

/* ------- Interaction Containers Class -------- */

.interactContainers {

    padding:8px;

    background-color:#BDF;

    border:#999 1px solid;

    display:none;

}

#add_friend_loader {

    display:none;

}

#remove_friend_loader {

    display:none;

}

#interactionResults {

    display:none;

    font-size:16px;

    padding:8px;

}

#friendTable td{

    font-size:9px;

}

#friendTable td a{

    color:#03C;

    text-decoration:none;

}

#view_all_friends {

    background-image:url(style/opaqueDark.png);

    width:270px;

    padding:20px;

    position:fixed;

    top:150px;

    display:none;

    z-index:100;

    margin-left:50px;

}

#google_map {

    background-image:url(style/opaqueDark.png);

    padding:20px;

    position:fixed;

    top:150px;

    display:none;

    z-index:100;

    margin-left:50px;

}

-->

</style>

<script language="javascript" type="text/javascript">

// jQuery functionality for toggling member interaction containers

function toggleInteractContainers(x) {

        if ($('#'+x).is(":hidden")) {

            $('#'+x).slideDown(200);

        } else {

            $('#'+x).hide();

        }

        $('.interactContainers').hide();

}

function toggleViewAllFriends(x) {

        if ($('#'+x).is(":hidden")) {

            $('#'+x).fadeIn(200);

        } else {

            $('#'+x).fadeOut(200);

        }

}

function toggleViewMap(x) {

        if ($('#'+x).is(":hidden")) {

            $('#'+x).fadeIn(200);

        } else {

            $('#'+x).fadeOut(200);

        }

}

// Friend adding and accepting stuff

var thisRandNum = "<?php echo $thisRandNum; ?>";

var friendRequestURL = "scripts_for_profile/request_as_friend.php";

function addAsFriend(a,b) {

    $("#add_friend_loader").show();

    $.post(friendRequestURL,{ request: "requestFriendship", mem1: a, mem2: b, thisWipit: thisRandNum } ,function(data) {

        $("#add_friend").html(data).show().fadeOut(12000);

    });   

}

function acceptFriendRequest (x) {

    $.post(friendRequestURL,{ request: "acceptFriend", reqID: x, thisWipit: thisRandNum } ,function(data) {

            $("#req"+x).html(data).show();

    });

}

function denyFriendRequest (x) {

    $.post(friendRequestURL,{ request: "denyFriend", reqID: x, thisWipit: thisRandNum } ,function(data) {

           $("#req"+x).html(data).show();

    });

}

// End Friend adding and accepting stuff

// Friend removal stuff

function removeAsFriend(a,b) {

    $("#remove_friend_loader").show();

    $.post(friendRequestURL,{ request: "removeFriendship", mem1: a, mem2: b, thisWipit: thisRandNum } ,function(data) {

        $("#remove_friend").html(data).show().fadeOut(12000);

    });   

}

// End Friend removal stuff

// Start Private Messaging stuff

$('#pmForm').submit(function(){$('input[type=submit]', this).attr('disabled', 'disabled');});

function sendPM ( ) {

      var pmSubject = $("#pmSubject");

      var pmTextArea = $("#pmTextArea");

      var sendername = $("#pm_sender_name");

      var senderid = $("#pm_sender_id");

      var recName = $("#pm_rec_name");

      var recID = $("#pm_rec_id");

      var pm_wipit = $("#pmWipit");

      var url = "scripts_for_profile/private_msg_parse.php";

      if (pmSubject.val() == "") {

           $("#interactionResults").html('<img src="images/round_error.png" alt="Error" width="31" height="30" /> &nbsp; Please type a subject.').show().fadeOut(6000);

      } else if (pmTextArea.val() == "") {

           $("#interactionResults").html('<img src="images/round_error.png" alt="Error" width="31" height="30" /> &nbsp; Please type in your message.').show().fadeOut(6000);

      } else {

           $("#pmFormProcessGif").show();

           $.post(url,{ subject: pmSubject.val(), message: pmTextArea.val(), senderName: sendername.val(), senderID: senderid.val(), rcpntName: recName.val(), rcpntID: recID.val(), thisWipit: pm_wipit.val() } ,           function(data) {

               $('#private_message').slideUp("fast");

               $("#interactionResults").html(data).show().fadeOut(10000);

               document.pmForm.pmTextArea.value='';

               document.pmForm.pmSubject.value='';

               $("#pmFormProcessGif").hide();

           });

      }

}

// End Private Messaging stuff

</script>

</head>

<body>

<?php include_once "header_template.php"; ?>

<table class="mainBodyTable" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td width="738" valign="top"><br />

      <table width="98%" border="0" align="center" cellpadding="6">

      <tr>

        <td width="33%" valign="top">

          <?php echo $user_pic; ?>

          <?php echo $bio_body; ?>

          <div class="infoHeader"><?php echo $username; ?>'s Information</div>

          <div class="infoBody">

          <?php echo $locationInfo; ?>

          <?php echo $website; ?>

          <?php echo $youtube; ?>

          <?php echo $facebook; ?>

          </div>

          <?php echo $friendList; ?>

          <div id="view_all_friends">

              <div align="right" style="padding:6px; background-color:#FFF; border-bottom:#666 1px solid;">

                       <div style="display:inline; font-size:14px; font-weight:bold; margin-right:150px;">All Friends</div>

                       <a href="#" onclick="return false" onmousedown="javascript:toggleViewAllFriends('view_all_friends');">close </a>

              </div>

              <div style="background-color:#FFF; height:240px; overflow:auto;">

                   <?php echo $friendPopBoxList; ?>

              </div>

              <div style="padding:6px; background-color:#000; border-top:#666 1px solid; font-size:10px; color: #0F0;">

                       Temporary programming shows 50 maximum. Navigating through the full list is coming soon.

              </div>

         </div>

         <?php echo $twitterWidget; ?>

         <div class="infoBody" style="border-bottom:#999 1px solid;"><?php include_once("ad_200_square.php"); ?></div> 

          </td>

        <td width="67%" valign="top">

          <span style="font-size:16px; font-weight:800;"><?php echo $mainNameLine; ?></span>

         

          <?php echo $interactionBox; ?>

 

          <div class="interactContainers" id="add_friend">

                <div align="right"><a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('add_friend');">cancel</a> </div>

                Add <?php echo "$username"; ?> as a friend? &nbsp;

                <a href="#" onclick="return false" onmousedown="javascript:addAsFriend(<?php echo $logOptions_id; ?>, <?php echo $id; ?>);">Yes</a>

                <span id="add_friend_loader"><img src="images/loading.gif" width="28" height="10" alt="Loading" /></span>

          </div>

         

          <div class="interactContainers" id="remove_friend">

                <div align="right"><a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('remove_friend');">cancel</a> </div>

                Remove <?php echo "$username"; ?> from your friend list? &nbsp;

                <a href="#" onclick="return false" onmousedown="javascript:removeAsFriend(<?php echo $logOptions_id; ?>, <?php echo $id; ?>);">Yes</a>

                <span id="remove_friend_loader"><img src="images/loading.gif" width="28" height="10" alt="Loading" /></span>

          </div>

         

          <!-- START DIV that serves as an interaction status and results container that only appears when we instruct it to -->

          <div id="interactionResults" style="font-size:15px; padding:10px;"></div>

          <!-- END DIV that serves as an interaction status and results container that only appears when we instruct it to -->

         

          <!-- START DIV that contains the Private Message form -->

          <div class="interactContainers" id="private_message">

<form action="javascript:sendPM();" name="pmForm" id="pmForm" method="post">

<font size="+1">Sending Private Message to <strong><em><?php echo "$username"; ?></em></strong></font><br /><br />

Subject:

<input name="pmSubject" id="pmSubject" type="text" maxlength="64" style="width:98%;" />

Message:

<textarea name="pmTextArea" id="pmTextArea" rows="8" style="width:98%;"></textarea>

  <input name="pm_sender_id" id="pm_sender_id" type="hidden" value="<?php echo $_SESSION['id']; ?>" />

  <input name="pm_sender_name" id="pm_sender_name" type="hidden" value="<?php echo $_SESSION['username']; ?>" />

  <input name="pm_rec_id" id="pm_rec_id" type="hidden" value="<?php echo $id; ?>" />

  <input name="pm_rec_name" id="pm_rec_name" type="hidden" value="<?php echo $username; ?>" />

  <input name="pmWipit" id="pmWipit" type="hidden" value="<?php echo $thisRandNum; ?>" />

  <span id="PMStatus" style="color:#F00;"></span>

  <br /><input name="pmSubmit" type="submit" value="Submit" /> or <a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('private_message');">Close</a>

<span id="pmFormProcessGif" style="display:none;"><img src="images/loading.gif" width="28" height="10" alt="Loading" /></span></form>

          </div>

          <!-- END DIV that contains the Private Message form -->

        &n

Hi,

 

I have a series of post to post connections. In one function, the output is a list of the linked post to posts. Here is an example:

function countryJob(){

global $post;

    $echo = f_print(array(
        'data' => 'p2p',
        'type' => 'ul',
        'args' => array(
            'connection_type' => 'job_to_location',
            'post_type' => 'job',
            'connection_id' => $post->ID,
            'alternative' => '',
        ),
));

    echo '<div class="country-job-text">'.$echo.'</div>';

 

job, location and city are all post types that can be connected.

 

I want to create the same as above to create a list of the cites connected to a location (locations are the name for posts which are countries)

 

How do I discover the connection type and post type needed to create this output?