PHP - Not Sure How To Build The Form Any Idea's

Hey guys,   I have a PHP wrapper which I need a html form made for. It's a very small bit of work   In exchange I will give you a 15€ Gift Voucher for my online website, we are a sweets and drinks store online!   You can email me at dubplates@safe-mail.net   Many thanks,   - D

Instead of breaking down and actually learning how to use ajax, I'm thinking about trying to do something so I don't need a page refresh every time, and the filtered data is nearly instant. I just use the session array var, and build a new array from the rows that meet the conditions.

I'm thinking of loading a two dimensional array into a session var, then use some input buttons, and use the post vars to filter the array based on a set of predefined conditions. ie status = 0, status = 1. It's a fairly small number of conditions applied to two different fields.

So, I need to access specific fields within a row, and essentially create a new array either including or excluding that row depending on whether it met the condition.

I'm struggling on several parts.
1. not sure how to build the array so that I can access specific fields, then not sure how to access those fields.
Do I do this..... to build the array? ....
Code: [Select]
while($row = mysql_fetch_assoc($result)){
   $array[] = array($row['field1'], $row['field2']);
}


I was thinking about using a foreach and is_array() to get to each row...
Code: [Select]
foreach($array as $key => $value){
   if(is_array){
      foreach($value as $k => $v){
         if($v[0] == 1){  //stuck here $v[0] is not a field, it's the first char of the string. not sure how to access a field
            $new_array[] = $value;  //stuck here. I need to put the whole row back into the array if the condition was true. seems like I would have to use the field selectors and rebuild the array.
         }
      }
  }

}


What would you do? Open to any ideas.

Hello again, guys!

I'm trying to do this:

Get $user_ID -> SELECT FROM favorites WHERE user="$user_ID" -> Now I should create an array with the ID of all the results of the previous command ->
SELECT FROM books WHERE genre="$favorites_ID" -> populate a html table.

The part I've no idea about how to do is building an array with the results and then using the SELECT command, find in the other tables the match.

Could you please give me a hand - one more time?

HI,

coming from a .net background and picking up php as I go along, I was wondering what the best way
of designing the following task is in php.

It's part of an appointmnet reminder app and the admin can amend the message that is sent out.

The default message is currently stored in a db table and displayed in a multi line box on the admin web page.

for example,

"This is a an appointment reminder for *patient name*. You have an appointment on *date* with *customer name*."

There's two parts relating to the message process.

1. Allowing the admin to amend the message (but ensuring the *variable markers* are left in tact, so I know
where to stick the variables for part 2)

2. When the messages are being sent out (for each loop), inserting the *variables* into the message.

I have no problem getting hold of the *name*, *date*, *customer* for each iteration in the for each loop.

I'm sure people have done stuff like this before and in .net I would use a stringbuilder object but like i say,
I'm not all that groovy on php at the mo.

I was thinking of maybe a function that accepts thats passed the message, name, date, customer or something..

thanks

Hello.  I would like to build a survey that I can use on an iPad so that I can go out in the field and gather data from people.

What would be the best way to accomplish this?

I'm not sure what limitations even exist on an iPad - like can you have a webserver like MAMP?

It seems to me that using something like Angular or whatever might make sense since you can build a working app all in one, but then I don't even know traditional Javascript.

Just looking for a quick way to build something to allow me to survey people without making this a major project.\

Thanks.

Hi,

I have to build some reports based on mysql queries. Nothing fancy, just text, columns...

There are a lot of paid softwares but I can't (and don't want to) spend any $$ right now...

So, considering that I want very simple reports almost like a table with heading and subtotals, I should write it myself. But I don't know how (still...).

I'm looking for tips, tutorials, ebooks... anything that explains how to make a very simply report.

Regards,
Pedro.

Hi there,

i have a problem regarding a editor that I am building, I am fairly new to php, but this is what i have so far:

Code: [Select]
<?php

$dirname = ".";
$dir = opendir($dirname);
?>
<form action="editor.php" method="POST">
<select>
<?php
while(false != ($file = readdir($dir)))
if (strpos($file, '.php',1)||strpos($file, '.html',1)||strpos($file, '.css',1) ) { 
{
if(($file != ".") and ($file != ".."))
{
echo("<option><a href='$file'>$file</a></option>");
}
}}
?>
</select>
<input type="submit" value="Submit" />
</form>

<br />
<center>
<form >
<textarea rows="80" cols="130">
<?php include $_POST["$file"]; ?>

</textarea>

</center>

The code produces a drop down list of any html, php or css files in the current directory and I want it to be able to show the selected file from the drop down list in the textarea so that I can edit it, I also am not sure how to save the file, would this be a file write method?

any help would really be appreciated as I've been stuck on this issue for hours an its doing my nut in!!!

Thanks
SF

I have two questions, I was wondering what would be the best method to go about building client side API functions on top of a already built API eg. http://docs.whmcs.com/API:Functions We would like to provide our clients access to API functions related to their accounts without giving them access to the whole Admin API where they can see a lot of our other client information.   The other question we have an API built using Basic HTTP Auth for API authenication (HTTPS). eg curl username:password http://api.etc.com) If so what would be the best way to secure this method?       Thank you

So, I need to build a table based on this table:
Code: [Select]
create temporary table downline (
depth int,
member_id int,
full_name varchar(50),
level int,
referrer_id int,
country char(2)
);
I need to make a table to show each members downline (the people they referred to the site), it needs to be unlimited levels deep, and we have some members that have 25+ levels in their downline, where level 20 has 15,000+ people.

