PHP - Simple For Loop Issue

Im trying to search through the read column and see if any of the rows are read
I echo $mail and it shows all the rows for the user. So im grabing the ones I want but now i dont know how to search through what I selected. Or is there a simplier way of having SQL do what im trying to do?

Code: [Select]
<?php   
    $query = "SELECT `read` FROM pm WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; 
$results = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_assoc($results)) {   
    
$mail = $row['read'];
}
// checks if user has unread mail or not
if ($mail == "unread") {    
    
    
    echo '<td><b><a href="inbox.php?inbox=1">Messages</a></b></td><td id="diamond">&diams;</td>';
    
} else {     
    
    echo '<td><a href="inbox.php?inbox=1">Messages</a></td>';
    
}    

?>

The first run of my for loop does not execute, but all after that works. I know I need to define my $strings before the for loop because they do not take effect until it has ran once and that is why it does not show the first run. But I don't completely understand how to solve the issue, and have tried everything to my knowledge.

The code below imports a steam group page xml and gets the unique ids for each of the groups members, then retrieves information about members.

<?php

$groupxml = simplexml_load_file('http://steamcommunity.com/groups/MDK-Society/memberslistxml/?xml=1');
$members = $groupxml->memberCount;
$array = $groupxml->members->steamID64;

for($arraycount="0"; $arraycount<$members; $arraycount=$arraycount+1){
$xml = simplexml_load_file("http://steamcommunity.com/profiles/$array[$arraycount]/?xml=1");
echo "<a href=\"#\" title=\"<img src=$xml->avatarMedium align=right /> $xml->steamID<br />$xml->stateMessage<br /><br />Location: $xml->location<br />$xml->summary\"><img src=\"$xml->avatarMedium\" /></a>";
echo "<br>";

if ("$xml->onlineState" == "online") {
echo "<img src=\"images/stateonlinemaster.png\" />";
}
elseif ("$xml->onlineState" == "offline") {
echo "<img src=\"images/stateofflinemaster.png\" />";
}
else
{
echo "<img src=\"images/stateingamemaster.png\" />";
}
echo "<br>"; 
echo "<br>"; 
}

?>

Could you explain to me fully where I went wrong in the for loop. Thanks

I'm starting to get peeved with PHP today, after many hours of trying to sort an issue - I'm sure you all know what I mean.

Once again, the issue lies with foreach loops which I have never been able to fully understand, especially when dealing with multiple arrays.

The code is for a CMS, where a restaurant owner can update his menu's and choose whether to show them on the website using a tick box.

Here's a screenshot..



Essentially, the issue I am having is should I click say, the bottom tickbox and click Update it will for some reason, tick the second in the database.... In reverse, if all are ticked, and I untick the bottom, it will untick the box before it.... it is sooo frustrating..

From what I can see, it is likely to be where the array, where ticked boxes have a value, and non-ticked ones don't... but I tried to sort this in my foreach loop setting an empty value to off....

Here is the HTML code:

Code: [Select]
<form action="./includes/scripts/menus/update.php" enctype="multipart/form-data" method="post">

<button type="submit" onclick="return confirm('Updating Menu Changes...\n\nUpdating PDF files may time some time.. \n\nDo not navigate away from this page until you recieve a success or failure confirmation.\n\nClick Cancel to make changes.'); { return alert('noob'); }">Update Menu Changes</button>
<button type="button" onClick="document.location.href='./includes/scripts/menus/new_row.php'">Add New Menu Item...</button>

<br /><br />

