Learn VBA & Macros in 1 Week!

PHP - Recommened Method Of Embedding Php With Html

Full Excel VBA Course - Beginner to Expert

Recommened Method Of Embedding Php With Html	View Content

OK, I've seen this done both ways and want to know which (if any) is the most secure way to do it...

I've been coding my pages using echo statements to write HTML, such as:

<?php
echo "<p><strong>hello, World!</strong></p>";
echo "<p>You a $age year(s) old!</p> ";
...
?>

and so on...

but is this any better

<?php
<p><strong>Hello World!</strong></p>
echo "<p><strong>You are $age year(s) old!</p>";
?>

Is one of these methods better than the other (using ECHO to write actual HTML statements out rather than just embedding them in the script without ECHO)? Which is the recommended method?

Full Excel VBA Course - Beginner to Expert

Embedding Html Code Within Php - Performance Issue?

Similar Tutorials

View Content

Is there a performance or security issue when embedding HTML code to be written to a page using a series of ECHO statements within PHP?

Here's two examples:

<?php
// Some PHP code
echo "<p>Hello, World</p>\n";
// More php code
?>

versus:

<?php>
// Some PHP script commands
?>
<p>Hello World\n";
<?php
// More PHP code
?>

Is there a performance issue or potential security flaw that would make the first example any worse/better than the second?
(Is one method more "secure" than the other method, I guess is what I'm asking?)

I like the ease of just throwing in HTML within a PHP script without having toe escape quote marks, etc. But, I'm a bit concerned about security since whatever technique I use will be incorporated into a "commercial" production website.

Html & Html Entities - Correct Method?

Similar Tutorials

View Content

Hi Everybody.

I hope someone here can advise the correct method for storing html/text in a MySQL DB AND retrieving it for updating via a <textarea>

Basically, I need to store in my DB knowlege base articles, which have a title, category, product version/edition, description, solution, notes, etc... standard KB fields.. sorta...

The issue I am experiencing, or the trouble I am having, is when I need to store both formatting HTML and output HTML in the solution or notes fields, html special chars are being interpreted and the HTML that should be displayed is not there. The char codes are interpreted and the browser then "hides" the HTML tags.

For example, the solution may be this:

Code: [Select]
Find the following line:

<serverURL>URL</serverURL>

Change the URL to reflect your current server URL.

The html chars are interpreted and changed to the actual less than and greater than signs rather than their &...; form (ie: < > &nbsp etc.)

Some code snippets if it helps...

Creating a record:

Code: [Select]
...
$sol = addslashes($_POST['asol']);
$notes = addslashes($_POST['anotes']);
include('./conf/connect.php');
mysql_query("INSERT INTO `faq_kb`.`articles` (`id`, `solution`, `notes`, `updated`) VALUES (NULL, '$sol', '$notes', NULL) ") or die(mysql_error());
mysql_close($conn);
...

Retrieving a record:

Code: [Select]
...
include('./connect.php');
$get = $_GET['a'];
$sql = "SELECT * FROM articles WHERE id='$get'";
$result = mysql_query($sql);
mysql_close($conn);
while($row=mysql_fetch_array($result))
{
$solution = $row['solution'];
$notes = $row['notes'];
}
...
<h4>Solution:</h4>
<div align="right"><textarea name="rsol" style="width:550px;height:150px;">
<?php echo $solution; ?>
</textarea></div>
<h4>Notes:</h4>
<div align="right"><textarea name="rnotes" style="width:550px;height:150px;">
<?php echo $notes; ?>
</textarea></div>
...

Updating a record:

Code: [Select]
...
$aid = $_POST['id'];
$sol = addslashes($_POST['rsol']);
$notes = addslashes($_POST['rnotes']);
include('./conf/connect.php');
mysql_query("UPDATE `faq_kb`.`articles` SET solution='$sol', notes='$notes' WHERE id='$aid'") or die(mysql_error());
mysql_close($conn);
...

I guess, you can ignore my whole spiel above and simply answer this question:

what function do I need to use to encode the variable for inserting into the database, and what function do I then need to use to decode the variable for output so that it retains it's formatting html and my output/displayed html (< >)???

Thanks guys!

I hope that this makes sense...

------------------------
Further Example:

This is what is output (inside the dashes):
----------------------------
To configure your SysAid Server logging to debug mode please do the following.

Open the file serverConf.xml located in the directory:

[...\SysAidServer\root\WEB-INF\conf\]

Change
<sysaidLogLevel>info</sysaidLogLevel>
to
<sysaidLogLevel>debug</sysaidLogLevel>

Save the change and then restart the SysAid Server service.
--------------------------

And this is what the source of that looks like:
Code: [Select]
<div class="divText" id="txtselect"><p>
<span style="font-size: 10pt; font-family: 'Times New Roman',serif; color: black;" lang="EN-US">
To configure your SysAid Server logging to debug mode please do the following.</span></p>
<p><font size="2"><span style="font-family: 'Times New Roman',serif;">Open the
file </span></font>
<span style="font-size: 10pt; font-family: 'Times New Roman',serif; color: black; font-style: italic;" lang="EN-US">
serverConf.xml</span><span style="font-size: 10pt; font-family: 'Times New Roman',serif; color: black;" lang="EN-US">
located in the directory:</span></p>
<p><font size="2"><span style="font-family: 'Times New Roman',serif;">   
</span></font>
<span style="font-size: 10pt; font-family: 'Times New Roman',serif; color: black;" lang="EN-US">
[...\SysAidServer\root\WEB-INF\conf\] </span></p>
<p>

<span style="font-size: 10pt; font-family: 'Times New Roman',serif; color: black;" lang="EN-US">
Change <br>
    </span><font face="Courier New">
<span style="font-size: 10pt; color: black;" lang="EN-US">
<sysaidLogLevel>info</sysaidLogLevel><br>
</span></font>
<span style="font-size: 10pt; font-family: 'Times New Roman',serif; color: black;" lang="EN-US">
to<br>
    </span><font face="Courier New">
<span style="font-size: 10pt; color: black;" lang="EN-US">

<sysaidLogLevel>debug</sysaidLogLevel></span></font></p>
<p><span style="font-size: 10pt; color: black;" lang="EN-US">Save the change
and then restart the SysAid Server service.</span></p>
</div>

And this is a copy paste straight out of phpMyAdmin:
Code: [Select]
<p>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
To configure your SysAid Server logging to debug mode please do the following.</span></p>
<p><font size="2"><span style="font-family: 'Times New Roman',serif">Open the
file </span></font>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black; font-style: italic">
serverConf.xml</span><span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
located in the directory:</span></p>
<p><font size="2"><span style="font-family: 'Times New Roman',serif">
</span></font>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
[...\SysAidServer\root\WEB-INF\conf\] </span></p>
<p>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
Change <br>
    </span><font face="Courier New">
<span lang="EN-US" style="font-size: 10.0pt; color: black">
<sysaidLogLevel>info</sysaidLogLevel><br>
</span></font>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
to<br>
    </span><font face="Courier New">
<span lang="EN-US" style="font-size: 10.0pt; color: black">
<sysaidLogLevel>debug</sysaidLogLevel></span></font></p>
<p><span lang="EN-US" style="font-size: 10.0pt; color: black">Save the change
and then restart the SysAid Server service.</span></p>

Then EVEN CRAZIER, I click the edit button on the article and this is (direct copy paste) what is output to the <textarea>:
Code: [Select]
<p>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
To configure your SysAid Server logging to debug mode please do the following.</span></p>
<p><font size="2"><span style="font-family: 'Times New Roman',serif">Open the
file </span></font>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black; font-style: italic">
serverConf.xml</span><span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
located in the directory:</span></p>
<p><font size="2"><span style="font-family: 'Times New Roman',serif">
</span></font>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
[...\SysAidServer\root\WEB-INF\conf\] </span></p>
<p>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
Change <br>
</span><font face="Courier New">
<span lang="EN-US" style="font-size: 10.0pt; color: black">
<sysaidLogLevel>info</sysaidLogLevel><br>
</span></font>
<span lang="EN-US" style="font-size: 10.0pt; font-family: 'Times New Roman',serif; color: black">
to<br>
</span><font face="Courier New">
<span lang="EN-US" style="font-size: 10.0pt; color: black">
<sysaidLogLevel>debug</sysaidLogLevel></span></font></p>
<p><span lang="EN-US" style="font-size: 10.0pt; color: black">Save the change
and then restart the SysAid Server service.</span></p>
Notice how there are NO < or > chars in this?

How do I make this work

Thanks guys

Method Echo'ing Html Out Of Order

Similar Tutorials

View Content

Hi,

I have the following method but I can not work out why the html it echo's comes out in reverse?

Code: [Select]
public function pageNmLoop ($pageCnt, $pageStartListings, $filter) {
for ($n=1; $n<=$pageCnt; $n++){
if ($n > $this->recordLimit) {
break;
}

if ($n*$this->recordLimit>=intval($pageStartListings)){
$stylePg = '" style="border: 1px solid #aaaaaa; background-color: #CCCCCC; padding: 3px; ">' . $n . '</a>';
}
else {
$stylePg = '">' . $n . '</a>';
}

echo '| <a href="?pageStartListings=' . $n*$this->recordLimit . '&filter=' . rawurlencode($filter) . $stylePg ;

}
}

The HTML it produces is as follows:

Code: [Select]
Page:
<a href="?pageStartListings=0&filter=listingStatus=0">1</a>
|
<a style="border: 1px solid #aaaaaa; background-color: #CCCCCC; padding: 3px; " href="?pageStartListings=100&filter=listingStatus%3D0">1</a>
|
<a style="border: 1px solid #aaaaaa; background-color: #CCCCCC; padding: 3px; " href="?pageStartListings=200&filter=listingStatus%3D0">2</a>
|
<a style="border: 1px solid #aaaaaa; background-color: #CCCCCC; padding: 3px; " href="?pageStartListings=300&filter=listingStatus%3D0">3</a>

Probably some obvious newbie error but be grateful for a pointer.

Many thanks

Problem With Calling A Method From Within A Method In Another Class

Similar Tutorials

View Content

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

Embedding Images From Rss Into Php

Similar Tutorials

View Content

I'm trying to Embed the images from Apple into my PHP file.

Code: [Select]
$phpobj = unserialize($response);
if (is_array($phpobj))
{
foreach ($phpobj['value']['items'] AS $key => $val)
{
printf("<div><p><a href=%s>%s</a></p><p>%s</p>\n", $val['link'], $val['title'], $val['description']);
}
}
But the problem is that the image attribute is inside a Table and using something lile $val['img'] is not working. So anybody can help me with this.

Here is the RSS feed format from which I'm importing

Code: [Select]
<item>

<title>Dead Awake - Trailer</title>

<link>http://trailers.apple.com/trailers/independent/deadawake/</link>

<description>DEAD AWAKE is a seductive supernatural thriller starring Rose McGowan, Amy Smart and Nick Stahl set against the backdrop of a mysterious tragedy that shattered their lives a decade ago and which sets them on a path to uncover the truth that lies between the living and the dead.</description>

<pubDate>Wed, 01 Dec 2010 00:00:00 PST</pubDate>

<content:encoded><![CDATA[

<table>

<tr valign="top">

<td width="67"><a href="http://trailers.apple.com/trailers/independent/deadawake/"><img src="http://trailers.apple.com/trailers/independent/deadawake/images/poster.jpg" width="65" height="97" border="0"></a></td>

<td>   </td>

<td><a href="http://trailers.apple.com/trailers/independent/deadawake/"><span style="font-size: 16px; font-weight: 900; text-decoration: underline;">Dead Awake - Trailer</span></a><br />

<span style="font-size: 12px;">DEAD AWAKE is a seductive supernatural thriller starring Rose McGowan, Amy Smart and Nick Stahl set against the backdrop of a mysterious tragedy that shattered their lives a decade ago and which sets them on a path to uncover the truth that lies between the living and the dead.<br /><b>Directed by:</b> Omar Naim<br /><b>Starring:</b> Nick Stahl, Rose McGowan, Amy Smart, Ben Marten, Kim Grimaldi, Brian Lynner, Justin Marxen, James Serpento, Jack Mishler, Shane Simmons, Rachel Storey, Justin Urich, Andrea Leon, Livia Milano, Phyllis Mumford</span></td>

</tr>

</table>

]]></content:encoded>

</item>

Embedding Javascript In Php

Similar Tutorials

View Content

i want to change the content of my div tag dynamically using javascript in PHP. I am using the following technqiue but it is not working.
<?php
echo "<script type='text/javascript'>\n";
echo "document.getElementById('mydiv').innerHTML = 'contents of div.......';";
echo "</script>";

?>

please guide me how can i do this

Thanks,

Best Regards,
Nice Candy.

Embedding Ip Camera In A Website

Similar Tutorials

View Content

HI

I am trying to find solutions on how i am able to embed IP Screenshots into a website. Right now i am able to do so but only if i am connected to a certain internet network, then i would be able to see those IP Screenshots images. However if i am not connected to that network, the website are not able to show them.

THANKS ALOT!!

Embedding Webpages, Iframe Alternative?

Similar Tutorials

View Content

Hello.
I've asked around in many places now, and I thought I'd ask here too.
A few days ago I installed phpBB3 on my site, works like a charm.
I used a plugin for wordpress to integrate phpbb to wordpress, all works great.
Now my problem is to embed the forum to my wordblog page.
I tried using a simple iFrame solution, and it worked almost, but there's a common iFrame problem.
The height, it doesn't scale with the embedded page, instead it stays as a 100px high frame with a scroll bar.
I've searched google for hours now, and tried every possible javascript and css/div-tag solution I came across.
Nothing works.

Are there any alternatives to this?
I tried using
<?php include('../phpBB3/index.php') ?>
But I get errors.
It might be because I'm including from another directory, so it might be worth giving a try to give the direct path somehow, but how?

Anyway, are there any other solutions for this problem?

Help With Embedding Google Smtp Mail Function.

Similar Tutorials

View Content

Hello All,

I am strugling with embending standard smtp code within the one I have. As I am using PHP ocassionaly I have problem with this.

My code is to use mail function to send email through an form with email server installed on host system where the form and server are together.

I want this code to adapt to sth that can login to google account and use google external smtp protocol to send the content of the form defined in $headers

The problem is I am using self generated captcha that validates if the email is sent and all fields are filled (currently under tests what should be filled and not filled) and it works fine

This is my code that works on a local host server:

//Set up the email headers

    $headers    = "From: $from_sender <$from_email>\r\n";
    $headers .= "MIME-Version: 1.0\r\n";
    $headers   .= "Content-type: text/html; charset=iso-8859-1\r\n";
    $headers   .= "Message-ID: <".time().rand(1,1000)."@".$_SERVER['SERVER_NAME'].">". "\r\n";

    //Set up the email content

    $email_message = '<html><body>';
   $email_message .= '<table rules="all" style="border-color: #666;" cellpadding="10">';
    $email_message .= "<tr style='background: #eee;'><td><strong>Request</strong></td></tr>";
   $email_message .= "<tr style='background: #fff;'><td></td><td>" . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Requested By:</strong> </td><td>" . strip_tags($_POST['query']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Assigned To:</strong> </td><td>" . strip_tags($_POST['assigned']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Contact Email:</strong> </td><td>" . strip_tags($_POST['senderemail']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>New Part Number:</strong> </td><td>" . strip_tags($_POST['partno']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Item Description:</strong> </td><td>" . strip_tags($_POST['item']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Expected Annual Volume:</strong> </td><td>" . strip_tags($_POST['volume']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Supplier 1:</strong> </td><td>" . strip_tags($_POST['sup1']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Quotation Received:</strong> </td><td>" . strip_tags($_POST['rec1']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Supplier 2:</strong> </td><td>" . strip_tags($_POST['sup2']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Quotation Received:</strong> </td><td>" . strip_tags($_POST['rec2']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Supplier 3:</strong> </td><td>" . strip_tags($_POST['sup3']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Quotation Received:</strong> </td><td>" . strip_tags($_POST['rec3']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Supplier 4:</strong> </td><td>" . strip_tags($_POST['sup4']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Quotation Received:</strong> </td><td>" . strip_tags($_POST['rec4']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Email Subject:</strong> </td><td>" . strip_tags($_POST['subject']) . "</td></tr>";
   $email_message .= "<tr style='background: #eee;'><td><strong>Message:</strong> </td><td>" . strip_tags($_POST['message']) . "</td></tr>";
   $email_message .= "</body></html>";

    // Required Fileds Validation

   if($req_by == "")
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter your full name.</div>';
   }
   elseif($from_email == "")
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter your email address.</div>';
   }
   elseif(!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/", $from_email))
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter a valid email address.</div>';
   }
   elseif($email_subject == "")
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter the subject.</div>';
   }
   elseif($part_no == "")
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter the part number.</div>';
   }
   elseif($email_message == "")
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter your message.</div>';
   }
   elseif($security_code == "")
   {
       $submission_status = '<div class="vpb_info" align="left">Please enter the security code.</div>';
   }
   elseif(!isset($_SESSION['vpb_captcha_code']))
   {
       $submission_status = '<div class="vpb_info" align="left">Sorry, missing session. Please refresh and try again.</div>';
   }
   else
   {
       if(empty($_SESSION['vpb_captcha_code']) || strcasecmp($_SESSION['vpb_captcha_code'], $_POST['vpb_captcha_code']) != 0)
       {
           //Note: the captcha code is compared case insensitively. If you want case sensitive match, update the check above to strcmp()
           $submission_status = '<div class="info" align="left">Please enter the correct code.</div>';
       }
       else
       {
           $mailer = mail($to_mail, $email_subject, $email_message, $headers);

           if ($mailer)
           {
               //Displays the success message when email message is sent
                  $submission_status = "<div align='left' class='success'>The message has been sent successfully!</div>";
           }
           else
           {
               //Displays an error message when email sending fails
                  $submission_status = "<div align='left' class='info'>Sorry, your email could not be delievered. <br>Please try again or contact website admin.</div>";
           }
       }

   }
}
?>

And would like sth like this in place of $mailer , but my way is not working

The code I thought would be embeded into $mailer

$mail->isSMTP();
$mail->Host = 'smtp.googlemail.com'; //gmail SMTP server
$mail->SMTPAuth = true;
$mail->Username = 'GMAIL_USERNAME';   //username
$mail->Password = 'GMAIL_PASSWORD';   //password
$mail->SMTPSecure = 'ssl';
$mail->Port = 465;                    //SMTP port

Any idea how to adapt it to my code are welcomed and appreciated,

Thanks

Edited April 29, 2019 by slawotrend

Embedding A Youtube Video Within A Concatenated String

Similar Tutorials

View Content

I'm not sure if this is possible Previously I had a problem of outputting rows of a specific query This was the solution that was given to me

$txt .= $date . "&nbsp;" . $stratoparse . "\n\n";

Where a while loop's results were concatenated to a single string What I would like to do is output the results in individual containers with controls such as dragging for repositioning / an x for deletion That's not what I'm here for in this post I want to embed youtube videos, so they are not just stored as links, rather a clickable video so if you have something like string.string2.string3.string4.string5.<iframe src="youtube"...>.string7.string8 how would that video be isolated and parsed / understood as a front end youtube video ? To provide a brief background in case you are wondering why in my right mind, I would want to do this... First it is the primary solution that comes to mind going off what already works Secondly, the purpose or point of the concatenated string comes from the "application" design which is a store and recall interface. Vague, I know. The website has multiple users and they all have access to a single database. They save random strings, whether they are paragraphs or links, possibly videos that are uploaded, etc... these are saved by a keyphrase, later recalled by searching that keyphrase. Currently the output is nothing more than a concatenated string, that was fine initially but some of my friends have been testing the website and they made suggestions which are good such as repositioning and deleting entries. Now I want to automatically parse youtube links into embedded videos... I'll probably use that explode "function" to disect the link and place the url within the src=" " Anyway, I have to look into this but if anyone has any thoughts I'd appreciate it.
Edited by moose-en-a-gant, 11 January 2015 - 02:05 AM.

Get Method.

Similar Tutorials

View Content

here is what i am trying to do. i have a url in my browser like this: http://localhost/jmla/index.php?option=com_content&view=article&id=1295:sovereign-a-country-risk-workshop

as usuall we get elements form the url using the $_GET method, but here when i try to get id from the above url. i can get 1295:sovereign-a-country-risk-workshop. whereas the id is only 1295 and the other part is alias which i want to get seperately.

is there a way to do so?

How Can I Do This Method..

Similar Tutorials

View Content

Hi,

I have a problem and can't seem to figure out how to do it..

Basically i have these 2 tables:

Quote

People
Pid
Pname
Pdateadded
Pdeleted

And..

Quote

Quote:
PeopleCon
PCid
Pid
PCorder
Pdateadded
Pdeleted

Now, currently i insert the data into a table "People".. like you guys have helped me with..

But what i need to do is, first check to see if the author already exists in the People table, if so then just INSERT into PeopleCon, ELSE INSERT into both People and PeopleCon...

Also if there are 4 authors, and 2 exist in People, and 2 do not. What needs to happen is the first 2 are simply inserted into PeopleCon, but the last 2 are INSERTED into both People and PeopleCon. When the authors are inserted into PeopleCon, the PCorder row needs to increment by the number of authors byt order of author.

So this is the logic:

Multiple authors are entered in textboxes Fire the script Check to see if author already exists in "People" table IF it does exist, INSERT into PeopleCon table ELSE do the insert into the People AND PeopleCon table, first it will INSERT into the People, and GET the MAX (ID) and insert into the PeopleCon
So i currently have this, but as 3 separate methods:

class People {

    public function checkNameExists(){

       $query = "SELECT * FROM People WHERE Pname = '". mysql_real_escape_string($_POST['author'])."'";

        $result = mysql_query($query);
        if(mysql_num_rows($result) > 0):
            $row = mysql_fetch_array($result);
            return true;
        else:
            return false;
        endif;
    }

    public function insertAuthor(){
        $callback = create_function('$author','return "(\'".mysql_real_escape_string($author)."\',NOW(),0)";');
        $sql = sprintf(
            'INSERT INTO People (Pname, Pdateadded, Pdeleted) VALUES %s'
            ,implode(',',array_map($callback,$_POST['author']))
        );
        $result = mysql_query($sql);
        return "Successfully added NEW author";
    }

    public function insertAuthorCon(){

        $sql = "INSERT INTO PeopleCon
                    (Pid, PCorder, PCdateadded, PCdeleted) VALUES
                    (
                    'MAX ID WILL GO HERE',
                    'INCREMENT OF ORDER GOES HERE',
                    now(),
                    0
                    )";
        $result = mysql_query($sql);
        return "Successfully added existing author";
    }

But obviously i need to combine these together into one method to match what i am trying to achieve..

Can anyone point me in the right direction?

Thanks again...

Best Method For This

Similar Tutorials

View Content

Hi there,

I want to allow the ability for DJ's to turn on and off radio requests.

Now obviously I've encorporated a check box and submit button within a PHP login. But I was wanting to know if this can be done with PHP or is a database required as the option will need to be remembered for a period of time.

I'd probably look to do it by making it display on a page 'requests enabled' if enabled and a blank page if disabled. therefore I could encorporate:

<?php
if(!empty($requests))
{
//requests template
}
else
{
//radio requests disabled template
}
?>

What's the best method for this?

Thanks

Best Method

Similar Tutorials

View Content

I know I'm posting this inside the PHP coding board but I'm curious on how most handle this situation. I have a page that uses php to retrieve data from my database and I want to have it place a | in between each of the returned data which it does but it still places one after the last returned row. I'm wondering if I should do this with jquery load and then have it place that character in between each of the data or if there's a way to do it with php or what? Any ideas?

Code: [Select]
<?php require ("../header.php"); ?>

<div id="titlehistory" class="content">

<h1 class="pageheading">Title History</h1>

<?php
$titlesQuery ="
SELECT
    titles.titleName,
    titles.shortName
FROM
    titles
WHERE
    titles.statusID = 1
ORDER BY
    titles.ID";
$titlesResult = mysqli_query($dbc,$titlesQuery);

?>

<p><span class="minilinks">

<?php
        while ( $row = mysqli_fetch_array ( $titlesResult, MYSQLI_ASSOC ) ) {
            $fieldarray=array('titleName','shortName');
            foreach ($fieldarray as $fieldlabel) {
                ${$fieldlabel} = $row[$fieldlabel];
            }

            echo '<a href="/titlehistory/'.$shortName.'">'.$titleName.'</a>  |';
        }
        ?>
</span></p>

<p class="nohistory">Please select a title to view.</p>

</div>

<?php require ("../footer.php"); ?>

New To Oop - When Does A Method Get Set?

Similar Tutorials

View Content

I am trying to insert the current Date/Time into mysql database using the following code.

I do not understand how $submitDate & $submitTime are to be set.

Will this work as coded?

Code: [Select]

<?php

class SubmitDateRecord {

  const DB_TABLE = 'timesheet';
const DB_FIELD_SUBMIT_TIME = 'submit_time';

private $submitDate;
private $submitTime;

public function setSubmitDate($submitDate) {
    $this->submitDate = $submitDate;
}

public function getSubmitDate() {
    return $this->submitDate;
}

public function setSubmitTime($submitTime) {
    $this->submitTime = $submitTime;
}

public function getSubmitTime() {
    return $this->submitTime;
}

public function addRecord() {

    $insertTable = "`".self::DB_TABLE."`";

$insertFields[] = "`".self::DB_FIELD_SUBMIT_TIME."`";

$insertValues[] = "'{$this->submitDate} {$this->submitTime}'";


$sqlBuilder = new SQLQBuilder();
$query = $sqlBuilder->simpleInsert($insertTable, $insertValues, $insertFields);

$dbConnection = new DMLFunctions();
$result = $dbConnection->executeQuery($query);

if ($result) {
    return true;
} else {
    return false;
}

}

private function _buildRecordObjects($result) {

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

$submitdateObj = new SubmitDateRecord();

$submitdateObj->setAttendanceId($row['attendance_id']);
$submitdateObj->setEmployeeId($row['employee_id']);

/* $row['submit_time'] comes in '0000-00-00 00:00:00' format.
* We want date in '0000-00-00' format and time in '00:00' format.
*/
$tmpArr = explode(' ', $row['submit_time']);
$submitdateObj->setSubmitDate($tmpArr[0]);
$submitdateObj->setSubmitTime(substr($tmpArr[1], 0, 5)); // Omiting 'seconds' part is ok since it is always zero

$submitdateObj->setStatus($row['status']);

$submitdateArr[] = $submitdateObj;

}

return $submitdateArr;

}

}

Get Method

Similar Tutorials

View Content

Hi all,
What is the maximum size of data that we can pass through GET Method?
And can we increase its size ?

Best Method?

Similar Tutorials

View Content

The following query code works correctly, however, I'm trying to figure out which is best when working with themes, templates, content pages. My themes are my different versions of the main site designs. As of right now I have the following code plus the database structure.

site_themes - id, theme_name, status_id (only one theme can have a value of 1(active) at any given time)

site_templates - id, template_name, header_code, footer_code, status_id (any can have a value of 1(active) at any given time,

Code: [Select]
<?php

require("kowmanager/config/database.php");

$site_variables_query = "SELECT * FROM site_variables WHERE id = '1'";
$site_variables_result = mysqli_query($dbc, $site_variables_query);

$row = mysqli_fetch_array($site_variables_result, MYSQLI_ASSOC);

$site_theme_query = "SELECT * FROM site_themes WHERE status_id = '1'";
$site_theme_result = mysqli_query($dbc, $site_theme_query);

$row2 = mysqli_fetch_array($site_theme_result, MYSQLI_ASSOC);

if ($row['site_is_down'] == 'Yes') {

} else {
echo "site is up";
}

?>

Using The Get Method And Fb

Similar Tutorials

View Content

Hi There,

I am trying to implement a facebook plugin into my website. When the user posts a link to my site on their wall it will redirect them back to my page with some GET info in the URL eg. www.example.com/download.php?post_id=43221. I don't need to know the Post Id number, I just need to know if they went to the facebook page. So my question is, how would I make it s that if there is a Post ID number it displays the page and if not it directs them to another page?

Please help me with this, i'm totally stumped.

Thanks

George Bates

Foreach Method

Similar Tutorials

View Content

I have foreach method. This displays the choices that are selected and the value inside them as 1. The method is shown below. I am printing these with the name(choice1, choice2, choice3, choic4) and the value. If there is a value then it prints 1. Now my problem is I want to INSERT them into my database. if it prints choice1, choice2 then value 1 must be entered into choice1 and choice2 inside the database. I am not sure how to do this. can someone help me.
Code: [Select]
foreach ($_POST["choice"] as $question => $answer)
{

if($answer == NULL)
{
$val=0;
}
else{
$val = 1;
}

echo "choice id: $question. value: $val <br />";

Help With A Join, Or Perhaps Another Method.

Similar Tutorials

View Content

Hi All, hopefully someone can lend me some insight with a problem I'm stuck with.

What I have is two tables.

TABLE: investmentOfferings
   id:            Unique identifier
   class:         Class of offering (A, or AA)
   year:         Year of offering
   name:         Friendly name of offering
   units:         Amount of units added in this offering
   dollarPerUnit:   Dollar value of one unit in this offering
   warrant:      Boolean for warrant or no (0=no 1=yes)

TABLE: actualInvestments
   id:          Unique identifier
   investor:      Identifies investor by referencing investors>id
   dollarAmount:   Dollar amount invested in this offering
   class:      Identifies class by referencing investmentOfferings>id

The structure of the application is so. investmentOfferings creates 4 fundraisers. Each year a new one. The actualInvestments table is the investment contributed per offering. Essentially what I need to do is to create a report, per investor(investors have a third separate table) that shows the amount invested per offering. The kicker being: not every investor will invest every offering, but I still needs to show a 0 dollar amount. I understand that I could create separate 0 dollar investments for each investor, but that seems impractical. Especially where there will be more offerings once I'm finished working on this. In terms of the report, here's what I'm doing to output the data to a table.

Code: [Select]
<?php do {?>
<tr>
<td><?php echo $row_offerings['name']?></td>
<td><?php echo $row_offerings['dollarAmount'];?></td>
<?php while ($row_offerings = mysql_fetch_assoc($offerings)); ?>
This creates a new column in the table for each part of my array. The issue I think is in my query.
Code: [Select]
"SELECT * FROM actualinvestments AS a RIGHT JOIN investmentofferings AS i ON i.id=a.offering WHERE class='AA' AND investor=" . $investorID . " OR investor IS NULL"Ive tried variations on this, but cannot seem to find anything that will produce currently entered investments, and placeholders for offerings with no investments. Could anyone steer me in the right direction? Any help would be greatly appreciated.