Level 1 = your downline
Level 2 = your donwline's downline
Level 3 = your downline's downline's downline
ect.

I have this loop (after the temp table is built) which needs to build a table on the page.


So, I can not get this table display right for the members downline, any suggestions?

// Build the current users downline and add it to the temporary table
$downline = mysql_query("select * from downline order by depth");
while($row = mysql_fetch_assoc($downline)){

if($row['depth'] != $depth){

$depth_id = $row['depth'];

$content .= "<tr id='main_lvl_$depth_id' class='hiddenInfo' onclick='showHide(this);'><td style='text-align: center;color:#4d53c1;font-weight: bold;' class='w_border'><span class='signs_s'>".$this->dict['mLevels_Level']." $depth_id : </span><span class='signs'>".count($down)." ".$this->dict['mLevels_Members']." </span></td></tr><tr id='lvl_$depth_id' style='display:none;'><td class='w_border' style='text-align: center;'><table style='width:100%;'>";

$i = 0;

$content .= "<tr>

<th>Member ID (Sponsor ID)</th>

<th>Member Name</th>

<th>Country</th>

<th>Member Level</th>

</tr>";

}

$class = ($i%2) ? 'color1NL' : 'color2NL';

$content .= "<tr id='_{$key}_' class='$class'><td class='width33'><a name='_".$row['member_id']."'></a><a href='?mid={$row['member_id']}'>#{$row['member_id']}</a> (<a href='?mid=".$row['referrer_id']."'>#".$row['referrer_id']."</a>)</td><td class='width33'>".$row['full_name']."</td><td>".$row['country']."</td><td class='width33'>".$row['level']."</td></tr>";

$i++;

if($row['depth'] != $depth){

$content .= "</table></td></tr>";

}

$depth = $row['depth'];
}

The following attachment has a working copy. The reason we don't stay with this is because it doesn't work with members who have large downlines, we run out of memory in php, and this hopefully will solve this problem.

Ok so I'll try to explain what I'm trying to do the best I can. I want to build an array that allows me to add/remove/modify the variables used at any point in time without having to rebuild or rewrite a ton of new code.

For example, below is an example list of variables I'd like to use in the array, followed by the code I would like to be automatically repeated.

Example Variables: $materialName1, $materialName2, $materialName3, $materialName4, $materialName5, $materialName6 etc etc etc
Example Code to repeat:
Code: [Select]
echo "<tr><td>Material: $materialName1</td><td>Rate: $materialName1Rate</td><td>Weight: $materialName1Weight</td></tr>";

Hopefully that makes sense. As always, very appreciated.

Hey PF. I'm trying to build some better coding habits, so what tips do you guys have? Of course there are obvious things such as well-commented code, neat structure, etc...

But I'm looking for some more "TECHNICAL" tips that might be unspoken. For example, when is a good time to use a variable, opposed to a constant? I notice that a lot of programmers define their database settings with define(), while others just use a $variable. Is this personal preference or maybe its something I'm missing?

I'm looking for ALL tips. Any information that you have, please share it. It will help make me (And anyone else reading this), a better coder.
Thanks in advance.

and if this is not the proper forum, please move it! =]

How could I build an interactive text system?
 It should work like this:
 Text is displayed.
 1-3 options (a situational amount of them) to answer displayed.
 Example:
 Are you male?
 Yes
 No

 You choose yes or no and it leads you to another questions based from your previous answer.
 Example: (a follow up to the 1st one)
 So you're male. Do you like cars then?
 Answers.
 And it goes on and on.

 The thing I need help with is the answers. I need to show them based by the previous answer but don't know how, any help?

Hiya peeps!

I can't seem to build a preg_match pattern that works.

This is what I need to do.

"[" . $errorID . "]='HERE IS WHAT I NEED TO DISPLAY';"

Does anyone have any ideas on how I would build this regex string?

Many thanks,

James.

HI,
I'm writing a auction website .in auction website we need to check for new information every second so it needs to be ajax.
we have a timer which calculate the end time of every auction and it needs to be updated every second.Do you have any idea for reducing the process of calculating maybe a client side but something that is updated by server?
I mean , the timer works with client side and when the users BID , the timer needs to be refresh.So every time that Bid button hilted the time should be refresh.
What's you idea?How can do something like that?

Thanks

I have  a dropdown list where the values are retrieved form the mysql
the dropdownlist is coded in php as below:

$data = mysql_query("Select * From Project");
         echo "<select name = 'Project' onchange = 'showUser(this.value)'>n";
         while ($row = mysql_fetch_assoc($data))
         {
         $id = $row['Project_Id'];
         $ProjectName = $row['ProjectName'];
         echo "<option value = $id>$ProjectName";
         }
         echo"</select>";
         echo "<br/>";
         echo "<br/><div id='txtHint' style='width:30em; margin:0 auto;'></div><br/>";

this dropdownlist will retrieved the names of PROJECTS available in the database.
when the user click any of the rpojects, it will displayed the engagements that belong to the selected PROJECT.
This is also retrieved and display in a dynamic table using ajax. i have created a javascript function as below:

<script type="text/javascript">
function showUser(str)
{
if (str=="")
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","try.php?q="+str,true);
xmlhttp.send();
}
</script>
function showUser is placed in the "<select name = 'Project' onchange = 'showUser(this.value)'>
my question is, is it possible that i display the data retrieved in the tables as hyperlinks?
I want the user to be able to view the informations of the displayed engagements in another php page.
the user can view the informations when they clicked on the hyperlinks of the engagement name that is displayed.

the sample of table can be seen in the attachment.
any idea on how to do this.
Let me know cause im stuck