PHP - Php - Return Results In Html Editable Region.

Hi there,

 

I am trying to wrap some content in a div, but when I render it, it is outputting the actual HTML.

This is the line I have:

add_filter( 'woocommerce_product_description_heading', 'rename_product_description_heading', 10, 1 );
function rename_product_description_heading( $heading ) {
    return  __( '<div class="myclass">Additional Information</div>', 'woocommerce' );
}

 

which is outputting:

<div class="myclass">Additional Information</div>

rather than wrapping it in the div.

 

Can anyone help me with wrapping the "Additional Information" text in a div?

Thank you :)

hey guys   Doing last bit of site now and after doing full testing I found 1 little bug that I don't like

I created an appointment section with a table to display resuilts from mysql, works great, but add more than 1 appiontment and its almost adding a whole new page

See attachment for pic

Heres the code for the table

<?php  echo '<h2>Customer Appointments</h2>'; ?>
</span></div><table width="1248" border="3" align="center">
  <tr class="new">
           <td width="116" class="re" style="text-align: center"><strong>Date Booked</strong></td>
           <td width="96" class="re" style="text-align: center"><strong class="table">Time Booked</strong></td>
           <td width="823" class="re" style="text-align: center"><strong class="table">Notes</strong></td>
  </tr>
         <?php do { ?>
           <tr class="table">
             <td class="re" style="text-align: center; color: #FFF;"><?php echo $row['datebooked']; ?></td>
             <td class="re" style="text-align: center"><?php echo $row['timebooked']; ?></td>
             <td class="re" style="text-align: center"><?php echo $row['notes']; ?></td>
  </tr>
           <?php } while ($row = mysql_fetch_assoc($Recordset1)); ?>
</table>
          <span class="re">
          <?php

Is there anyway I can make the Titles: Date Booked, Time Booked, Notes and have all results showing directly underneath? Attached Files  success.JPG   31.29KB   0 downloads

Not too familiar with sessions but I was curious to get others' input on this situation. I want to have users visit my site and be confronted with selecting their region, which will filter out the content they see.

What type of sessions lifetime should I be working with here? I was thinking of keeping the session registered for as long as they stay on the site and maybe an hour afterwards just incase they visit again.

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to Miscellaneous.

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

I am trying to create a order history page.

I want it to look something like this:

Ordernumber:  12
Products:
               Product 1
               Product 2
               Product 3
               Product 4
Total:      xx

Ordernumber:  13
Products: 
               Product 5
               Product 6
Total:      xx

and so on.

I have a recordset which get the ordernumbers from my database
and i have another recordset which get the products (this recordset has a WHERE clause which is used to get the products associated with its ordernumber.

Code: [Select]
    mysql_select_db($database_lol, $lol);
    $query_ono = "SELECT DISTINCT ordre.ono FROM ordre WHERE ordre.bruker='{$_SESSION['MM_Username']}'";
    $ono = mysql_query($query_ono, $lol) or die(mysql_error());
    $row_ono = mysql_fetch_assoc($ono);
    $totalRows_ono = mysql_num_rows($ono);
   
    mysql_select_db($database_lol, $lol);
    $query_history = "SELECT ordre.vare FROM ordre WHERE ordre.ono='{$row_ono['ono']}'";
    $history = mysql_query($query_history, $lol) or die(mysql_error());
    $row_history = mysql_fetch_assoc($history);
    $totalRows_history = mysql_num_rows($history);

This is the recordsets.

this is my table:

+-------+---------------------+------+
| ID      | vare                   | ono  |
+-------+---------------------+------+
|       1 | Product 1           |   12 |
|       2 | Product 2           |   12 |
|       3 | Product 3           |   12 |
|       4 | Product 4           |   12 |
|       5 | Product 5           |   13 |
|       6 | Product 6           |   13 |
+-------+---------------------+------+


So my question is: How do i do this? list all the records i mean.
Thanks

Hello.  I am interested in taking a result returned from a database and having it displayed in a certain way/style on the user's screen; For example, the user enters text into a field and hits "submit" - the data is saved in the database then displayed to the user (This part I have working just fine so far due to help I received here.)

My question is if I would like to, for example, have said text not simply dumped to the top of the screen, inline, but nicely formatted in a boxed, text area, I assume I will use HTML/CSS, and I was wondering if anyone had any good links/tutorials regarding this topic so I may look further into it (my search thus far has not turned up the correct topic or results).

Thank-you in advance for any assistance.
~Matty

I was wondering how does one go about showing results from SELECT query in columns in a html table.

I have a list of products in a table, and would like to show them on the page in 4 columns. I have done many searches on google to try and find the sulution, but the majority of what im finding instead is about displaying a table from phpmyadmin as a table in html.

If its a large operation to do this, I would be very happy if someone could poiint me in the direction of a tutorial maybe.

Here is the code I have so far to display the products, but for some reason, it only show 1 row instead of all the rows from my table.

Code: [Select]
<?php

$dbhost = "localhost";
$dbuser = "user";
$dbpass = "pass";
$dbname = "dbname";

mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());

