PHP - Preg_match() Regex For First Name And Last Name In Separate Fields

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?

here is my code
$query = "SELECT * from links ORDER BY field_4 DESC";  // assumes that your date column is a DATE data type so that ordering by it will sort the dates
$result = mysql_query($query);

// check if the query executed without error and if it returned any rows here...

// retrieve and process the data from the query
$last_date = ''; // initialize to a value that will never exist as data
while($row = mysql_fetch_assoc($result)){
    // test for a new date and output the date heading
if($last_date != $row['field_4']){
        echo "<p><font face='Arial, Helvetica, sans-serif'>";
echo $row['field_4'] . "<br />";
echo "</font></p>";
        $last_date = $row['field_4']; // remember the new date
    }

    // output the data (under each date heading)
    echo "<img src=" . $row['field_1'] . " border=0>";
echo "<a href='" . $row['field_3'] . "'>";
echo $row['field_2'] . "</a><br />";
}
mysql_close($con);

i would like set the data under each heading to be ordered by a different column, how do i do so?

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?

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

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

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");

}
}
?>

Im trying to match this string, but i dont wat to match normal words like "hello world 646"

Code: [Select]
$string = "2ab055843241f20044af82ae0d5ace04"; //always over 15 chars - without spaces

if ( preg_match('~^[0-9\s]+$~D', $string)) {
echo 'yes';
}
If i can do it with preg_match that would be great

Hey guys,

In my contact form i have the action: preg_match but i've come accross a problem.

Problem: Warning: preg_match() [function.preg-match]: No ending delimiter '^' found in C:\Program Files (x86)\wamp\www\ts\contact.php on line 34

Code:$error_message = "";
$email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$";
  if(!preg_match($email_exp,$email_from)) {
   $error_message .= 'The Email Address you entered does not appear to be valid.<br />';


Thanks in advance

I've tried alot of different ways, google, but just can't find the correct way to do this.. I'm trying to search for a word in an inputted string.. here's the code

<html>
    <head><title>TESTING</title></head>
    
    <body>
        <form method="GET" action="<?php echo $_SERVER['PHP_SELF']; ?>"/>
        email: <input type=text name=email value="" /><br/>
        feedback: <input type=text name=ex value=""/><br/>
        <input type="submit" value="submit" /><br/>
    </body>
</html>

<?php
$email = $_GET['email'];
$ex = $_GET['ex'];
$pattern = '/^[a-zA-Z0-9\-\.]+@[a-zA-Z0-9\-]+\.[a-zA-Z]+$/';
//$pattern1 = '/nprezident/prezident/';

if(!preg_match($pattern, $email)){
    echo 'invalid email address<br/>';
} else { echo 'good to go<br/>'; }

if(preg_match('/nprezident/,/prezident/', $ex)){
    echo 'just something about that sentence is nice';
} else { echo 'no good'; }
?>


Ok the one I'm having a problem with is the second preg_match when trying to search for two words i can get one word to print but when i use add a second word it gives an error.
How do i add a second word? 

I'm pretty new to this, How exactly could i get the text between the www. and .com?

so if i have a url:

http://www.facebook.com

I want to just return  "facebook"

information.txt
<li><img src="http://www.lol.com" alt="0" /></li>
<li><img src="http://www.lol.com" alt="1" /></li>
<li><img src="http://www.lol.com" alt="4" /></li>
<li><img src="http://www.lol.com" alt="9" /></li>
<li><img src="http://www.lol.com" alt="1" /></li>
<li><img src="http://www.lol.com" alt="7" /></li>
<li><img src="http://www.lol.com" alt="2" /></li>

How can I get the alt="$ValueIwant" for each with a preg_match

Why dosent this work, im trying to match upper case, lower case and numbers only

Code: [Select]
$id = '3xDJ7@#';

if (!preg_match('/^[a-zA-Z0-9]/', $id)){
echo "ERROR!";
}else{
echo 'ok';
}

This always echos "ok"