<table border="0" width="962" cellpadding="0" cellspacing="0">

    <tr style="padding-bottom: 3px;">   
        <th style="text-align: center;" width="195.4">Active</th>
        <th style="text-align: center;" width="195.4">Menu</th>
        <th style="text-align: center;" width="195.4">Current Menu</th>
        <th style="text-align: center;" width="195.4">Change Menu (PDF format only)</th>
        <th style="text-align: text-align: center;" width="195.4">Tasks</th>
    </tr>
   
    <?
   
    $query = "SELECT * FROM menus ORDER by id ASC";
    $query = mysql_query($query) or die(mysql_error());
   
    //Count rows
    $num_rows = mysql_num_rows($query);
   
    //If no rows exist
    if($num_rows=="0") { ?>
       
        <tr style="padding-bottom: 3px;">           
            <td colspan="4" style="text-align: center;">There are currently no menus listed in the Pen Mill Hotel database.</td>       
        </tr>
       
    <? }
   
    //If new rows exist
    elseif($num_rows!=="0") {
       
                $i = "0";
   
    while($row=mysql_fetch_array($query)) {
   
        //Database Variables
        $name = $row["menu"];
        $id = $row["id"];   
        $location = $row["location"];
       
        //Establish if a menu is present in database for current entry
        if(empty($location)) {
            $current = "<a style=\"cursor: pointer;\" onclick=\"alert('No menu found!');\" title=\"View Listed Menu\">View Current Menu</a>";
        }
       
        elseif(!empty($location)) {
            $current = "../includes/menus/" . $row["location"];
            $current = "<a href=\"$current\" title=\"View Listed Menu\" />View Current Menu</a>";
        }
       
        //Establish whether to check tickbox or not.
        $active = $row["active"];
            if($active=="on") { $active = " checked=\"checked\" "; }
            elseif($active!=="on") { $active = " "; }
       
    ?>
   
    <tr style="padding-bottom: 3px;" id="<? echo "$id"; ?>">
   
        <td style="text-align: center;">
                <input type="checkbox"<? echo "$active"; ?>name="active[<? echo "$i"; ?>]" /> 
        </td>
       
        <td style="text-align: center;">
            <input type="text" style="padding: 0px;" name="name[]" value="<? echo "$name"; ?>" />
        </td>
       
        <td style="text-align: center;">
            <? echo $current; ?>
        </td>
       
        <!-- Tell PHP, max file size is equal to 5MB (in bytes) -->
        <input type="hidden" name="MAX_FILE_SIZE" value="5242880" />
       
        <td style="text-align: center;"><input type="file" name="menu_file[]" /></td>
       
        <td style="text-align: center;">
            <a href="./includes/scripts/menus/delete.php?id=<? echo "$id"; ?>"
            onclick="return confirm('Are you sure you wish to delete this menu?\n ');">
                Delete
            </a>
         </td>
 
    </tr>
   
    <input type="hidden" name="id[]" value="<? echo $id; ?>" />
   
    <? $i++; ?>

<? } } ?>
   
</table>

<br />

<button type="submit" onclick="return confirm('Updating Menu Changes...\n\nUpdating PDF files may time some time.. \n\nDo not navigate away from this page until you recieve a success or failure confirmation.\n\nClick Cancel to make changes.');">Update Menu Changes</button>
<button type="button" onClick="document.location.href='./includes/scripts/menus/new_row.php'">Add New Menu Item...</button>

</form>
And here is the PHP, baring in mind it will also deal with a file upload, but that isn't the issue at the moment...
Code: [Select]
<?

/*

This script is for use on the Manage Menu's pages and updates all menu items.

*/

/*==================================*/
/* DATE BASE CONFIGURATION            */
/*==================================*/

include_once "../../config/config.php";

/*==================================*/
/* SET VARIABLES                    */
/*==================================*/

$id = $_POST["id"];
$active = $_POST["active"];
$name = $_POST["name"];
$menu_file = $_FILES['menu_file'];
$i = "0";

/*==================================*/
/* Loop Each Menu & Update             */
/*==================================*/