$result = mysql_query("SELECT * FROM mcproducts");
while($row = mysql_fetch_array($result))
 {
  $products_local_id = $row['products_local_id'];
  $productname = $row['product_name'];
  $thumburl = $row['image_from_url'];
  $productlink = $row['product_local_url'];
  $thumbnail = $row['product_image_small'];
  $currencysymbol = $row['product_currency'];
  $price = $row['product_price'];
  $flagicon = $row['product_country_from'];

 }

?>
<html>
<head>
<link href="style/stylesheet.css" rel="stylesheet" type="text/css" />
</head>
<body>

<div class="displaybox">
                <div class="productimage">
                <a href="<?php echo $productlink; ?><?php echo $products_local_id; ?>"><img src="<?php echo $thumburl; ?><?php echo $thumbnail ?>" width="150" height="150"></a>
                </div>
                <div class="productdescription">
                  <div class="pro_name">
      <a href="<?php echo $productlink ?><?php echo $products_local_id; ?>"><?php echo $productname; ?></a>
                  </div>
                  <div class="pro_description">
                  </div>
                  <?php
                  if ($flagicon=="Ireland") {
  $flagicon = "<img src=\"flags/ireland.jpg\">";
  }
  
  elseif ($flagicon=="UK") {
  $flagicon = "<img src=\"flags/uk.jpg\">";
  }  else
  echo "";
  ?>
                  <div class="pro_description"><?php echo $flagicon; ?><?php echo $currencysymbol ?> <?php echo $price ?></div>
                </div>
              </div>
             
</body>
</html>


Many thanks,

DB

This sounds like overkill, but is there any way I can take the results of an html form, and plug them into their respective cells on a excel spreadsheet?

Thanks in advance!

-Brad

Hi

I am sure this is very simple but it's got me beat!

I have a page that sends emails to people with their account details. I can get it to work fine with straight plain text but would like it in HTML and I can't get the username and password details into the body of the email. I'm sure it's just a formatting issue but I've tried many things and it fails!!

Any suggestions very welcome. The code is below.

Many thanks in advance.

<?php
// MAIL TO AP
require_once '../phpmailer/class.phpmailer.php';

$mail                = new PHPMailer();

if(isset($_GET['idcode'])){
  $idcodepassed = $_GET['idcode'];
}else{
  $idcodepassed = 111111; // set this to your default value if no URL value is present
}


