Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.
<?php // load up the db connection require_once('connect.php'); //connect to the DB mysql_select_db($database_conn, $conn); $group_name = 'MS520A'; $query = " SELECT customer_accounts.nac, customer_accounts.salutation, customer_accounts.fullname, customer_accounts.address_line_1, customer_accounts.address_line_2, customer_accounts.address_line_3, customer_accounts.address_line_4, customer_accounts.address_line_5, customer_accounts.postcode FROM customer_accounts WHERE customer_accounts.group_name = '". $group_name ."' "; $customeraccounts = mysql_query($query) or die("Bad Query: " . mysql_error()); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>JM Select</title> </head> <body> <h1>Customer Orders</h1> <?php while ($customer = mysql_fetch_array($customeraccounts, MYSQL_ASSOC)): ?> <?php echo $customer['nac'],",",$customer['salutation'],",",$customer['fullname'],",",$customer['address_line_1'],",",$customer['address_line_2'],",",$customer['address_line_3'],",",$customer['address_line_4'],",",$customer['address_line_5'],",",$customer['postcode']?>,<br /> <?php $nac = $customer['nac']; $queryorder = " SELECT DISTINCT order_number, total_cost, order_date FROM purchase_history WHERE nac = '". $nac ."' ORDER BY order_date "; $customerorders = mysql_query($queryorder) or die("Bad Query: " . mysql_error()); ?> <?php while ($order = mysql_fetch_array($customerorders, MYSQL_ASSOC)): ?> <?php echo $order['order_number'],",",$order['total_cost'],",",$order['order_date']?>,<br /> <?php endwhile ?> <?php endwhile ?> </body> </html>
|is a prepared statement still safe from Sql injection if not using ?||3||22|
|CSS question related to hyperlinks||9||23|
|How to represnt 52 selections||1||24|
|PHP strip quotes and line feeds out of array||13||26|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
17 Experts available now in Live!