foreach($id as $key) {
   
    //Set Sub Variables
    if(empty($active["$i"])) { $active["$i"] = "off"; }
    $active_post = $active["$i"];
    $name_loop = $name["$i"];
   
    //Set File Variables
    $file_name = $menu_file["name"]["$i"]; //name of file on users machine
    $file_type = $menu_file["type"]["$i"]; //type of file being uploaded
    $file_size = $menu_file["size"]["$i"]; //size of the uploaded file in bytes
    $file_error = $menu_file["error"]["$i"]; //returned PHP error codes for upload
    $file_temp = $menu_file["tmp_name"]["$i"]; //temporary name on server
   
    //Handle Uploaded File (if uploaded)
    if(!empty($file_name)) {
       
        //FILE ERROR CHECKS
        //If file type is not PDF.
        if($file_type!=="application/pdf") {
   
            $pass = "0";
            header("Location: ../../../index.php?page=Menus&error=Incorrect_File_Type");
           
        }
       
        //If file type is greater than 5MB.
        if($file_size>"5242880") {
   
            $pass = "0";
            header("Location: ../../../index.php?page=Menus&error=Incorrect_File_Size");
           
        }
       
        //If above error checks pass
        if($pass!="0") {
           
            //Get todays date for file rename
            $today = date("d-m-Y");
            $uploaddir = "/home/penmillh/en/includes/menus/";
            $upload_name = str_replace(" ", "", $name_loop) . $today . ".pdf";
            $uploadfile = $uploaddir . $upload_name;
           
            //Move file only if PHP upload status is correct
            if($file_error!="UPLOAD_ERR_OK") {
           
                header("Location: ../../../index.php?page=Menus&error=File_Upload_Error");
               
            }
           
            //If PHP status is okay, upload file and update table.
            if($file_error=="UPLOAD_ERR_OK") {
           
                //Upload
                move_uploaded_file($file_tmp, $uploadfile);
               
                //Update Database
                $query = "UPDATE menus SET active='$active', menu='$name_loop', location='$upload_name' WHERE id='$value'";
                $query = mysql_query($query) or die(mysql_error());
               
                header("Location: ../../../index.php?page=Menus&error=File_Upload_Success");
               
            }   
           
        }
       
    }
   
    //If no uploaded file, update database records
    if(empty($file_name)) {
             
        //Update Database       
        $query = "UPDATE menus SET active='$active_post' WHERE id='$key'";
        $query = mysql_query($query) or die(mysql_error());
       
//        header("Location: ../../../index.php?page=Menus&error=Menu_Change_Success");
             
    }
   
    $i++;

}


?>
Now, I have probably made this INCREDIBLY complicated, but that's all I could remember from my previous experience with foreach loops....

Any ideas?

Hey guys,

I am using php loop to echo out all off the data in my database category within a html table. However I would like to reduce each table row to only 5 results then start a new row so that the table fits within the webpage.  Any suggestions?  Any help is much appreciated.  Thanks.

Jason

Here is what i am using, but does not fit within the page.

Code: [Select]
<table cellspacing="10">
<tr>
<?php
$query = mysql_query('SELECT photo_id, photo_name FROM gallery_photos WHERE photo_category = "Books" AND photo_approved = 1 ORDER BY rand()');

while ($row = mysql_fetch_array($query))

{

echo "<td><a href='http://www.mysite.com/view.php?pid=".$row['photo_id']."'><img src='photos/".$row['photo_id'].".jpg' width='115' height='115' /><center><h3><b>".$row['photo_name']."</b></h3></center></a></td>";
}
?>
</tr>
</table>

Hello,
I have a page where the user uploads a CSV file and I want to read that CSV and update database fields accordingly.  It seems I have all the code correct but only the first row of the CSV is being imported.

If I echo my variables within the loop, the only output is the first row of the CSV - no subsequent rows.  I feel like I'm close but not sure what the issue is?  Thanks a million for any help!!

Jason


//START FILE OPERATION
$handle = fopen('uploads/testfile.csv', "r");

//LOOP CONTENTS OF CSV FILE
while (($data = fgetcsv($handle, 1000, ",")) !== false)
{
$importID = $data[0];
$companyName = $data[1];
$primaryPhone = $data[2];
$primaryEmail = $data[3];
$billingFirstName = $data[4];
$billingLastName = $data[5];

$query = 'SELECT importID FROM import';
if (!$result = mysql_query($query))
{
continue;
}

if ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
//UPDATE IF ENTRY EXISTS
$query = "UPDATE import SET companyName='$companyName', primaryPhone='$primaryPhone', primaryEmail='$primaryEmail', billingFirstName='$billingFirstName' WHERE importID=$importID";
mysql_query($query);

if (mysql_affected_rows() <= 0)
{
//NO RECORDS UPDATED
}
}
else
{
//ENTRY DOESN'T EXIST
}

mysql_free_result($result);
}

//CLOSE FILE OPERATION
fclose($handle);