mysql_select_db($database_process, $process);
$result = mysql_query("SELECT  applicantid, idcode, type, company, email, CONCAT('pdf_document_',idcode) AS linkname, length, username, password, DATE_FORMAT(applicationdate,'%D %M %Y') AS formattedDate, parties
                    FROM applicant
                    WHERE idcode = '$idcodepassed'
                    LIMIT 1
                    ");

while($row = mysql_fetch_array($result))
  {
    $appid = $row['applicantid'];
    $idcode = $row['idcode'];
    $type = $row['type'];
    $company = $row['company'];
    $email = $row['email'];
   $term = $row['length'];
   $username = $row['username'];
   $password = $row['password'];
   $appdate = $row['formattedDate'];
   $parties = $row['parties'];   
  }
 
 

// $body                = file_get_contents('EmailTextAP.php');
// $body                = eregi_replace("[\]",'',$body);

$body = '<html><p>This email TO AP is confirmation of your appointment of Clear Appointments as your agent for service of process under the agreement between $parties.  Our appointment starts on $appdate and you have appointed us for $term years from this date. We have attached our letter of confirmation to this email for your records.</p>
<p>You can log into your account on our website (<a href=\"http://www.clearappointments.co.uk\">www.clearappointments.co.uk</a>) at any time to review your documents and change your contact details. Your user name is:???  and your password is ???.</p>
<p>We appreciate your custom and hope that you will use us again.</p>
<p>Kind regards</p>
<p>Clear Appointments Team<br />

';

  $mail->SetFrom('confirmation@clearappointments.co.uk', 'Clear Appointments');
  $mail->AddReplyTo('confirmation@clearappointments.co.uk', 'Clear Appointments');
// set the subject of the email
$mail->Subject       = "Process Agent Letter of Confirmation Attached";

@MYSQL_CONNECT("localhost","lawwork1_graham","733576");
@mysql_select_db("lawwork1_process");
$query  = "SELECT company, email FROM applicant WHERE idcode='$idcodepassed'";
$result = @MYSQL_QUERY($query);


// sets name and location of attachment
$directory = '../docs/';
 $docname = 'Confirmation_Letter_'. $idcodepassed . '.pdf';
 $invname = 'Invoice_' . $idcodepassed . '.pdf';
 $send=$directory.$docname;
 $sendinvoice=$directory.$invname;
 
while ($row = mysql_fetch_array ($result)) {
  $mail->AltBody    = "To view the message, please use an HTML compatible email viewer!"; // optional, comment out and test
  $mail->MsgHTML($body);
  $mail->AddAddress($row["email"]);
//  $mail->AddAddress($row["instemail"]);

      // attachment
    // $mail->AddAttachment($send);
    // $mail->AddAttachment($sendinvoice);
  $mail->AddAttachment($send);      // attachment
//  $mail->AddAttachment($sendinvoice); // attachment

  if(!$mail->Send()) {
    echo "Mailer Error (" . str_replace("@", "&#64;", $row["email"]) . ') ' . $mail->ErrorInfo . '<br>';
  } else {
    echo "";
//       echo "Message sent to :" . $row["full_name"] . ' (' . str_replace("@", "&#64;", $row["email"]) . ')<br>';
  }  // Clear all addresses and attachments for next loop
  $mail->ClearAddresses();
  $mail->ClearAttachments();
}

?>

Hi,
I am trying to create a system where the user can just edit the page online. I have tried to do this using the <!-- EDITABLE --> tag.

My system logs in fine and displays the pages that can be edited, however when I click on the page to edit it it doesn't provide the editable region in a text area to be able to change it which it should do.

This is the section of code that should make the user able to change the text:

if ($_SESSION['username']=='login') {
   if (isset($_REQUEST['file'])) {
       $fc = file_get_contents($_REQUEST['file']);
       $text = explode("<!-- EDITABLE -->",$fc);
       echo "<form method='post' action=''><textarea name='content'>$text[1]</textarea>";
       echo "<p><input type='hidden' name='file' value='".$_REQUEST['file']."' /><input name='submitUpdate' type='submit' value='Update Page'></form>";
   }
   else {
      echo "<p align='center'>
       <a href='index.html'>Home Page</a><br/>
       <a href='contact_us.html'>Contact Us</a><br/>
       <br/>
       <em>Click on the links above to edit the files.</em><br/>
      <a href='logout'>logout</a></p>";
   }
}

The section of code that can be edited in each file is coded like this:

<div class='main'>
            <!-- EDITABLE -->
            Contents written here can be edited
             <!-- EDITABLE -->
        </div>

Anybody got any ideas as its giving me no error messages and I can't see whats wrong with the code.

Thanks in advance

I am querying a database and trying to display the names of categories in a drop-down menu.  My problem is that the names are not visible.

I have the following code:

   $result = mysql_query('SELECT name FROM category') or die(mysql_error());
   echo('Choose a category');
   echo('<select name="category">');
   echo('<option value="general" >general</option>');
   while($row = mysql_fetch_array($result)){
      echo('<option style="color:black;" value = "'.$row['name'].'">'.$row['name'].'</option>');
   }
   echo('</select><br /><br />');

The query is good and executing the query retrieves the expected number of results.  My dropdown box is the proper length and width (showing that it is trying to print the names); however, nothing is displayed.  Any ideas?

Hi, 

When the user creates a contact, then edits the contact that final edited information is shown in a file called "my data.txt". After this, when I select my php file "save_contact_details.php" the details stored in the text file  "my data.txt" are not retrieved. How can I retrieve them? At the moment the issue I'm having is that I see no data when I click on  "save_contact_details.php" after I filled in all the contact persons information. 

Feel free to watch this video I recorded to help you understand what I am talking about. https://streamable.com/rbw6p

save_contact_details.php code

   <html>
       <body>
          <?php
             $myFile=fopen("mydata.txt","r") or exit("Can’t open file!");
             // Write each line of text into the text file file
                 fwrite($myFile, $_POST["lastname"]."\r\n");
                 fwrite($myFile, $_POST["firstname"]."\r\n");
                 fwrite($myFile, $_POST["address01"]."\r\n");
                 fwrite($myFile, $_POST["address02"]."\r\n");
                 fwrite($myFile, $_POST["town"]."\r\n");
                 fwrite($myFile, $_POST["postcode"]."\r\n");
                 fwrite($myFile, $_POST["telephone"]."\r\n");
                 fwrite($myFile, $_POST["email"]."\r\n");
                 fclose($myFile);
             ?>
          <h1>My Contact Details</h1>
          <p>The contact details that you have submitted are shown below:</p>
          <table>
             <tr>
                <td align="right">Last name: </td>
                <td><?php echo $_POST["lastname"]; ?></td>
             </tr>
             <tr>
                <td align="right">First name: </td>
                <td><?php echo $_POST["firstname"]; ?></td>
             </tr>
             <tr>
                <td align="right">Address 01: </td>
                <td><?php echo $_POST["address01"]; ?></td>
             </tr>
             <tr>
                <td align="right">Address 02: </td>
                <td><?php echo $_POST["address02"]; ?></td>
             </tr>
             <tr>
                <td align="right">Town / city: </td>
                <td><?php echo $_POST["town"]; ?></td>
             </tr>
             <tr>
                <td align="right">Post code: </td>
                <td><?php echo $_POST["postcode"]; ?></td>
             </tr>
             <tr>
                <td align="right">Telephone: </td>
                <td><?php echo $_POST["telephone"]; ?></td>
             </tr>
             <tr>
                <td align="right">E-mail: </td>
                <td><?php echo $_POST["email"]; ?></td>
             </tr>
          </table>
       </body>
    </html>

edit_contact_details.php code

    <html>
        <body>
            <?php
            $myFile=fopen("mydata.txt","r") or exit("Can’t open file!");
            // read each line of text from the text file
            $lastname = fgets($myFile);
            $firstname = fgets($myFile);
            $address01 = fgets($myFile);
            $address02 = fgets($myFile);
            $town = fgets($myFile);
            $postcode = fgets($myFile);
            $telephone = fgets($myFile);
            $email = fgets($myFile);
            fclose($myFile);
    ?>
    <h1>My Contact Details</h1>
      <p>
        The contact details on file are as shown below.<br>
        Edit the data and save your changes to file.
      </p>
      <form action="save_contact_details.php" method="post">
      <table>
        <tr>
          <td align="right">Last name: </td><td>
          <?php echo "<input size=\"20\" type=\"text\" name=\"lastname\" value=\"$lastname\">"?>
          </td>
        </tr>
        <tr>
          <td align="right">First name: </td><td>
          <?php echo "<input size=\"20\" type=\"text\" name=\"firstname\" value=\"$firstname\">"?>
        </tr>
        <tr>
          <td align="right">Address 01: </td><td>
          <?php echo "<input size=\"30\" type=\"text\" name=\"address01\" value=\"$address01\">"?>
        </td>
        </tr>
        <tr>
          <td align="right">Address 02: </td><td>
                    <?php echo "<input size=\"30\" type=\"text\" name=\"address02\" value=\"$address02\">"?>
          </td>
        </tr>
        <tr>
          <td align="right">Town / city: </td><td>
          <?php echo "<input size=\"20\" type=\"text\" name=\"town\" value=\"$town\">"?>
        </td>
        </tr>

        <tr>
          <td align="right">Post code: </td><td>
          <?php echo "<input size=\"10\" type=\"text\" name=\"postcode\" value=\"$postcode\">"?>
        </td>
        </tr>
        <tr>
          <td align="right">Telephone: </td><td>
          <?php echo "<input size=\"15\" type=\"text\" name=\"telephone\" value=\"$telephone\">"?>
          </td>
        </tr>
        <tr>
          <td align="right">E-mail: </td><td>
          <?php echo "<input size=\"50\" type=\"text\" name=\"email\" value=\"$email\">"?>
          </td>
        </tr>
        <tr>
          <td> </td>
          <td colspan="2" align="left"><input type="submit" value="Save Changes"></td>
        </tr>
      </table>
      </form>
      </body>
    </html>

create contact html code

    <html>
    <body>
    <h1>The contact details</h1>
    <p>Please enter your contact details:</p>
    <form action="save_contact_details.php" method="post">
      <table>
        <tr>
          <td align="right">First name: </td>
          <td><input size="20" type="text"  maxlength="15" name="firstname"></td>
        </tr>
         <tr>
          <td align="right">Last name: </td>
          <td><input size="20" type="text"  maxlength="15" name="lastname"></td>
        </tr>
        <tr>
          <td align="right">Address line 1: </td>
          <td><input size="30" type="text"  maxlength="50" name="address01"></td>
    </tr>
     <tr>
          <td align="right">Address line 2: </td>
          <td><input size="30" type="text"  maxlength="50" name="address02"></td>
        </tr>
        <tr>
          <td align="right">Town / city: </td>
          <td><input size="20" type="text"  maxlength="20" name="town"></td>
        </tr>
        <tr>
          <td align="right">Post code: </td>
          <td><input size="10" type="text"  maxlength="10" name="postcode"></td>
        </tr>
        <tr>
          <td align="right">Telephone: </td>
          <td><input size="15" type="text" size="20" maxlength="15" name="telephone"></td>
        </tr>
        <tr>
          <td align="right">E-mail: </td>
          <td><input size="50" type="text"  maxlength="50" name="email"></td>
        </tr>
        <tr>
          <td> </td>
          <td colspan="2" align="left"><input type="submit" value="Submit"></td>
        </tr>
      </table>
    </form>
    </body>
    </html>

 

I have the following code that searches my database and displays results in a table:

$fields = array("field1", "field2", "field3")
$cols   = implode (', ', $fields); 

$result= mysql_query 
(" SELECT $cols FROM tablename  WHERE ................... ");

if (!$result) {die('Could not search database: ' . mysql_error());}

if($result)
{   
    
    if(mysql_num_rows($result) == 0)
    {
        return "Sorry. No records found in the database";                       
    }
    else 
    {
        $table = "<table border='1' cellpadding='5' cellspacing='5'>";
        while($arr = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            $table .= "\t\t<tr>\n";
            foreach ($arr as $val_col) 
            {
                $table .= "\t\t\t".'<td>'.$val_col.'</td>'."\n";
            }
            $table .= "\t\t</tr>\n";  
        }
        $table .= "</table>";
        echo $table;
    }
    mysql_free_result($result);       
}

As you can see each of the MySQL table fields specified by $fields is displayed in a new column in the html table.
I want to change this so that e.g. "field3" is displayed in a new row instead.

So, instead of the html table looking like:

| "field1-result1" | "field2-result1" | "field3-result1" |
| "field1-result2" | "field2-result2" | "field3-result2" |
| "field1-result3" | "field2-result3" | "field3-result3" |

I want it to look like:

| "field1-result1" | "field2-result1" | 
| "field3-result1" |                          |
| "field1-result2" | "field2-result2" |
| "field3-result2" |                          |
| "field1-result3" | "field2-result3" |
| "field3-result3" |                          |

I guess this is quite straightforward, but I can't work it out! Pls help!

Thanks.

Hello   I am using fpdf to generate pdf files based on certain csv files. Now the client wants certain fields of the generated pdf file to be 'interactive' . Is this possible ? Googling about editable (interactive pdf's) only confused me . any help ?    btw by interactive I mean fields that can be typed into directly by the client and then saved into the pdf .