rachae1

Hi I have fixed it needed to get the variable which is something I had never needed to do before. I think register_globals was set to OFF.

Hi I am hoping someone can help. My hosting company has just moved my website to a different server, and I noticed that it was giving me blank pages, I added in some debug and now I am getting undefined variable errors and I don't know why or how to fix it. The Page which has broken currently gets its information from the database from the url. RewriteRule ^reviews/([^/]*)\/$ /bingosite.php?h1=$1 [L] The code in the broken page that is throwing out undefined variable errors is the following: <? $query = mysql_query("SELECT * FROM link where linktype='bingo' and h1 ='".StripUrl101(ucwords($h1))."'"); { while($row =mysql_fetch_assoc($query)) extract($row);?> <? if ($linkType=="bingo") { ?> <?php echo "$h1"; ?> <? } } ?> I have used this code for years so it could be that it is old but as I only know basic PHP I am very stuck and the hosting company isn't being very helpful. Just to add if I write <? $query = mysql_query("SELECT * FROM link where linktype='bingo' and h1 ='Quick Bingo'"); { while($row =mysql_fetch_assoc($query)) extract($row);?> The results for Quick Bingo appear on the page. However it needs to work dynamically like it was doing before. If anyone can help it would be appreciated. Thanks Rachael

Im sorry I dont appear to be getting anywhere as im already using that code you suggested

Thank you for your help the form now remembers the image however it wont let me update the image if I needed to change it. I'm not sure how to do change it. This is the updated code: <?php $link_image=($_FILES['link_image']['name']); if(!empty($_FILES["link_image"]["name"])) { $uploaddir = 'images/products/'; $uploadfile = $uploaddir . basename($_FILES['link_image']['name']); echo '<pre>'; if (move_uploaded_file($_FILES['link_image']['tmp_name'], $uploadfile)) { echo "File is valid, and was successfully uploaded.\n"; } else { echo "Possible file upload attack!\n"; } } #+--------------------------------------- $short_desc = $_POST['short_desc']; $url = $_POST['url']; $category = $_POST['category']; $designers = $_POST['designers']; $price = $_POST['price']; $long_desc = $_POST['long_desc']; $link_image = $_POST['link_image']; $products_id = $_POST['products_id']; $todays_date = date('Y-m-j H:i:s'); #+--------------------------------------- $modify_products_query = "UPDATE "; $modify_products_query .= $tbl_products; $modify_products_query .= " SET "; $modify_products_query .= " short_desc='" . $short_desc . "', "; $modify_products_query .= " long_desc='" . $long_desc . "', "; $modify_products_query .= " url='" . $url . "', "; $modify_products_query .= " date_added='" . $todays_date . "', "; $modify_products_query .= " price='" . $price . "', "; $modify_products_query .= " category='" . $category . "', "; $modify_products_query .= " designers='" . $designers . "' "; if($link_image <> '') $modify_products_query .= " link_image='" . $link_image . "' "; $modify_products_query .= " WHERE products_id='" . $products_id . "'"; $modify_products_query .= ";"; $modify_products_result = domysql($modify_products_query,'updating 1 products item in ' . $_SERVER['PHP_SELF']); $action = ''; $message = "Updated Item : '" . $short_desc . "'"; ?> <script type="text/javascript"> <!-- function x() { window.location.href = "admin.php?products_action=preview&indexKey=<?php echo $products_id;?>" } x() --> </script>

Hi thank you for the reply. This is the mysql code: <?php $link_image=($_FILES['link_image']['name']); if(!empty($_FILES["link_image"]["name"])) { $uploaddir = 'images/products/'; $uploadfile = $uploaddir . basename($_FILES['link_image']['name']); echo '<pre>'; if (move_uploaded_file($_FILES['link_image']['tmp_name'], $uploadfile)) { echo "File is valid, and was successfully uploaded.\n"; } else { echo "Possible file upload attack!\n"; } } #+--------------------------------------- $short_desc = $_POST['short_desc']; $url = $_POST['url']; $category = $_POST['category']; $designers = $_POST['designers']; $price = $_POST['price']; $long_desc = $_POST['long_desc']; $products_id = $_POST['products_id']; $todays_date = date('Y-m-j H:i:s'); #+--------------------------------------- $modify_products_query = "UPDATE "; $modify_products_query .= $tbl_products; $modify_products_query .= " SET "; $modify_products_query .= " short_desc='" . $short_desc . "', "; $modify_products_query .= " long_desc='" . $long_desc . "', "; $modify_products_query .= " url='" . $url . "', "; $modify_products_query .= " date_added='" . $todays_date . "', "; $modify_products_query .= " link_image='" . $link_image . "', "; $modify_products_query .= " price='" . $price . "', "; $modify_products_query .= " category='" . $category . "', "; $modify_products_query .= " designers='" . $designers . "'"; $modify_products_query .= " WHERE products_id='" . $products_id . "'"; $modify_products_query .= ";"; $modify_products_result = domysql($modify_products_query,'updating 1 products item in ' . $_SERVER['PHP_SELF']); $action = ''; $message = "Updated Item : '" . $short_desc . "'"; ?> <script type="text/javascript"> <!-- function x() { window.location.href = "admin.php?products_action=preview&indexKey=<?php echo $products_id;?>" } x() --> </script> And this is the upload box code for my modify page <?php $product_id = $_GET['product_id']; $get_link_query = "SELECT * FROM products"; $get_link_query .= ";"; $get_link_result = domysql($get_link_query,'selecting link to modify ' . $_SERVER['PHP_SELF']); $row = mysql_fetch_assoc($get_link_result); extract($row); ?> <div id="admincontentcontainer"> <div align="center"> <br/> <h1>Modify a Product Product </h1> <a href="admin.php" class="mainmenulinks">Admin Main Menu</a> | <a href="logout.php" class="mainmenulinks">Log out of Admin</a> </div> <br/> <img src='http://www.glitzyfashion.co.uk/images/divider.jpg' alt='Glitzy Fashion' /> <br/> <form enctype="multipart/form-data" name="modify_products_config" method="POST" action="admin.php"> <input name="products_action" type="hidden" id="products_action" value="modify_products_config"> <h3>Product Title</h3> <input name="short_desc" id="short_desc" type="text" size="80" class="input" value="<?php echo $short_desc; ?>" /> <h3>Product Description</h3> <textarea name="long_desc" id="long_desc" cols="80" rows='20' wrap='VIRTUAL' class='input'> <?php echo $long_desc; ?> </textarea> <h3>Affiliate Url</h3> <input name="url" id="url" type="text" size="50" class="input" value="<?php echo $url; ?>"/> <h3>Current Image</h3> <img src='/images/products/<?php echo $link_image; ?>' width='200'/> <h3>Upload an Image</h3> <input type="hidden" name="size" value="350000"> <input type="file" name="link_image"> <h3>Price</h3> <input name="price" id="price" type="text" size="50" class="input" value="<?php echo $price; ?>"/> <h3>Product Category</h3> <select id="category" name="category" class="input" > <option selected="true" value='<?php echo $category; ?>'><?php echo $category; ?> (current)</option> <option value=''>--choose category--</option> <option value='Brands'>Brands</option> <option value='Accessories'>Accessories</option> <option value='Bags and Purses'>Bags and Purses</option> <option value='Beauty'>Beauty</option> <option value='Coats and Jackets'>Coats and Jackets</option> <option value='Evening Party Dresses'>Evening Party Dresses</option> <option value='Denim'>Denim</option> <option value='Trousers and Shorts'>Trousers and Shorts</option> <option value='Jumpers and Cardigans'>Jumpers and Cardigans</option> <option value='Tops'>Tops</option> <option value='Shoes'>Shoes</option> <option value='Childrens'>Childrens</option> <option value='Gifts'>Gifts</option> <option value='Homeware'>Homeware</option> </select> <h3>Choose a Designer</h3> <select id="designers" name="designers" class="input" > <option selected="true" value='<?php echo $designers; ?>'><?php echo $designers; ?> (current)</option> <option value=''>--choose a designer--</option> <?php $query = mysql_query("SELECT * FROM shop where linkType='brands' ORDER BY h1"); while($row = mysql_fetch_assoc($query)) { extract($row); ?> <option value='<?php echo $h1; ?>'><?php echo $h1; ?></option> <?php } ?> </select> <br/><br/> <input name="products_id" type="hidden" id="products_id" value="<?php echo $products_id;?>"> <input type="submit" name="submit" value="Modify Products" tabindex="2"> </form> </div>

Hi Can anyone help please. Ive looked around the internet and im struggling to get my head around why it isnt working. Thanks in advanced

Hi I have changed my code to the following and when I modify the page and leave the upload box field blank it is still posting the empty data and removing the original file name from the database. <?php $link_image=($_FILES['link_image']['name']); if(!empty($_FILES["link_image"]["name"])) { $uploaddir = 'images/products/'; $uploadfile = $uploaddir . basename($_FILES['link_image']['name']); echo '<pre>'; if (move_uploaded_file($_FILES['link_image']['tmp_name'], $uploadfile)) { echo "File is valid, and was successfully uploaded.\n"; } else { echo "Possible file upload attack!\n"; } }

Hi I was wondering if anyone could help me out with a code problem. I am not very advanced with php but I do try to learn and I have been trying to figure out how to do something for a few hours now and im hoping someone here can help. Basically I have a php form with an upload box that posts data to my database this all works perfectly but my problem now is editing my data. When I edit the data and ignore the upload box it deletes the currect image in my database that I originally added. How can I edit the code so it keeps the currect image if the upload box is left blank. This is my currect modify page code: <?php //This is the directory where images will be saved $target = "images/products/"; $target = $target . basename( $_FILES['link_image']['name']); //This gets all the other information from the form $link_image=($_FILES['link_image']['name']); //Writes the photo to the server if(move_uploaded_file($_FILES['link_image']['tmp_name'], $target)) { //Tells you if its all ok echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; } else { //Gives and error if its not echo "Sorry, there was a problem uploading your file."; } #+--------------------------------------- $short_desc = $_POST['short_desc']; $url = $_POST['url']; $category = $_POST['category']; $designers = $_POST['designers']; $shop = $_POST['shop']; $price = $_POST['price']; $rss_long_desc = $_POST['rss_long_desc']; $long_desc = $_POST['long_desc']; $news_id = $_POST['news_id']; $todays_date = date('Y-m-j H:i:s'); #+--------------------------------------- $modify_news_query = "UPDATE "; $modify_news_query .= $tbl_news; $modify_news_query .= " SET "; $modify_news_query .= " short_desc='" . $short_desc . "', "; $modify_news_query .= " rss_long_desc='" . $rss_long_desc . "', "; $modify_news_query .= " url='" . $url . "', "; $modify_news_query .= " date_added='" . $todays_date . "', "; $modify_news_query .= " link_image='" . $link_image . "', "; $modify_news_query .= " price='" . $price . "', "; $modify_news_query .= " category='" . $category . "', "; $modify_news_query .= " designers='" . $designers . "', "; $modify_news_query .= " shop='" . $shop . "' "; $modify_news_query .= " WHERE news_id='" . $news_id . "'"; $modify_news_query .= ";"; $modify_news_result = domysql($modify_news_query,'updating 1 news item in ' . $_SERVER['PHP_SELF']); $action = ''; $message = "Updated Item : '" . $short_desc . "'"; //echo "Modifying news item ".$news_id." with query: ".$modify_news_query; #+--------------------------------------- ?> <script type="text/javascript"> <!-- function x() { window.location.href = "admin.php?news_action=preview&indexKey=<?php echo $news_id;?>" } x() --> </script>

I would like someone to point me in the right direction so that I can page the data, I have the below paging code for something else but I cant get it to work with the like code. <?php if(!isset($_GET['page'])){$page = 1;} else {$page = $_GET['page'];} $max_results = 5; $from = (($page * $max_results) - $max_results); $total_results = mysql_result (mysql_query ("SELECT COUNT(*) AS num FROM link WHERE linkType='cars' "), 0); <?php $total_pages = ceil($total_results / $max_results); echo "<center><br />"; if($page > 1){$prev = ($page - 1); echo "<a title='Previous Page' href=\"".$_SERVER['PHP_SELF']."?page=$prev\"> &#8249;&#8249; Previous</a> ";} for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "Page $i ";} else {echo "<a href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> ";} } if($page < $total_pages){ $next = ($page + 1); echo "<a title='Next Page' href=\"".$_SERVER['PHP_SELF']."?page=$next\"> Next &#8250;&#8250;</a>";} echo "<br/>"; echo "<br/>"; echo "</center><br />"; ?> <?php $query = mysql_query("SELECT * FROM link WHERE linkType='cars' ORDER BY h1 LIMIT $from, $max_results"); while($row = mysql_fetch_assoc($query)) { extract($row);

Hi, Can someone help me page records that I get from a keyword in an url. Currently my code looks like this: <?php $tag_id = $_GET['tag_id']; $query = mysql_query("SELECT * FROM news WHERE tag_id like '%$tag_id%' ORDER BY date_added DESC"); while($row = mysql_fetch_assoc($query)) { extract($row); include("include/keywordsummary.inc.php"); ?> <?php } ?>

Thank you that worked a treat

infact that code dont work at all for me. used it from http://www.brainhandles.com/2007/04/26/simple-tagging-with-php-mysql/ :S

eugh sorry if ($submit == 'Addtag') { $taginput = $_POST["tags"]; $tagarray = explode(",",$taginput); for($i=0;$i<count($tagarray);$i++){ $tags = mysql_real_escape_string(stripslashes(ltrim(rtrim($tagarray[$i])))); if($tags == "") continue; $query = "INSERT INTO category_tags (tags) VALUES ($tags')"; mysql_query($query); } Database 23 Array 24 Array 25 Array }

Hi I have just changed my code taken from a tutorial it now looks like this : if ($submit == 'Addtag') { $taginput = $_POST["tags"]; $tagarray = explode(",",$taginput); for($i=0;$i<count($tagarray);$i++){ $tags = mysql_real_escape_string(stripslashes(ltrim(rtrim($tagarray[$i])))); if($tags == "") continue; $query = "INSERT INTO category_tags (tags) VALUES ($tags')"; mysql_query($query); } 23 Array 24 Array 25 Array } I entered 3 keywords but each of those keywords now says Array instead of the keyword name. My database looks like this

Hi Thanks for your reply. Sorry I am new to arrays but trying to learn them. Can I not add comma seperated keywords and seperate it before it goes into the database ?