Hi all. How do I loop the below script?

   $query_basket = mysql_query("SELECT * FROM `store_basket` WHERE sessionid='".$sessionid."'");
        $rows = mysql_num_rows($query_basket);
      $r = mysql_fetch_array($query_basket);
      $allitems = $rows;
        while($result_basket = mysql_fetch_array($query_basket)) {
         
         
      $price_without_tax = $result_basket['price'];
        $tax = 17.5;
        $price_with_tax = $result_basket['price'] + $tax;
        $price_times_qty = $result_basket['price'] * $result_basket['qty'];
      $basket_item = $result_basket['item'];
      $basket_qty = $result_basket['qty'];
      $basket_initial1 = $result_basket['initial1'];
      $basket_initial2 = $result_basket['initial2'];
      $basket_initial3 = $result_basket['initial3'];

}

if($allitems == 1) {
$basket .= $allitems.":".$basket_item."   ".strtoupper($basket_initial1)."-".strtoupper($basket_initial2)."-".strtoupper($basket_initial3).":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;
} else {
$allitems = $rows;

$basket .= ":".$basket_item."   ".strtoupper($basket_initial1)."-".strtoupper($basket_initial2)."-".strtoupper($basket_initial3).":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;

    }

Basically if there is more than one row I need to loop the $basket string so that it shows the values for each item.

Thanks
Pete

Let me explain my problem. I have an array with dates and numbers in format ($cronograma)

Ex:

