PHP - Separate Variable

I am currently trying to make a line graph out of data using php and javascript. How do I add up the values of a column and separate them by month. For example the database has 74 amount of rows. Then the values from the "views" column get added up and then displayed by month.

Code: [Select]
   <table width="70%" class="linechart">
     <thead>
       <tr>
         <td></td>
         <th scope="col">Jan</th>
         <th scope="col">Feb</th>
         <th scope="col">Mar</th>
         <th scope="col">Apr</th>
         <th scope="col">May</th>
         <th scope="col">Jun</th>
         </tr>
       </thead>
     
     <tbody>
       <tr>
         <th scope="row">Post Views</th>
         <td>24324</td>
         <td>29634</td>
         <td>15435</td>
         <td>56545</td>
         <td>23543</td>
         <td>2123</td>
         </tr>
         
       </tbody>
   </table>

ok i think and hope this will be my last issue with this site.

i have two forms on the same contact page, but right now theyre using the same error label. this means if ONE has an error, both forms show as that same error.  id like to somehow separate this and give each one its own label.
i tried doing like error[2] for the 2nd button instead of error[] but then i didnt know what to change the actual "error label" to. do i changed the "$errors = array();" part? to create a second label? i tried to google on it and couldnt figure it out.  thanks a million to anyone who even reads

<?php
if (isset($errors)) {

foreach ($errors as $error) {

echo("<p>$error<p>\n");

}
}
?>

so my question basically is, how do i use this code below to create a second error case AND label please!!

