PHP - 2 Separate Order By Dates

I've got.

For example if $names has a value of "Mark/Ben/James/Tom" how would I separate it to give each name its own variable, e.g $name1, $name2, $name3   Thanks,

What is the most secure way?

Having DB connect script in the beginning of every script you need db for,

or

Having a database.php script containing the script and then including it to all other php.

Hi all,

I'm currently working on a webpage that dynamically shows tables of sales for products. I'm using SQL to store 2 tables, one containing product info (name, price etc.) and one containing sales for each product.

One on of my web pages I want to show the product name and sales for a single year. This would involve ripping the product name from my product table and the sales and year from my sales table. Is this possible in one query?

$Query= "select name from productTable and sales, year from salesTable where year = $desiredyear;

Obviously I know this is wrong because it isn't working but am I even on the right lines?

Thank you.

Or is the ORM the only mapper?

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'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?

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.

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 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'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!";
      }

?>

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>

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

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.

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.