Array ( [2020-09-21] => Array ( [0] => 2020-09-21 [1] => 2 [2] => 2 [3] => 2 ) [2020-09-28] => Array ( [0] => 2020-09-28 [1] => 2 [2] => 2 [3] => 4 )

Then i have another array with 2 ids (in this case 58,60) ($id)

Finally i have a third array with numbers only (in this case 34,34) $tot

So what i want is cross information beween them, for example for id 58 I must get dates (first element and last element when $tot = 34) for id 60 I must get dates (first element after $tot =34 and last element of array)

Whath i have so far is this

foreach ($id as $idPlan) { foreach ($cronograma as $c) { $t1 = 0; foreach ($tot as $d) { $t1 += (int)$d['tempos']; if ($c[3] == $t1) { $newAr[] =$idPlan; $newAr[] = $c[0]; } } } }

My response

array(8) { [0]=> string(2) "58" [1]=> string(10) "2021-02-01" [2]=> string(2) "58" [3]=> string(10) "2021-06-14" [4]=> string(2) "60" [5]=> string(10) "2021-02-01" [6]=> string(2) "60" [7]=> string(10) "2021-06-14" } null

So it's clear that i have all repeated

I should have a line like:

58 - 2020-09-21 -2021-02-01

Any help?

Hey there folks,

Im trying to get a foreach loop working correctly from a json source epg heres my code:

https://pastebin.com/FjHj1EF6

Here is the current output, which.. while correct is only the first instance of these values i wanted using the foreach loop, i would love any tips on why my approach failed and to be pointed in the right direction.

While it has to be included:

$url = "https://mywebsite.fake/mlb.php?id={$arr['games'][0]["gamePk"]}";

this value isn't related to the assistance im asking for. that will work for my purposes later. but for now i just need to understand the issue with the foreach loop.

Thanks in advance for your thoughtful response.

mosb3rgler

can anybody tell me what's wrong with my query ?


$filesa = "SELECT id, uid, size, filehash, filename, dwnloads, swidth, sheight, fores, flabel, vpre FROM pf_fmusic WHERE (aid='$albumid' AND vpre='complete') ORDER BY id DESC";


I am using this in while loop with ps_pagination class but getting 2 records for same set of files. in other words its running while loop 2 time complete code is here...


       $filesa = "SELECT id, uid, size, filehash, filename, dwnloads, swidth, sheight, fores, flabel FROM ibwf_fmusic WHERE (aid='$albumid' AND vpre='complete') ORDER BY id DESC";
$pager = new PS_Pagination($conn, $filesa, 9, 5, $albumid, $sortid, $sub, $selectalbum3[uid], $title, $collective);
$results = $pager->paginate();
  while($files=mysql_fetch_array($results))
  {
// Blah Blah
}


Output is something like this

1. song 1
2. song 2
3. song 3
4. song 4
1. song 1
2. song 2
3. song 3
4. song 4

 Thanks is advance

Hello,

I don't have any php knowledge and am having a hard time trying to implement the following:

- a drupal node is getting a numeric parameter with the URL in the following form "http://the.url/?X=123"
- what I want is for the script to check if the value has been passed with the URL, then use it in a form... if the entered URL was "http://the.url" without the X variable, then use a default value of 321.

<?php $_GET['X']; if (isset($X)) { print $X ; } else print "321" ?>

Thanks in advance for your help.

Hi, I'm trying to make an error message appear when a user misses a text field, or fills in an error. All the errors are sent to a form.php, this then sends the error message back to the current page. Here is the code I am using to retrieve the error message:

if($form->error = ("user")){
echo $form->error("user");
}
if($form->error = ("pass")){
echo $form->error("pass");
}

Which works fine, but I only want ONE error message to be displayed at a time. This IS what I want:

There are two fields, user, and password. If the user fails to enter anything into both, only one error message will appear "Please enter your username" (which is what the form.php does).

When the user fills in the username, but fails to fill in the password then it works, only one error message appears (as there is only one error to send)

When the user fills in the password, but fails to fill in the username it also works, only one error message appears. Its just when the user fails to fill in either, it prints both error messages when I only want it to print the 'user' error message.

Please help, Thanks

I have this simple piece of code.
I am using GET[] to retrieve the catID from URL, then match it and set a backgorund image, some backgorund images can change per catID variable. When selected or clicked on.

It is not working, it is producing the catId in ech $_Get[], but not matching it with $filename to set correct Image.

Ex. Browser catID may == 1, it code displays catid = 1, file name = deals_2.jpg.
 This is worng. should be catid = 1 , filename  = 1.

PLEASE HELP,  missing something.
Code: [Select]
<?php
  $imgpath = '/shushmedeals/templates/shushme_deals/images/';
  //$bgimgID = $item->id;

  $bgimgID = isset($_GET['categoryId']);
  $bgimgID = $_GET['categoryId'];
  echo $bgimgID;
  //echo 'shoot her eman';
  //echo  $imgpath;

  if($bgimgID){
   $bgimgID = 1;
$filename = '/shushmedeals/templates/shushme_deals/images/bg_home.jpg';
  } 
  if($bgimgID = 2){
   $filename = '/shushmedeals/templates/shushme_deals/images/shushme_bg_img1.jpg';
  }
  if($bgimgID = 3){
    $filename = '/shushmedeals/templates/shushme_deals/images/shushme_bg_img2.jpg';
  } else {
    $filename = '/shushmedeals/templates/shushme_deals/images/shushme_bg_img3.jpg';
  }       
  if($filename){ 
  
   echo '<br>'.$filename; 
   // SET COOKIE 
   //setcookie('bgimg',  $filename);
   //echo $_COOKIE['bgimg'];
  
  } else { 
   echo "There is no Background for this category"; 
   // DO NOT SET COOKIE 
  } 


  // Print an individual cookie
  echo $_COOKIE["location"];
  
  ?>

I cant figure out why im having this problem.
i stuck this at the top of my page on its own and it wont update the row to read

Code: [Select]
<?php
mysql_query("UPDATE pm SET read= 'read' WHERE pm_id = '".mysql_real_escape_string($_GET['pm_id'])."'");
?>
I echo $_GET['pm_id']; and that turn out correct and the number matches the pm_id on the row.
everything is lowercase
I typed read manually into the column and echo that and it showed read
also I have this same exact line of code on another script that works fine.

does someone see something im over looking? this is driving me crazy


http://localhost/stargate/users/view.php?pm_id=1376672&inbox=2

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

<html>
<body>
 

<?php
mysql_query("UPDATE pm SET read= 'read' WHERE pm_id = '".mysql_real_escape_string($_GET['pm_id'])."'");

?>



</body>
</html>

Error...
Parse error: syntax error, unexpected T_ELSE in /home/smileits/public_html/space/webmin/install.php on line 15


Code...

Code: [Select]
<?if ($_GET['a'] == "") {?><br><br><div align="center"><h2>Welcome to aWebBB</h2><br><br>After editing the configuration file located at /forum/config.php and created a database named 'awebbb_forum' (or different) please click <a href="install.php?a=install">here</a> to install.<br></div><?} else { }if ($_GET['a'] == "install") {echo "Installing MYSQL Tables...<br>";include "../config.php";$db = mysql_connect($db_host,$db_user,$db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query = 'CREATE TABLE `fcat` (  `id` int(11) NOT NULL auto_increment,  `category` varchar(50) default NULL,  `description` varchar(250) default NULL,  PRIMARY KEY  (`id`))';$result = mysql_query($query); echo "Created Categories Table<br>";$query2 = 'CREATE TABLE `flist` (  `id` int(11) NOT NULL auto_increment,  `tid` varchar(50) default NULL,  `categories` varchar(30) default NULL,  `tname` varchar(100) default NULL,  `poster` varchar(50) default NULL,  `date` date default NULL,  PRIMARY KEY  (`id`))';$result2 = mysql_query($query2); echo "Created Thread List Table<br>";$query4 = 'CREATE TABLE `forum` (  `id` int(11) NOT NULL auto_increment,  `tid` varchar(50) default NULL,  `categories` varchar(30) default NULL,  `tname` varchar(100) default NULL,  `poster` varchar(30) default NULL,  `fpost` text,  `sig` varchar(150) default NULL,  `avatar` varchar(150) default NULL,  `time` time default NULL,  `date` date default NULL,  PRIMARY KEY  (`id`))';$result4 = mysql_query($query4); echo "Created Main Fourm Table<br>";$query5 = 'CREATE TABLE `prefs` (  `id` int(11) NOT NULL auto_increment,  `sitename` varchar(99) default NULL,  `forumname` varchar(99) default NULL,  `sitetitle` varchar(99) default NULL,  `menulink` varchar(11) default NULL,  `normallink` varchar(11) default NULL,  `defimage` varchar(150) default NULL,  `defsig` varchar(150) default NULL,  `backcolor` varchar(20) default NULL,  `msitecolor` varchar(20) default NULL,  `siteurl` varchar(150) default NULL,  `headimage` varchar(150) default NULL,  `hiwidth` varchar(4) default NULL,  `hiheight` varchar(4) default NULL,
  `forumcolor` varchar(11) default NULL,  `normaltext` varchar(11) default NULL,  `copyright` varchar(150) default NULL,  `email` varchar(100) default NULL,  `adenable` varchar(11) default NULL,
  `adcode` text,
  `adlocation` varchar(20) default NULL,
  PRIMARY KEY  (`id`))';$result5 = mysql_query($query5); $query7 = "INSERT INTO `prefs` VALUES (1, 'Site Name', 'Forum Name', 'Title of your site', 'white', 'blue', 'images/world.jpg', 'Love Life', 'white', 'blue', '', 'images/logo1.jpg', '700', '80', 'white', 'black','','','','','');"; mysql_query($query7); echo "Created Preferences Table<br>";$query6 = 'CREATE TABLE `users` (  `id` int(11) NOT NULL auto_increment,  `level` char(2) default NULL,  `username` varchar(20) default NULL,  `password` varchar(20) default NULL,  `emailadd` varchar(50) default NULL,  `fullname` varchar(40) default NULL,  `country` varchar(30) default NULL,  `date` date default NULL,  `sig` varchar(150) default NULL,  `avatar` varchar(150) default NULL,  PRIMARY KEY  (`id`))';$result6 = mysql_query($query6); echo "Created Users Table<br>";

$query7 = 'CREATE TABLE `menu` (
  `id` int(11) NOT NULL auto_increment,
  `bname` varchar(50) default NULL,
  `link` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
)';
$result7 = mysql_query($query7); echo "Created Menu Table<br>";echo '<meta http-equiv="refresh" content="1;url=install.php?a=users">'; } else { }if ($_GET['a'] == "users") {?>Please Create the Administrative User Account:<br><br><style type="text/css"><!--div.error-box {width:200px; background:pink; margin-top: 2px; border: 1px solid red; text-align: center;}//--></style><?$a=$_GET['b'];if ($a == "skyreg" ) {$fullname=$_POST['fullname'];$username=strtolower($_POST['username']);
$password1=$_POST['password1'];$password2=$_POST['password2'];$emailadd=$_POST['emailadd'];$country=$_POST['country'];if ($fullname == "") {$fullnamebox="<div class=\"error-box\">";$fullnamebox1="</div>";} else { }if ($username == "") {$usernamebox="<div class=\"error-box\">";$usernamebox1="</div>";} else { }if ($password1 == "") {$pword1box="<div class=\"error-box\">";$pword1box1="</div>";} else { }if ($password2 == "") {$pword2box="<div class=\"error-box\">";$pword2box1="</div>";} else { }if ($emailadd == "") {$emailaddbox="<div class=\"error-box\">";$emailaddbox1="</div>";} else { }if ($country == "") {$countrybox="<div class=\"error-box\">";$countrybox1="</div>";} else { }if ($fullname == "" OR $username == "" OR $password1 == "" OR $password2 == "" OR $emailadd == "" OR $country == "") {$errormessage="<font color=\"red\">Please Fill in all Feilds.</font><br>";} else { include "../config.php";$db12 = mysql_connect($db_host,$db_user,$db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query12 = "SELECT username FROM users WHERE username = '$_POST[username]'"; $result12 = mysql_query($query12); while($r=mysql_fetch_array($result12)) { $username12=$r["username"]; }if ($username12 == $username) {$errormessage3="<font color=\"red\">The username chosen is in use, choose another.</font>";} else { if ($password1 == $password2) {$fullname=$_POST['fullname'];$username=strtolower($_POST['username']);
$password=$_POST['password1'];$emailadd=$_POST['emailadd'];$schoolyear=$_POST['schoolyear'];$country=$_POST['country'];$defsig1=$_POST['defsig'];$defimage1=$_POST['defimage'];include "../config.php"; // As you can see we connected to the database with config$db = mysql_connect($db_host, $db_user, $db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query = "INSERT INTO users(level, username, password, emailadd, fullname, country, date, sig, avatar) VALUES('1', '$username','$password','$emailadd','$fullname', '$country', now(), '$defsig1', '$defimage1')"; mysql_query($query); echo "Account Created";echo '<meta http-equiv="refresh" content="1;url=install.php?a=done">'; mysql_close($db); } else {$errormessage2="<font color=\"red\">Passwords Entered do not Match.</font>";}}mysql_close($db12);}} else { }if ($a != "skyreg" OR $a != "reg") { ?><div align="center"><?=$errormessage;?><?=$errormessage2;?><?=$errormessage3;?><br><form method="post" action="install.php?a=users&b=skyreg"><input type="hidden" name="defimage"><input type="hidden" name="defsig"><?=$fullnamebox;?>Full Name:<br><input type="text" name="fullname"><br>&nbsp;<?=$fullnamebox1;?><?=$usernamebox;?>Username:<br><input type="text" name="username"><br>&nbsp;<?=$usernamebox1;?><?=$pword1box;?>Password:<br><input type="password" name="password1"><br>&nbsp;<?=$pword1box1;?><?=$pword2box;?>Retype Password:<br><input type="password" name="password2"><br>&nbsp;<?=$pword2box1;?><?=$emailaddbox;?>E-mail Address:<br><input type="text" name="emailadd"><br>&nbsp;<?=$emailaddbox1;?><?=$countrybox;?>Country:<br><input type="text" name="country"><br>&nbsp;<?=$countrybox1;?><input type="reset" value="Clear Form"> <input type="submit" value="Register"></form></div><? } else {  }} else { }if ($_GET['a'] == "done") {?><div align="center"><br><br>All done!!!<br><br>Please procede to the <a href="index.php">Admin section</a> and Edit the <a href="pref_edit.php">site preferences</a>.<br><br><font color="red"><h2>Remember to delete install.php AND upgrade.php for security reasons!!!</h2></font></div><?} else { }?>

Hi All,

I have a simple 'delete record' code that is not working. Would someone please take a gander at it and let me know if they see anything wrong that would prevent it from actually deleting a record.

Code: [Select]
<?php 
//connects to the database
include ('db_connect.php');

//post variable
$pk = $_POST['pk'];

//MySQL code to query   ---- 'contacts' = table & 'primary_key' = record id #
$deleteContact = "DELETE FROM `contacts` WHERE `primary_key` = ".$pk." LIMIT 1";

//excutes query to MySQL
$res = mysqli_query($link,$deleteContact);

//close connection to database
mysqli_close($link);
?>
Any help would be great.
Thank you.