<?php
if ($_POST['send']) {

$errors = array();

if ($_POST['captcha'] != $_SESSION['captchacode']) {

$errors[] = "You didn't enter the correct letters!";
}



+
<?php
if (isset($errors)) {

foreach ($errors as $error) {

echo("<p>$error<p>\n");

}
}
?>

I've been cracking at this for the part of 2 days now, and I cannot get my regex to work properly in my script.

/^[A-Za-z][\w\-',.]*(?<![^A-Za-z][\w\-\'\,\.])$/i

The above is for a last name field, and it needs to be able to accept: Roberts, Jr. (as an example)...

As you can see in my regex, I am allowing all of these characters.. And it's still not validating it.

You can test to see what I mean he

<?php 

$last_name = "Roberts, Jr.";

 if (!preg_match("/^[A-Za-z][\w\-',.]*(?<![^A-Za-z][\w\-\'\,\.])$/i", $last_name )) {
          echo "Sorry no dice!";
      }

?>

trying to create an array that is separating brackets, semi-colon and space from "mydata" and iterating over to create first and last name's separated into two subs... and then loop those through. so i'd like either change the way i can explode and loop the information... or place the first and second subs and skip the third sub in the array.


                $str = $_POST["mydata"];
                $mores = explode("[];",$str);
                foreach ($mores as $more)
                        {
                        $datas = explode(" ",$more);
                                if (array_values ($datas) === $datas)

$xmlBody .= "      <member name='$datas[1], $datas[0]' display='$datas[0] $datas[1]'>Name</member>";

}



can someone please assist? much appreciated.

I am trying to split some strings up by commas with preg_split but I keep on getting the error: "No ending delimiter ',' found"

Here is my Code:
$links = preg_split(',', $links);
$titles = preg_split(',', $titles);
$images = preg_split(',', $images);

Thanks,
Alex

I don't have any PHP skills at all. In fact I'm probably looking for a script that can help accomplish what I'm asking about. Regardless, I'm having a hard time getting any answers or solutions to this.

I would like to make a web form that collects cc#'s from my customers that is PCI Compliant in as simple a manner as possible. 99% of the time my clients are not being charged at all, and the cc is used simply to ensure a service is confirmed. If they were to be charged, I would have to do that manually as no payment gateways currently deposit into banks in the country I am in.

One thought I had would be if I could have the cc# either split, or broken up into separate fields and emailed separately. I am told this is PCI Compliant. I would also be fine with the cc# being split between database and email. I know this is possible w/ zen cart, but I have been unable to find any scripts that do this and don't have a need for a shopping cart addition to my site. But, I am aware that zen cart and other shopping cart add ons have options for X's to cover a bunch of numbers in the middle of the string and write that directly to the database.

One thing that is a necessity is that the majority of the data input to the form be emailed. So, I'm basically hoping to protect the cc data in the simplest way possible, which I thought would be to break it up. I'll be trashing the cc #'s once I get them. I have no need to file them.

I do have a SSL on my server.

I am completely open to other suggestions. Is something like this, or another option a possibility?

My skills are rudimentary. I taught myself to write some html and also use Dreamweaver to subsidize for what I can't code myself. I apologize if this should be in one of the other forums.

I've got a table (tbl_items) that holds a number of items and the individual information for each. Within 'tbl_items' I also have a row labeled 'category_id' in which each item is given a number (ex: 2).

I've got a separate table (tbl_items_categories) that only has 2 rows: 'category_id' and 'category_name'.

I wasn't sure if a JOIN method would be best for this but what would be the best approach to list all items and within each item, also echo out the name of the category they belong to and not the category_id number?

$poststart = "<!-- Begin -->"; $poststop = "<!-- End -->";   $parsedpost1 = explode($poststart, $contenu); $parsedpost2 = explode($poststop, $parsedpost1[1]); $contenu = $parsedpost1[0] . $poststart . $newpost . $poststop . $parsedpost2[1];   The above code will set 2 markers and replace whatever inside by $newpost, which is defined elsewhere in the page. But what if $newpost is so long that I'd be more comfortable storing it in a separate file?    How would I go about calling said file on that last line? (I'm referring to the specific syntax.)   Thx

I have a list generated from an array by foreach as
 
Code: [Select]
foreach ($list_array as $item) {
echo "$item<br />";
}
This is a long list, how can I separate the list to different pages? I mean the simplest way to do so

First, here's some code:

Code: [Select]
$result = mysql_query("SELECT standard FROM thestandards WHERE id={$theSearch}", $connection);
if (!$result) {
     die("Database connection failed: " . mysql_error());
}

while ($row = mysql_fetch_array($result)) {
     $query = $row[0];
}

// echo $testing = nl2br($query);

$subStrings = explode('\n', $query);

echo $subStrings[0] . "<br />";   // outputs entire query
echo $subStrings[1] . "<br />";   // undefined offset
echo $subStrings[2] . "<br />";   // undefined offset
echo $subStrings[3] . "<br />";   // undefined offset   
So, the data I'm retrieving from the database is several small paragraphs.  I want to take these paragraphs, separate them, and put them into an array.  I tried using the explode function with the newline char, but for some reason it doesn't work.  I can get it to work if I want to go explicitly add "\n"s in the database everywhere, but that just doesn't seem practical.  nl2br doesn't work for what I need, but I find it interesting that this function is somehow able to "see" all the newlines in the query, whereas the explode function cannot.  Explode is really what I need, but I've tried '\n', '\r', '\r\n' and nothing works.  Thanks for the help.

Hi all

What is the best way to work with times that are stored without there date but with only one date field regarding both times?

Thanks

Hey guys,

I need your help on this please.

I am working on a php web application. I have a form that gets information for Supplier and his traveling details.

The values are stored in arrays. I would like to store supplier details in Supplier table and the travelling details in the Travel table.

Here is the code with the comments.

<?php
    if (isset($_VARS['submitSuppliers']))
    {
        //error checking starts here
        $isError = false;
        if (empty($_VARS['supplierName']))
        {
            $isError = true;
            $_VARS['supplierRequest']['supplierName']['errorMessage'] = 'You need to provide a Supplier Name.';
        }

        if (empty($_VARS['address']))
        {
            $isError = true;
            $_VARS['supplierRequest']['address']['errorMessage'] = 'You need to provide an Address.';
        }
        if (empty($_VARS['travel']))
        {
            $isError = true;
            $_VARS['supplierRequest']['city']['errorMessage'] = 'You need to provide travelling details.';
        }

        #this checks if there is no error and then proceeds to save form values
        if (!$isError)
        {
            #This function adds the details and Returns the autoincremented Supplier ID
            $SupId = add_suppliers($_VARS); 
            if ($SupId)
            {
                #=== Now here I would like to save the travelling details in the Travel table  using the generated supplier id
                # $travId = add_Travel($_VARS); //==== how do I segregate only travel details from the $_VARS array to store in travel table?
                REDIRECT('/supplier/index.html', array('confirmationMessage' => 'Your details have been saved.'));
            }else
            {
                notify_admin('supplierjoin.php');
            }
        }else
        {
            $_VARS['supplierRequest']['errorMessage'] = "There was a problem with the information you provided. Please check the form and try again.";
        }
    }

?>


Kindly help.

Any comment or feedback is always welcome.

Thank you

Hi, I'm new to the forum so this could go in the MySQL section but I'm not sure.

I am trying to make a page that will list all records from a column in HTML table and have a delete button to remove a specific record. I have got to the part where I have listed the records in a table.
Note: Only records from a specific column ('links') are printed.

Here is the code:
Code: [Select]
$con = mysql_connect("localhost","***","***");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("***", $con);

$result = mysql_query("SELECT * FROM main");

echo "<table border='1'>
<tr>
<th>Current links</th>
</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['links'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
How would I go about adding a delete button next to each record to delete that specific record?

Thanks for any help.

This topic has been moved to PHP Applications.

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

How to do it? I have read some methods but they seem to not work. This is what  I have got so far:     <?php