|
PHP - Php Coding Issue On Products Page
I need to disable a query on the products page. The URL is www.myjabberbox.com
If you goto the products page, you'll see when you hover over one of the three products, you can click it to take you to another page of that product. I want to disable that. I thought the code that I'd need to modify would be under the products-page.php file but I can't seem to find the code. Notice also when you hover over the products, a mouseover color of black happens around the image/text frame, I'd like to keep that, just disable the linking... Thanks Similar Tutorialsok, I can't seem to figure out how to go about this. I have a form where pics can be uploaded with certain id's which will tell them where they are placed, in apDiv2-9. the main id is how this is going to be identified. I would like it also so that once there are 8 products, a new page will begin, starting with apDiv10-18(I need the 2-9 to automatically change to 10-18, so like it would be if results are greatehr than 8, then apdiv will add 8 to the number part of it). I would like it to pull the image link from the database in the tag $image which will have to be pulled according to the apDiv#. how would I do this? does this make sense? this is extremely hard to explain. this is not the code that posts, this is the code that displays here is code: Code: [Select] <?php include_once "connect_to_mysql_1.php"; $sql = mysql_query("SELECT * FROM products"); while($row = mysql_fetch_array($sql)){ $image = $row['link']; } ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <meta name="description" content="Thank you for your interest in Old Mil-custom Woodworking. We have hired Aaron's Web Design to build a brand new website for us! Thank you for your patience!"> <meta name="keywords" content="Web, Design, web design, old, mil, oldmil, old mil, wood, woodwork, work, working, woodworking, woodworker, woodworkers, custom"> <title>Our Products-Old Mil</title> <style type="text/css"> <!-- body { font: 100%/1.4 Verdana, Arial, Helvetica, sans-serif; background: #42413C; margin: 0; padding: 0; color: #000; background-image: url(../images/background.png); } /* ~~ Element/tag selectors ~~ */ ul, ol, dl { /* Due to variations between browsers, it's best practices to zero padding and margin on lists. For consistency, you can either specify the amounts you want here, or on the list items (LI, DT, DD) they contain. Remember that what you do here will cascade to the .nav list unless you write a more specific selector. */ padding: 0; margin: 0; } h1, h2, h3, h4, h5, h6, p { margin-top: 0; /* removing the top margin gets around an issue where margins can escape from their containing div. The remaining bottom margin will hold it away from any elements that follow. */ padding-right: 15px; padding-left: 15px; /* adding the padding to the sides of the elements within the divs, instead of the divs themselves, gets rid of any box model math. A nested div with side padding can also be used as an alternate method. */ font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 100%; } a img { /* this selector removes the default blue border displayed in some browsers around an image when it is surrounded by a link */ border: none; } /* ~~ Styling for your site's links must remain in this order - including the group of selectors that create the hover effect. ~~ */ a:link { color: #42413C; text-decoration: underline; /* unless you style your links to look extremely unique, it's best to provide underlines for quick visual identification */ } a:visited { color: #6E6C64; text-decoration: underline; } a:hover, a:active, a:focus { /* this group of selectors will give a keyboard navigator the same hover experience as the person using a mouse. */ text-decoration: none; } /* ~~this fixed width container surrounds the other divs~~ */ .container { width: 960px; background: #FFF; margin: 0 auto; /* the auto value on the sides, coupled with the width, centers the layout */ } /* ~~ the header is not given a width. It will extend the full width of your layout. It contains an image placeholder that should be replaced with your own linked logo ~~ */ .header { background: #ADB96E; font-size: xx-large; font-family: "Comic Sans MS", cursive; height:137px; } /* ~~ These are the columns for the layout. ~~ 1) Padding is only placed on the top and/or bottom of the divs. The elements within these divs have padding on their sides. This saves you from any "box model math". Keep in mind, if you add any side padding or border to the div itself, it will be added to the width you define to create the *total* width. You may also choose to remove the padding on the element in the div and place a second div within it with no width and the padding necessary for your design. You may also choose to remove the padding on the element in the div and place a second div within it with no width and the padding necessary for your design. 2) No margin has been given to the columns since they are all floated. If you must add margin, avoid placing it on the side you're floating toward (for example: a right margin on a div set to float right). Many times, padding can be used instead. For divs where this rule must be broken, you should add a "display:inline" declaration to the div's rule to tame a bug where some versions of Internet Explorer double the margin. 3) Since classes can be used multiple times in a document (and an element can also have multiple classes applied), the columns have been assigned class names instead of IDs. For example, two sidebar divs could be stacked if necessary. These can very easily be changed to IDs if that's your preference, as long as you'll only be using them once per document. 4) If you prefer your nav on the right instead of the left, simply float these columns the opposite direction (all right instead of all left) and they'll render in reverse order. There's no need to move the divs around in the HTML source. */ .sidebar1 { float: left; width: 180px; background: #EADCAE; padding-bottom: 10px; height:770px } .content { padding: 10px 0; width: 780px; float: left; } /* ~~ This grouped selector gives the lists in the .content area space ~~ */ .content ul, .content ol { padding: 0 15px 15px 40px; /* this padding mirrors the right padding in the headings and paragraph rule above. Padding was placed on the bottom for space between other elements on the lists and on the left to create the indention. These may be adjusted as you wish. */ } /* ~~ The navigation list styles (can be removed if you choose to use a premade flyout menu like Spry) ~~ */ ul.nav { list-style: none; /* this removes the list marker */ border-top: 4px solid #666; /* this creates the top border for the links - all others are placed using a bottom border on the LI */ margin-bottom: 4px solid #666; /* this creates the space between the navigation on the content below */ } ul.nav li { border-bottom: 4px solid #666; /* this creates the button separation */ } ul.nav a, ul.nav a:visited { /* grouping these selectors makes sure that your links retain their button look even after being visited */ padding: 5px 5px 5px 15px; display: block; /* this gives the link block properties causing it to fill the whole LI containing it. This causes the entire area to react to a mouse click. */ width: 160px; /*this width makes the entire button clickable for IE6. If you don't need to support IE6, it can be removed. Calculate the proper width by subtracting the padding on this link from the width of your sidebar container. */ text-decoration: none; background-image: url(/images/slat.png); } ul.nav a:hover, ul.nav a:active, ul.nav a:focus { /* this changes the background and text color for both mouse and keyboard navigators */ background-image: url(/images/slat1.png); color: #000; } /* ~~ The footer ~~ */ .footer { padding: 10px 0; background: #CCC49F; position: relative;/* this gives IE6 hasLayout to properly clear */ clear: both; /* this clear property forces the .container to understand where the columns end and contain them */ } /* ~~ miscellaneous float/clear classes ~~ */ .fltrt { /* this class can be used to float an element right in your page. The floated element must precede the element it should be next to on the page. */ float: right; margin-left: 8px; } .fltlft { /* this class can be used to float an element left in your page. The floated element must precede the element it should be next to on the page. */ float: left; margin-right: 8px; } .clearfloat { /* this class can be placed on a <br /> or empty div as the final element following the last floated div (within the #container) if the #footer is removed or taken out of the #container */ clear:both; height:0; font-size: 1px; line-height: 0px; } .container .sidebar1 .nav li a div { color: #000; padding: 0px; } #apDiv1 { position:relative; left:160px; top:-130px; width:772px; height:88px; z-index:1; } #ap12 { position:relative; top:-50px; left:00px; width:772px; height:88px; z-index:1; } #apDiv2 { position:relative; left:30px; top:30px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv3 { position:relative; left:450px; top:-240px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv4 { position:relative; left:30px; top:-190px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv5 { position:relative; left:450px; top:-460px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv6 { position:relative; left:30px; top:-410px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv7 { position:relative; left:450px; top:-680px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv8 { position:relative; left:30px; top:-630px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } #apDiv9 { position:relative; left:450px; top:-900px; width:270px; height:270px; z-index:2; background-color: #CCCCCC; } --> </style></head> <body> <div class="container"> <div class="header"><a href="#"><img src="../images/Old Mil LOGO.jpg" alt="Insert Logo Here" name="Insert_logo" width="122" height="137" id="Insert_logo" style="background: #C6D580; display:block;" /> <div id="apDiv1"><span class="header">Old Mil<br /> Custom Woodworking, Inc. </span></div></a><!-- end .header --></div> <div class="sidebar1"> <ul class="nav"> <li><a href="/Products"> <div font color="black">Products</div></a></li> <li><a href="#"> <div font color="black">Coming Soon</div></a></li> <li><a href="#"> <div font color="black">Coming Soon</div></a></li> <li><a href="#"> <div font color="black">Coming Soon</div></a></li> </ul> <p> </p> <!-- end .sidebar1 --></div> <div class="content"> <h1> </h1> <h1><br /> <div id="apDiv2"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div><div id="apDiv3"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div> <div id="apDiv4"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div> <div id="apDiv5"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div> <div id="apDiv6"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div><div id="apDiv7"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div> <div id="apDiv8"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div> <div id="apDiv9"> <img src="<?php echo $image; ?>" width="700" height="300" /> </div><br /><br /><br /><br /> </h1> <!-- end .content --></div> <p> </p> <p> </p> <div class="footer"> <p>Website made by <a href="http://www.aaronswebdesign.infiniteserve.com">Aaron's Web Design</a></p> <!-- end .footer --></div> <!-- end .container --></div> </body> </html> I need to come up with a script that will get the number of products under a category and return the number of products shown on each page in Showing 1-20 Products out of (total number) I have this MYSQL which I'm also using to generate pagination. Code: [Select] $query5 = "SELECT COUNT(*) as num FROM $tbl_name WHERE product_category='$cat'"; $total_pages = mysql_fetch_array(mysql_query($query5)); $total_pages = $total_pages[num]; /* Setup vars for query. */ $targetpage = "store.php?cat=".$cat; //your file name (the name of this file) $limit = 20; //how many items to show per page $page = $_GET['page']; if($page){ $start = ($page - 1) * $limit; //first item to display on this page } else{ $start = 0; //if no page var is given, set start to 0 } The products are pulled from the database he Code: [Select] $sql30 = "SELECT * FROM $tbl_name WHERE product_category='$cat' LIMIT $start, $limit"; $result30 = mysql_query($sql30); I came up with one way, but it will only work when there are 20 products on the page. If there's less it won't calculate that amount. Im new to PHP so bare with me. I created a form for my website. A person can enter the information and when they hit "submit" all of the information is sent to my email. for example:
name: mike
state: ca
comment: hi
my problem is this: some of the entered information is sent, while other entered information is not. I also have a drop down menu that the user can chose from a variety of answers. how do i use php to get that information sent to my email? If this isnt a clear explanation please forgive me b/c Im not so sure how to explain it.
Any help is appreciated!
Hello, there I'm new at the PHP/MySql matter and so the code I'm going to bring up that I'm having trouble with was written by someone else for me a number of years ago. It worked just fine until recently and I'm not sure why it just up and stopped working. Nothing has changed, the database that this code is connected to is still very much the same. The problem I am having is trying to login via the Login name and Password. As I said before this code worked just fine up to a few days ago and the person that wrote this out for me has long since disappeared into the ether and I would really love to get this back up and working again, I just don't know where to begin. Now the problem, once from the login it gets me far enough to the "Login Success. Forwarding to tools..." that takes all who have access to tools to this next stage and that's when the trouble hit, with the information in and it sits and then come back "No password provided" so its basically not gettting the information from the database itself. Or something. So yes, if someone see something small, or an update in code or something, would be great. Otherwise... just have to give up on this. Be my luck the other PHP code that I have for the other various things - I run an online Roleplaying site requires people to submit character sheets, then to be able to view sheets, edit certain part of the sheets and this particular project is for the Storytellers to update those sheets - has decided to say um, I'm done working now. My webprovider offers the following if this is needed information wise: MySQL version 5.0.90-community PHP version 5.2.13 Thanks much for taking the moment to look this over, I'll try to provide as much detail I can if anyone post any further inquiry on this odd problem of mines. <?PHP if( !isset($pass) ){ die("No password provided"); } if( $pass == "" ){ die("No password provided"); } $sql = "SELECT * FROM stlogin WHERE id='$ID'"; mysql_connect("localhost", "USERNAME", "PASSWORD"); $rs = mysql_db_query("primevil_database",$sql); while ($row = mysql_fetch_object($rs)){ $password1 = $row->pass; $login = $row->login; $access = $row->access; } if( $password1 == $pass ){ } else{ die("Password not matched"); } ?> <?PHP if($access >= 2){ echo "Welcome $login. <BR>"; } if($access == 3){ echo "<strong><font color=\"#FF0000\">ST Level Access</font></strong><BR>"; } if($access == 2){ echo "<strong><font color=\"#FF0000\">Assistant ST Level Access</font></strong><BR>"; } if($access == 4){ echo "<strong><font color=\"#FF0000\">Admin Level Access</font></strong><BR><a href=\"deletechar.php?ID=$ID&pass=$pass\">Delete Character.</a><br>"; } if($access == 3 | $access == 4){ echo "<a href=\"editchar.php?ID=$ID&pass=$pass\">Edit Character.</a><br>"; } if($access == 2 | $access == 3 | $access == 4){ echo "<a href=\"searchchar.php?ID=$ID&pass=$pass\">Search Character.</a><br><a href=\"viewchar.php?ID=$ID&pass=$pass\">View Character.</a>"; } ?> Hi ; Im getting the below error from Access database please help me to fix it. [root@db_cesar home]# php test.php table name : t_b_Door column name : f_DoorID t is not a table in this database Error at Line : syntax error near _ PHP Warning: odbc_exec(): SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 in SQLExecDirect in /home/test.php on line 15 This is my code <?php $conn=odbc_connect("logindb","",""); if (!$conn) { exit("Connection Failed: " . $conn); } $sql="SELECT f_ReaderID FROM t_b_Reader"; $rs=odbc_exec($conn,$sql); if (!$rs) { exit("Error in SQL"); } while (odbc_fetch_row($rs)) { $f_ReaderID=odbc_result($rs,$f_ReaderID); //$conname=odbc_result($rs,"ContactName"); echo "$f_ReaderID \n"; } odbc_close($conn); ?> Thanks I'm using a wordpress theme which comes with a zoom feature for the product (main image and image gallery thumbnails). It currently opens the primary image (and any thumbnail) in a modal window which is quite ugly for a product showcase. Code is: Code: [Select] $imgtag = '<img src="'.$src.'"'.$titleattr.' alt="'.$alt.'" width="'.$width_a.'" height="'.$height_a.'" '.$classes.' />'; if (value_is_true($zoom)) return '<a href="'.ecarturl($img->id,'images').'/'.$img->filename.'" class="'.$zoomfx.'" rel="product-'.$this->id.'">'.$imgtag.'</a>'; I'm trying to implement Cloudzoom (http://www.professorcloud.com/mainsite/cloud-zoom-integration.htm) I changed the code to: Code: [Select] $imgtag = '<a href="'.ecarturl($img->id,'images').'/'.$img->filename.'" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:\'inside\'"> <img src="'.$src.'"'.$titleattr.' alt="'.$alt.'" width="'.$width_a.'" height="'.$height_a.'" '.$classes.' /></a>'; if (value_is_true($zoom)) return '<a href="'.ecarturl($img->id,'images').'/'.$img->filename.'" class="cloud-zoom-gallery" rel="useZoom: \'zoom1\'">"'.$imgtag.'</a>'; HTML Output: Code: [Select] <div id="main-picture-default"> <a href="http://www.url.com?siid=9/2-9202.jpg" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:'inside'"> <img src="http://www.url.com?siid=9&360,450,1,100,2441305929" alt="product-picture" width="360" height="450" /></a> </div> <div id="thumbs"> <ul id="thumbs-list-default"> <li class="one_third "><a href="http://www.url.com?siid=9/2-9202.jpg" class="cloud-zoom-gallery" rel="useZoom: 'zoom1'">“<a href="http://www.url.com?siid=9/2-9202.jpg" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:'inside'"> <img src="http://www.url.com?siid=9&64,64,1,452849676" alt="thumb" width="64" height="64" class="thumb-picture" /></a></a></li> <li class="one_third "><a href="http://www.url.com?siid=17/2-9203.jpg" class="cloud-zoom-gallery" rel="useZoom: 'zoom1'">“<a href="http://www.url.com?siid=17/2-9203.jpg" class = "cloud-zoom" id="zoom1" rel="adjustX: 10, adjustY:-4, zoomWidth:150, zoomHeight:150, position:'inside'"> <img src="http://www.url.com?siid=17&64,64,1,1330882420" alt="thumb" width="64" height="64" class="thumb-picture" /></a></a></li> </ul> The primary image zooms just fine. The trouble I have now caused is as follows: - On hovering the thumbnails, they automatically zoom. They shouldn't. Rather on clicking them it should change the primary image to that image. - There is a " on the page above each thumbnail which links to the thumbnail images bigger image, and on click it shows "loading" on the primary image but doesn't actually change the image. How can I fix my code to work the way the script works he http://www.professorcloud.com/mainsite/cloud-zoom-test.htm, so the thumbnail changes the primary image and the zoom doesn't occur on the thumbnail, only the primary image? Thanks! Note: Would changing the last line `'.$imgtag.'` to `'.ecarturl($img->id,'images').'/'.$img->filename.'` be the fix? Don't want to try it before I get confirmation Hi, When i am getting the part of the text using the function substr, am getting this kind of problem , (text in the end not printing properly) how to solve this. تسر مؤسسة مهارات التقنية ومؤسسة اشبكة الثنائية ان تطلع جميع عملاءها بإصدار نظام تاتش لإدارة الموقع الالكترونية من يوم السبت ا� This is the code am using $sub_string_content = substr($temp['News_Content'],0,300); Thanks, I'm developing my own CMS with a few functions and wanted to know how things are looking right now because I can't find a board for strickly CODING CRITIQUE so I put it in this board. There isn't a whole lot to go through. I know there is something wrong with my issets line but other than that just a general critique of how its shaping up? manager.php <?php session_start(); require "dbconfig.php"; require "functions.php"; if ((isset($_POST['username'])) && (isset($_POST['password']))) { $username = $_POST{'username'}; $password = SHA1($_POST{'password'}); validate($username, $password); } elseif ((!(isset('username'))) && (!(isset('password')))) { require_once "login.php"; } $username = stripslashes($username); $password = stripslashes($password); $username = mysql_real_escape_string($username); $password = mysql_real_escape_string($password); $sql="SELECT * FROM dbusers WHERE username='$username' and password='$password'"; $result = mysql_query($sql); ?> functions.php <?php // This page defines functions used by the login/logout process function validate($username, $password) { } ?> login.php <?php include_once ("globals.php"); ?> <html> <head> <title><?php echo $shortsitename; ?> EW Manager</title> <link rel="stylesheet" type="text/css" href="<?php echo "$stylesheet"; ?>" /> </head> <body> <p id="backtosite"><a href="#" title="Are you lost?">← Back to <?php echo $fedname ?></a></p> <div id="login"> <h1><?php echo $shortsitename; ?> Manager</h1> <form id="loginform" action="" method="POST"> <p><label>Username<br /><input type="text" name="username" id="user_login" class="input" size="15" /></label></p> <p><label>Password<br /><input type="password" name="password" id="user_pass" class="input" size="15" /></label></p> <p class="forgetmenot"><label><input name="rememberme" type="checkbox" id="rememberme" /> Remember Me</label></p> <p class="submit"> <input type="submit" value="Login" class="button-primary" /> </p> </form> </div> </body></html> Hello guys, I am a beginner in PHP, so please be gentle. I am building this website for a friend of mine. This website is made up by HTML/CSS. i.e., I have a page made with HTML & CSS. there are a few menus on the page. say Home, About Us, Contact Us, etc., Now I want to separate the page elements (like header/footer) from the page so as its easy to work on. the source is something like this Code: [Select] <HTML> <HEAD> <TITLE> My Page </TITLE> <LINK REL="STYLESHEET" HREF="./mystyle.css" TYPE="text/css" /> </HEAD> <BODY> <DIV ID="wrapper"> <DIV ID="header"> <DIV ID="logo"> <UL ID="menu"> <LI> <A HREF="./index.php"><SPAN>Home</SPAN></A> </LI> <LI> <A HREF="./login.php"><SPAN>Login</SPAN></A> </LI> <LI> <A HREF="./contactus.php"><SPAN>Contact Us</SPAN></A> </LI> </UL> <DIV ID="date"> <?php echo Date("d M Y");?> </DIV> </DIV> </DIV> <DIV ID="bodywrapper"> <DIV ID="main"> <DIV ID="content"> THIS IS A TEST! </DIV> </DIV> </DIV> <DIV ID ="clearfooter"></DIV> </DIV> <DIV ID="footer"> © <?php echo date("Y");?> </DIV> </BODY> </HTML> now I will have my content in the DIV called 'content'. now I have separated this one page into three different pages. like this: header.php Code: [Select] <HTML> <HEAD> <TITLE> My Page </TITLE> <LINK REL="STYLESHEET" HREF="./mystyle.css" TYPE="text/css" /> </HEAD> <BODY> <DIV ID="wrapper"> <DIV ID="header"> <DIV ID="logo"> <UL ID="menu"> <LI> <A HREF="./index.php"><SPAN>Home</SPAN></A> </LI> <LI> <A HREF="./login.php"><SPAN>Login</SPAN></A> </LI> <LI> <A HREF="./contactus.php"><SPAN>Contact Us</SPAN></A> </LI> </UL> <DIV ID="date"> <?php echo Date("d M Y");?> </DIV> </DIV> </DIV> footer.php Code: [Select] <DIV ID ="clearfooter"></DIV> </DIV> <DIV ID="footer"> © <?php echo date("Y");?> </DIV> </BODY> </HTML> and index.php Code: [Select] <?php include_once('header.php');?> <DIV ID="bodywrapper"> <DIV ID="main"> <DIV ID="content"> THIS IS A TEST </DIV> </DIV> </DIV> <?php include_once('footer.php');?> Is this the right way to code? I am worried because I have to keep in mind the safety of the website as I have to include a basic login module to this. is there any other style to write this? please do let me know.. thanks hello everyone. i'm having problem to create a search page. i want to create a search page like this but i dont have the coding source to refer.. can anyone give me the coding for me to refer.... Help Please Hey there is no error with this code it works just fine but I would love to know if there is unnecessary coding in it for example do i have to do the global variables? is there a better way to do mysql editing page? thanks <?php include "../configdb.php"; $id = $_GET['id']; if(isset($_POST['submit'])) { //global variables $name = $_POST['name']; $footer = $_POST['footer']; //run the query which adds the data gathered from the form into the database $result = mysql_query("UPDATE pages SET name='$name', footer='$footer' WHERE id='$id' ",$connect); echo "<b>Your Page have been edited successfully"; } elseif($id) { $result = mysql_query("SELECT * FROM pages WHERE id='$id' ",$connect); while($row = mysql_fetch_assoc($result)) { $name = $row['name']; $footer = $row['footer']; ?> <h3>::Edit Page</h3> <form method="post" action="<?php echo $_SERVER['PHP_SELF'] ?>?id=<?php echo $row['id']?>"> <input type="hidden" name="id" value="<?php echo $row['id']?>"> <input name="name" size="40" maxlength="255" value="<?php echo $name; ?>"> <input name="footer" size="40" maxlength="255" value="<?php echo $footer; ?>"> <input type="submit" name="submit" value="Submit"> <?php } } This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=343748.0 can someone help to add new products and increase the quantity of the product when pressing the + button, but it works for [-] Code: [Select] <?php include "./php/connection.php"; function products () { $query = "SELECT * FROM product"; if (@mysql_num_rows($query)==0) { echo "There are no products to display!"; } else { while ($query_row = mysql_fetch_array($query)) { "<div class='product'>" . "<img class='img' src=". $row["Image"]." alt='phone' width='100' height='150' />" . "<p class='name'>".$row["Name"]."</p>". "<p class='price'>£". $row["Price"] ."</p>". "<p><a href='./cart.php?ProductID=". $row["ProductID"]."' class='myButton'>More Info</a></p>". "</div>"; } } } if (isset($_GET['ProductID'])) { $quantity = mysql_query('SELECT * FROM product WHERE ProductID = ' .$_GET["ProductID"]); while ($quantity_row = mysql_fetch_array($quantity)) { if ($quantity_row["Quantity"]!=@$_SESSION["cart_".$_GET["ProductID"]]) { @$_SESSION["cart_".$_GET["ProductID"]]+="1"; } } } if (isset($_GET["remove"])) { $_SESSION["cart_".$_GET["remove"]]--; header("Location: ./cart.php"); # Go back to the login pages } if (isset($_GET["delete"])) { $_SESSION["cart_".$_GET["delete"]]="0"; header("Location: ./cart.php"); # Go back to the login pages } function paypal_items() { $num = 0; foreach($_SESSION as $name => $value) { if ($value!=0) { if (substr($name, 0, 5) == "cart_") { $productid = substr($name, 5, (strlen($name)-5)); $query = mysql_query('SELECT ProductID, Manufacturer, model, Price FROM product WHERE ProductID =' .$productid); while ($query_row = @mysql_fetch_array($query)) { $num++; echo '<input type="hidden" name="item_number_'.$num.'" value="'.$productid.'">'; echo '<input type="hidden" name="item_name_'.$num.'" value="'.$query_row['Name'].'">'; echo '<input type="hidden" name="amount_'.$num.'" value="'.$query_row['Price'].'">'; echo '<input type="hidden" name="shpping_'.$num.'" value="0">'; echo '<input type="hidden" name="shpping_'.$num.'" value="0">'; echo '<input type="hidden" name="quantity_'.$num.'" value="'.$value.'">'; } } } } } function cart () { "<table id='producttable' border='1'>". "<tr>". "<td class='td top'>Delete</td>". "<td class='td top'>Product Name</td>". "<td class='td top'>Quantity</td>". "<td class='td top'>Price</td>". "<td class='td top'>Sub Total</td>". "</tr>"; foreach($_SESSION as $name => $value) { if ($value>0) { if (substr($name, 0, 5) == "cart_") { $productid = substr($name, 5, (strlen($name)-5)); $query = mysql_query('SELECT * FROM product WHERE ProductID =' .$productid); while ($query_row = @mysql_fetch_array($query)) { $sub = $query_row["Price"] * $value; "<tr>". "<td class='td'><a href='./cart.php?delete=".$productid."'> [Delete] </a></td>". "<td class='td'>".$query_row["Manufacturer"]."</td>". "<td class='td'>".$value."</td>". "<td class='td'><a href='./cart.php?ProductID=".$productid."'> [+] </a>£".$query_row["Price"]."<a href='./cart.php?remove=".$productid."'> [-] </a></td>". "<td class='td'>£".$sub."</td>". "</tr>"; } } @$total += $sub; } } if (@$total==0) { echo "<p>Your basket is empty</p>"; } else { echo @" Total: £" .$total; ?> <form action="https://www.paypal.com/cgi-bin/webscr" method="post"> <input type="hidden" name="cmd" value="_cart"> <input type="hidden" name="upload" value="1"> <input type="hidden" name="business" value="kamran193@hotmail.co.uk"> <?php paypal_items(); ?> <input type="hidden" name="currency_code" value="GBP"> <input type="hidden" name="amount" value="<?php echo $total; ?>"> <input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but03.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!"> </form> <?php } echo "</table>"; } echo cart(); echo products(); ?> Hi, I'm trying to display the products for a certain tag in the email for new order in wooCommerce. For example, I want that when a client buys a product with a certain tag, all the products that have that tag to be added automatically to the order email too. For now I achieved to display the tag in the email but not the products that have that tag. I don't know how get the products that belongs to that tag and add them to the cart to so I can display them in the email. Any help as small as it may be, it is very welcomed, please. I'm a bit stuck. I'm not very skilled in php... Thank you very much
function email_products_per_tag( $order, $item ) {
$items = $order->get_items();
foreach ( $items as $item ) {
$terms = wp_get_post_terms( $item['product_id'], 'product_tag' );
foreach($terms as $term){
$term_names[] = $term->name; // Product tag Name
// $item2 = 'product_tag'=> ; // not very sure about this line...
}
}
}
add_action( 'woocommerce_email_after_order_table', 'email_products_per_tag', 10, 4 );
Edited September 15, 2020 by cimita Hello everyone. I'd like to know how to duplicate a product through a php back-office. That product consists of an ID in the "products" table of my DB. Then we have another table called "sub_products" that links its sub-products through a column named "product_id". So I have product with ID "1000", and sub-products associated with it on another table with ID's "2021", "2022", "2023". What's the routine I can use to duplicate both the product and its sub-products? I need to duplicate them because they fit 2 categories so I'm changing the category column during this duplicate. Could really use some help. Thank you in advance! Hi, I have been working on an eCommerce platform for the last few months. Its almost complete but I need to do one thing and thats to only display sub categories if products exist in them. This is the site craftgo.me (development site), and this is how the categories are produced for a category page. ie. http://www.craftgo.me/category.php?cat_id=96 Code: [Select] if($_GET['cat_id']) { $parents_id = $_GET['cat_id']; $cat_num_rows_sql = "SELECT category_id, parent_id FROM mccategories WHERE parent_id = '$parents_id'"; $cat_num_rows_result = mysql_query($cat_num_rows_sql); $cat_row_count = mysql_num_rows($cat_num_rows_result); if($cat_row_count == '0'){ $current_cat_parent_sql = "SELECT parent_id FROM mccategories WHERE category_id = '$cat_id'"; $current_cat_parent_result = mysql_query($current_cat_parent_sql); $cat_parent_row = mysql_fetch_array($current_cat_parent_result); $parent_id = $cat_parent_row['parent_id']; } else { $parent_id = $_GET['cat_id']; } } $catsql = "SELECT category_id, category_name FROM mccategories WHERE cat_showing = '0' AND parent_id = '$parent_id' ORDER BY category_name"; $catresult = mysql_query($catsql); while($catrow = mysql_fetch_array($catresult)) { $category_id = $catrow['category_id']; $cat_name = $catrow['category_name']; echo '<li><a href="category.php?cat_id=' . $category_id . '">' . $cat_name . '</a></li>'; } In the mcproducts table the category id for each product is under 'product_category' Im not even sure where to start to make this work, but if anyone could give me a pointer, that would be super. Many thanks Eoin Hello I have a custom php cart working great, with product pages and shopping cart and checkout using points rather than money. My problem is that I cannot get the actual product pages to display in colums (I want 5 items per colum and 8 rows per page). Instead the whole thing is displayed as a row. Here is the page that the products are shown on: http://www.theskinnyminnie.com/user/rent/ (I have removed the need to be signed on) Here is the code I am using: Code: [Select] <?php // Run a select query to get myproducts $dynamic List =""; $sql = mysql_query("SELECT * FROM Products ORDERY BY date_added DESC"); $productCount = mysql_num_rows($sql)){ if(productCount > 0){ while($row = mysql_fetch_array($sql)){ $id = $row["product_id"]; $product_name = $row["product_name"]; $price = $row["credits"]; $date_added = strftime("%b %d, %Y", strtotime($row["date_added"])); $dynamicList .= '<tr> <td><a href="product.php?id=' . $id . '"><img src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="1" /></a></td></tr> <tr> <td><a href="product.php?id=' . $id . '">' . $product_name . '</a></td> </tr> <tr> <td>' . $price . 'pts</td> </tr> <tr> <td> </td> </tr>'; } } else { $dynamicList = "We have no products listed in our store yet"; } mysql_close(); ?> and then i echo dynamicList I am having an issue trying to get products that I am entering through my admin panel to go into my database. I am thinking that the programmer of the script might have forgot some code possibly, but everything else does get inserted into the database regarding categories, manufactures etc. Here is the insert product php script. My db and functions are set to go to my database with website name/password etc.
<?php
if(!isset($_SESSION['customer_email'])){
echo "<script> window.open('../checkout.php','_self'); </script>";
}
$customer_email = $_SESSION['customer_email'];
$get_customer = "select * from customers where customer_email='$customer_email'";
$run_customer = mysqli_query($con,$get_customer);
$row_customer = mysqli_fetch_array($run_customer);
$customer_id = $row_customer['customer_id'];
$select_general_settings = "select * from general_settings";
$run_general_settings = mysqli_query($con,$select_general_settings);
$row_general_settings = mysqli_fetch_array($run_general_settings);
$product_vendor_status = $row_general_settings["new_product_status"];
?>
<script src="//cdn.tinymce.com/4/tinymce.min.js"></script>
<script>tinymce.init({ selector:'#product_desc,#product_features' });</script>
<div class="row"><!-- 2 row Starts -->
<div class="col-lg-12"><!-- col-lg-12 Starts -->
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<h3 class="panel-title">
<i class="fa fa-money fa-fw"></i> Insert Product
</h3>
</div><!-- panel-heading Ends -->
<div class="panel-body"><!-- panel-body Starts -->
<form id="insert_product_form" method="post" enctype="multipart/form-data"><!-- form-horizontal Starts -->
<div class="row"><!-- 2 row Starts -->
<div class="col-md-9"><!-- col-md-9 Starts -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Title </label>
<input type="text" name="product_title" class="form-control" required >
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Seo Description </label>
<textarea name="product_seo_desc" class="form-control" maxlength="230" placeholder="Most search engines use a maximum of 230 chars for the description."></textarea>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Url </label>
<input type="text" name="product_url" class="form-control" required >
<br>
<p style="font-size:15px; font-weight:bold;">
Product Url Example : navy-blue-t-shirt
</p>
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Product Tabs </label>
<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->
<li class="active">
<a data-toggle="tab" href="#description"> Product Description </a>
</li>
<li>
<a data-toggle="tab" href="#features"> Product Features </a>
</li>
<li>
<a data-toggle="tab" href="#video"> Sounds And Videos </a>
</li>
</ul><!-- nav nav-tabs Ends -->
<div class="tab-content"><!-- tab-content Starts -->
<div id="description" class="tab-pane fade in active"><!-- description tab-pane fade in active Starts -->
<br>
<textarea name="product_desc" class="form-control" rows="15" id="product_desc"></textarea>
</div><!-- description tab-pane fade in active Ends -->
<div id="features" class="tab-pane fade in"><!-- features tab-pane fade in Starts -->
<br>
<textarea name="product_features" class="form-control" rows="15" id="product_features"></textarea>
</div><!-- features tab-pane fade in Ends -->
<div id="video" class="tab-pane fade in"><!-- video tab-pane fade in Starts -->
<br>
<textarea name="product_video" class="form-control" rows="15"></textarea>
</div><!-- video tab-pane fade in Ends -->
</div><!-- tab-content Ends -->
</div><!-- form-group Ends -->
<div class="form-group" id="product_weight"><!-- form-group Starts -->
<label> Product Weight <small> (kg)</small> </label>
<input type="text" name="product_weight" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" id="product_price"><!-- form-group Starts -->
<label> Product Price </label>
<input type="text" name="product_price" class="form-control" required>
</div><!-- form-group Ends -->
<div class="form-group" id="product_psp_price"><!-- form-group Starts -->
<label> Product Sale Price </label>
<input type="text" name="psp_price" class="form-control">
</div><!-- form-group Ends -->
</div><!-- col-md-9 Ends -->
<div class="col-md-3"><!-- col-md-3 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Select A Product Type </label>
<select class="form-control" name="product_type"><!-- select manufacturer Starts -->
<option value="physical_product"> (Physical Product) Simple Product </option>
<option value="digital_product"> (Digital Product) Downloadable Product </option>
<option value="variable_product"> (Variable Product) Advanced Product </option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Select A Manufacturer </label>
<select class="form-control" name="manufacturer"><!-- select manufacturer Starts -->
<option> Select A Manufacturer </option>
<?php
$get_manufacturer = "select * from manufacturers";
$run_manufacturer = mysqli_query($con,$get_manufacturer);
while($row_manufacturer= mysqli_fetch_array($run_manufacturer)){
$manufacturer_id = $row_manufacturer['manufacturer_id'];
$manufacturer_title = $row_manufacturer['manufacturer_title'];
echo "<option value='$manufacturer_id'>
$manufacturer_title
</option>";
}
?>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<label> Product Category </label>
<select name="product_cat" class="form-control" >
<option> Select a Product Category </option>
<?php
$get_p_cats = "select * from product_categories";
$run_p_cats = mysqli_query($con,$get_p_cats);
while ($row_p_cats=mysqli_fetch_array($run_p_cats)) {
$p_cat_id = $row_p_cats['p_cat_id'];
$p_cat_title = $row_p_cats['p_cat_title'];
echo "<option value='$p_cat_id' >$p_cat_title</option>";
}
?>
</select>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Category </label>
<select name="cat" class="form-control" >
<option> Select a Category </option>
<?php
$get_cat = "select * from categories";
$run_cat = mysqli_query($con,$get_cat);
while ($row_cat=mysqli_fetch_array($run_cat)) {
$cat_id = $row_cat['cat_id'];
$cat_title = $row_cat['cat_title'];
echo "<option value='$cat_id'>$cat_title</option>";
}
?>
</select>
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 1 </label>
<input type="file" name="product_img1" class="form-control" required >
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 2 </label>
<input type="file" name="product_img2" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Image 3 </label>
<input type="file" name="product_img3" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Keywords </label>
<input type="text" name="product_keywords" class="form-control">
</div><!-- form-group Ends -->
<div class="form-group" ><!-- form-group Starts -->
<label> Product Label </label>
<input type="text" name="product_label" class="form-control">
</div><!-- form-group Ends -->
</div><!-- col-md-3 Ends -->
</div><!-- 2 row Ends -->
<div class="form-group" id="product-stock-management"><!-- form-group Starts -->
<label> Product Inventory Stock Management </label>
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<strong> Inventory - Stock Options </strong>
</div><!-- panel-heading Ends -->
<div class="panel-body"><!--panel-body Starts -->
<div class="row"><!-- row Starts -->
<div class="col-sm-6" id="stock-status"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Stock Status </label>
<select class="form-control" name="stock_status" required><!-- select manufacturer Starts -->
<option value="instock">In stock</option>
<option value="outofstock">Out of stock</option>
<option value="onbackorder">On backorder</option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Enable stock management at product level? </label>
<div class="radio">
<label>
<input type="radio" name="enable_stock" value="yes" required> Yes
</label>
<label>
<input type="radio" name="enable_stock" value="no" checked required> No
</label>
</div>
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
</div><!-- row Ends -->
<div class="row" id="stock-management-row"><!-- row Starts -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Stock Quantity </label>
<input type="number" name="stock_quantity" value="0" class="form-control" required>
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
<div class="col-sm-6"><!-- col-sm-6 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Allow backorders? </label>
<select class="form-control" name="allow_backorders" required><!-- select manufacturer Starts -->
<option value="no">Do not allow</option>
<option value="notify">Allow, but notify customer</option>
<option value="yes">Allow</option>
</select><!-- select manufacturer Ends -->
</div><!-- form-group Ends -->
</div><!-- col-sm-6 Ends -->
</div><!-- row Ends -->
</div><!--panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- form-group Ends -->
</form><!-- form-horizontal Ends -->
<div class="form-group" id="variable_product_options"><!-- form-group Starts -->
<label> Variable Product Options </label>
<div class="panel panel-default"><!-- panel panel-default Starts -->
<div class="panel-heading"><!-- panel-heading Starts -->
<ul class="nav nav-tabs"><!-- nav nav-tabs Starts -->
<li class="active">
<a data-toggle="tab" href="#product_attributes"> Product Attributes </a>
</li>
<li>
<a data-toggle="tab" href="#product_variations"> Product Variations </a>
</li>
</ul><!-- nav nav-tabs Ends -->
</div><!-- panel-heading Ends -->
<div class="panel-body"><!--panel-body Starts -->
<div class="tab-content"><!-- tab-content Starts -->
<div id="product_attributes" class="tab-pane fade in active"><!-- product_attributes tab-pane fade in active Starts -->
<form id="insert_attribute_form" method="post"><!-- form Starts -->
<div class="row"><!-- row Starts -->
<div class="col-sm-4"><!-- col-sm-4 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Name: </label>
<input type="text" name="attribute_name" class="form-control" required>
</div><!-- form-group Ends -->
</div><!-- col-sm-4 Ends -->
<div class="col-sm-8"><!-- col-sm-8 Starts -->
<div class="form-group"><!-- form-group Starts -->
<label> Value(s): </label>
<textarea name="attribute_values" class="form-control" placeholder="Enter some attributes by '|' separating values." required></textarea>
</div><!-- form-group Ends -->
</div><!-- col-sm-8 Ends -->
</div><!-- row Ends -->
<div class="form-group"><!-- form-group Starts -->
<input type="submit" value="Insert Product Attribute" class="btn btn btn-primary">
</div><!-- form-group Ends -->
</form><!-- form Ends -->
<table class="table table-hover table-bordered table-striped"><!-- table table-hover table-bordered table-striped Starts -->
<thead><!-- thead Starts -->
<tr>
<th>Attribute Name:</th>
<th>Attribute Value(s):</th>
<th>Actions:</th>
</tr>
</thead><!-- thead Ends -->
<tbody><!-- tbody Starts -->
<?php
$random_id = 152;
$select_product_attributes = "select * from product_attributes where product_id='$random_id'";
$run_product_attributes = mysqli_query($con,$select_product_attributes);
while($row_product_attributes = mysqli_fetch_array($run_product_attributes)){
$attribute_id = $row_product_attributes["attribute_id"];
$attribute_name = $row_product_attributes["attribute_name"];
$attribute_values = $row_product_attributes["attribute_values"];
?>
<tr id="tr-attribute-<?php echo $attribute_id; ?>">
<td>
<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_name; ?></div>
<input type="text" id="attribute-name" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_name; ?>">
</td>
<td>
<div class="edit" data-attribute="<?php echo $attribute_id; ?>"><?php echo $attribute_values; ?></div>
<input type="text" id="attribute-values" class="input-edit form-control" data-attribute="<?php echo $attribute_id; ?>" value="<?php echo $attribute_values; ?>">
</td>
<td>
<div class="btn-group">
<a href="#" class="edit-product-attribute btn btn-primary btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-pencil"></i> Edit
</a>
<a href="#" class="save-product-attribute btn btn-success btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-floppy-o"></i> Save
</a>
<a href="#" class="delete-product-attribute btn btn-danger btn-sm" data-attribute="<?php echo $attribute_id; ?>">
<i class="fa fa-trash-o"></i> Delete
</a>
</div>
</td>
</tr>
<?php } ?>
</tbody><!-- tbody Ends -->
</table><!-- table table-hover table-bordered table-striped Ends -->
</div><!-- product_attributes tab-pane fade in active Ends -->
<div id="product_variations" class="tab-pane fade in"><!-- product_variations tab-pane fade in Starts -->
<form id="product-variations-form" method="post" enctype="multipart/form-data"><!-- form Starts -->
<div class="form-group row"><!-- form-group Starts -->
<label class="col-sm-3 control-label"> Default Form Values: </label>
<div class="col-sm-9"><!-- col-sm-10 Starts -->
<div class="row" id="default_form_values"><!-- row default_form_values Starts -->
</div><!-- row default_form_values Ends -->
<span class="help-block">
These are the product attributes that will be pre-selected on the frontend.
</span>
</div><!-- col-sm-9 Ends -->
</div><!-- form-group Ends -->
<hr class="variation-hr">
<div class="form-group row"><!-- form-group Starts -->
<label class="col-sm-1 control-label"> Actions: </label>
<div class="col-sm-10"><!-- col-sm-10 Starts -->
<select class="form-control" id="action_select"><!-- select manufacturer Starts -->
<option value="add_variation"> Add A New Variation </option>
<option value="create_variations_from_attributes"> Create New Variations From All Attributes </option>
<option value="delete_all_variations"> Delete All Variations </option>
</select><!-- select manufacturer Ends -->
</div><!-- col-sm-10 Ends -->
<div class="col-sm-1"><!-- col-sm-1 Starts -->
<button type="button" id="go_button" class="btn btn-success form-control"> Go </button>
</div><!-- col-sm-1 Ends -->
</div><!-- form-group Ends -->
<div class="product-variations-div"><!-- product-variations-div Starts -->
</div><!-- product-variations-div Ends -->
<hr class="variation-hr">
<div class="form-group"><!-- form-group Starts -->
<input type="submit" value="Save Product Variations" class="btn btn btn-success">
</div><!-- form-group Ends -->
</form><!-- form Ends -->
<div class="ajax-response-div"></div>
</div><!-- product_variations tab-pane fade in Ends -->
</div><!-- tab-content Ends -->
</div><!--panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- form-group Ends -->
<div class="form-group"><!-- form-group Starts -->
<input type="submit" name="submit" value="Insert Product" form="insert_product_form" class="btn btn-primary form-control">
</div><!-- form-group Ends -->
</div><!-- panel-body Ends -->
</div><!-- panel panel-default Ends -->
</div><!-- col-lg-12 Ends -->
</div><!-- 2 row Ends -->
<script>
$(document).ready(function(){
//Product Stock Management Code Starts
$("#stock-management-row").hide();
$("input[name='enable_stock']").click(function(){
var radio_value = $(this).val();
if(radio_value == "yes"){
$("#stock-status").hide();
$("#stock-management-row").show();
}else if(radio_value == "no"){
$("#stock-status").show();
$("#stock-management-row").hide();
}
});
//Product Stock Management Code Ends
//Change Product Type Function Code Starts
function change_product_type(){
var product_type = $("select[name='product_type']").val();
if(product_type == "physical_product"){
$("#product_weight").show();
$("#product_price").show();
$("#product_psp_price").show();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);
$("#product-stock-management").show();
$('#product-stock-management input,#product-stock-management select').prop("disabled", false);
$("#variable_product_options").hide();
}else if(product_type == "digital_product"){
$("#product_weight").hide();
$("#product_price").show();
$("#product_psp_price").show();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", false);
$("#product-stock-management").show();
$('#product-stock-management input,#product-stock-management select').prop("disabled", false);
$("#variable_product_options").hide();
}else if(product_type == "variable_product"){
$("#product_weight").hide();
$("#product_price").hide();
$("#product_psp_price").hide();
$('#product_weight input,#product_price input,#product_psp_price input').prop("disabled", true);
$("#product-stock-management").hide();
$('#product-stock-management input,#product-stock-management select').prop("disabled", true);
$("#variable_product_options").show();
}
}
//Change Product Type Function Code Ends
change_product_type();
$("select[name='product_type']").change(function(){
change_product_type();
});
//Load Product Attributes Function Code Starts
function load_product_attributes(){
$.ajax({
method: "POST",
url: "variable_product/load_product_attributes.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$("table tbody").html(data);
$("table").removeClass("wait-loader");
}
});
}
//Load Product Attributes Function Code Ends
//Insert New Product Attribute Code Starts
$("#insert_attribute_form").submit(function(event){
event.preventDefault();
$("table").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/insert_product_attribute.php",
data: $('#insert_attribute_form').serialize() + "&random_id=<?php echo $random_id; ?>",
success: function(){
$("#insert_attribute_form").find("input[type=text],textarea").val("");
load_product_attributes();
}
});
});
//Insert New Product Attribute Code Ends
//Edit Product Attribute Code Starts
$(".input-edit").hide();
$(".save-product-attribute").hide();
$(".edit-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$(".edit").show();
$(".input-edit").hide();
$(".edit[data-attribute='" + attribute_id +"']").hide();
$(".input-edit[data-attribute='" + attribute_id +"']").show().focus();
$(".edit-product-attribute[data-attribute='" + attribute_id +"']").hide();
$(".save-product-attribute[data-attribute='" + attribute_id +"']").show();
});
//Edit Product Attribute Code Ends
//Update Save Product Attribute Code Starts
$(".save-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$(".edit[data-attribute='" + attribute_id +"']").show();
$(".input-edit[data-attribute='" + attribute_id +"']").hide();
$(".edit-product-attribute[data-attribute='" + attribute_id +"']").show();
$(".save-product-attribute[data-attribute='" + attribute_id +"']").hide();
var attribute_name = $("#attribute-name[data-attribute='" + attribute_id +"']").val();
var attribute_values = $("#attribute-values[data-attribute='" + attribute_id +"']").val();
$("#attribute-name[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_name);
$("#attribute-values[data-attribute='" + attribute_id +"']").prev(".edit").text(attribute_values);
var random_id = <?php echo $random_id; ?>;
$.ajax({
method: "POST",
url: "variable_product/update_product_attribute.php",
data: { random_id: random_id, attribute_id: attribute_id, attribute_name: attribute_name, attribute_values: attribute_values }
});
});
//Update Save Product Attribute Code Ends
//Delete Product Attribute Code Starts
$(".delete-product-attribute").on('click', function(event){
event.preventDefault();
var attribute_id = $(this).data("attribute");
$("#tr-attribute-" + attribute_id).remove();
var random_id = <?php echo $random_id; ?>;
$.ajax({
method: "POST",
url: "variable_product/delete_product_attribute.php",
data: { random_id: random_id, attribute_id: attribute_id }
});
});
//Delete Product Attribute Code Ends
//Load Product Variations Default Form Values Function Code Starts
function load_variations_default_form_values(){
$.ajax({
method: "POST",
url: "variable_product/load_default_form_values.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$("#default_form_values").html(data);
}
});
}
//Load Product Variations Default Form Values Function Code Ends
//Load Product Variations Function Code Starts
function load_product_variations(){
$.ajax({
method: "POST",
url: "variable_product/load_product_variations.php",
data: { random_id: <?php echo $random_id; ?> },
success:function(data){
$(".product-variations-div").html(data);
$(".product-variations-div").removeClass("wait-loader");
}
});
}
//Load Product Variations Function Code Ends
//Click Product Variations Tab Code Starts
$("a[href='#product_variations']").click(function(){
$(".product-variations-div").addClass("wait-loader");
load_variations_default_form_values();
load_product_variations();
});
//Click Product Variations Tab Code Ends
//Save Update Product Variations Function Code Starts
function save_update_product_variations(){
var form = document.getElementById("product-variations-form");
var form_data = new FormData(form);
form_data.append("random_id", <?php echo $random_id; ?>);
$.ajax({
method: "POST",
url: "variable_product/update_all_variations.php",
data:form_data,
contentType: false,
cache: false,
processData:false,
success: function(data){
$(".ajax-response-div").html(data);
$(".product-variations-div").removeClass("wait-loader");
}
});
}
//Save Update Product Variations Function Code Ends
//Product Variations Actions Go Button Code Starts
$("#go_button").click(function(){
var action_select = $("#action_select").val();
if(action_select == "add_variation"){
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/insert_product_variation.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(){
load_product_variations();
}
});
}else if(action_select == "create_variations_from_attributes"){
var confirm_action = confirm("Are you sure you want to link all variations? This will create a new variation for each and every possible combination of variation attributes (max 50 per run).");
if(confirm_action == true){
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/create_variations_from_attributes.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(data){
$(".ajax-response-div").html(data);
load_product_variations();
load_variations_default_form_values();
}
});
}
}else if(action_select == "delete_all_variations"){
var confirm_action = confirm("Are you sure you want to delete all variations? This cannot be undone.");
if(confirm_action == true){
$(".product-variations-div").addClass("wait-loader");
$.ajax({
method: "POST",
url: "variable_product/delete_all_variations.php",
data: { random_id: <?php echo $random_id; ?> },
success: function(){
load_product_variations();
load_variations_default_form_values();
}
});
}
}
});
//Product Variations Actions Go Button Code Ends
//Save Update Submit From Of Product Variations Code Starts
$("#product-variations-form").submit(function(event){
event.preventDefault();
$(".product-variations-div").addClass("wait-loader");
save_update_product_variations();
load_variations_default_form_values();
});
//Save Update Submit From Of Product Variations Code Ends
});
</script>
<?php
if(isset($_POST['submit'])){
$product_title = mysqli_real_escape_string($con, $_POST['product_title']);
$product_seo_desc = mysqli_real_escape_string($con, $_POST['product_seo_desc']);
$product_url = mysqli_real_escape_string($con, $_POST['product_url']);
$product_cat = mysqli_real_escape_string($con, $_POST['product_cat']);
$cat = mysqli_real_escape_string($con, $_POST['cat']);
$manufacturer_id = mysqli_real_escape_string($con, $_POST['manufacturer']);
$product_price = mysqli_real_escape_string($con, $_POST['product_price']);
$product_desc = mysqli_real_escape_string($con, $_POST['product_desc']);
$product_keywords = mysqli_real_escape_string($con, $_POST['product_keywords']);
$psp_price = mysqli_real_escape_string($con, $_POST['psp_price']);
$product_label = mysqli_real_escape_string($con, $_POST['product_label']);
$product_type = mysqli_real_escape_string($con, $_POST['product_type']);
$product_features = mysqli_real_escape_string($con, $_POST['product_features']);
$product_video = mysqli_real_escape_string($con, $_POST['product_video']);
$product_weight = mysqli_real_escape_string($con, $_POST['product_weight']);
$stock_status = mysqli_real_escape_string($con, $_POST['stock_status']);
$enable_stock = mysqli_real_escape_string($con, $_POST['enable_stock']);
$stock_quantity = mysqli_real_escape_string($con, $_POST['stock_quantity']);
$allow_backorders = mysqli_real_escape_string($con, $_POST['allow_backorders']);
$status = "product";
$product_img1 = $_FILES['product_img1']['name'];
$product_img2 = $_FILES['product_img2']['name'];
$product_img3 = $_FILES['product_img3']['name'];
$temp_name1 = $_FILES['product_img1']['tmp_name'];
$temp_name2 = $_FILES['product_img2']['tmp_name'];
$temp_name3 = $_FILES['product_img3']['tmp_name'];
$allowed = array('jpeg','jpg','gif','png');
$product_img1_extension = pathinfo($product_img1, PATHINFO_EXTENSION);
$product_img2_extension = pathinfo($product_img2, PATHINFO_EXTENSION);
$product_img3_extension = pathinfo($product_img3, PATHINFO_EXTENSION);
if(!in_array($product_img1_extension,$allowed)){
echo "<script> alert('Your Product Image 1 File Extension Is Not Supported.'); </script>";
$product_img1 = "";
}else{
move_uploaded_file($temp_name1,"../admin_area/product_images/$product_img1");
}
if(!empty($product_img2)){
if(!in_array($product_img2_extension,$allowed)){
echo "<script> alert('Your Product Image 2 File Extension Is Not Supported.'); </script>";
$product_img2 = "";
}else{
move_uploaded_file($temp_name2,"../admin_area/product_images/$product_img2");
}
}
if(!empty($product_img3)){
if(!in_array($product_img3_extension,$allowed)){
echo "<script> alert('Your Product Image 3 File Extension Is Not Supported.'); </script>";
$product_img3 = "";
}else{
move_uploaded_file($temp_name3,"../admin_area/product_images/$product_img3");
}
}
$insert_product = "insert into products (vendor_id,p_cat_id,cat_id,manufacturer_id,date,product_title,product_seo_desc,product_url,product_img1,product_img2,product_img3,product_price,product_psp_price,product_desc,product_features,product_video,product_keywords,product_label,product_type,product_weight,product_vendor_status,status) values ('$customer_id','$product_cat','$cat','$manufacturer_id',NOW(),'$product_title','$product_seo_desc','$product_url','$product_img1','$product_img2','$product_img3','$product_price','$psp_price','$product_desc','$product_features','$product_video','$product_keywords','$product_label','$product_type','$product_weight','$product_vendor_status','$status')";
$run_product = mysqli_query($con,$insert_product);
$product_id = mysqli_insert_id($con);
if($run_product){
if($product_type != "variable_product"){
if($enable_stock == "yes" and $stock_quantity > 0){
$stock_status = "instock";
}elseif($enable_stock == "yes" and $allow_backorders == "no" and $stock_quantity < 1){
$stock_status = "outofstock";
}elseif($enable_stock == "yes" and ($allow_backorders == "yes" or $allow_backorders == "notify") and $stock_quantity < 1){
$stock_status = "onbackorder";
}
$insert_product_stock = "insert into products_stock (product_id,enable_stock,stock_status,stock_quantity,allow_backorders) values ('$product_id','$enable_stock','$stock_status','$stock_quantity','$allow_backorders')";
$run_insert_product_stock = mysqli_query($con,$insert_product_stock);
}
$update_product_stock = "update products_stock set product_id='$product_id' where product_id='$random_id'";
$run_update_product_stock = mysqli_query($con,$update_product_stock);
$update_product_attributes = "update product_attributes set product_id='$product_id' where product_id='$random_id'";
$run_product_attributes = mysqli_query($con, $update_product_attributes);
$update_product_variations = "update product_variations set product_id='$product_id' where product_id='$random_id'";
$run_product_variations = mysqli_query($con, $update_product_variations);
echo "
<script>
alert(' Your Product Has Been Inserted Successfully. ');
window.open('index.php?products','_self');
</script>
";
}
}
?>
conceptually I have a class that holds data and operations on a product line of products.
I wrote the class originally for a Product Line with model numbers B, C, D, E. All of these worked similarly so my class had methods for those model numbers.
Later: a new product number A was added for this product line. Turns out model A despite being from the same product line, has different features and somewhat different data, and somewhat different computation patters.
I am hacking up my class and now see things like
public someMethod()
{
if ($this->modelNumber == 'A')
{
//do this special thing
}
else
{
//proceed as before for models B, C, D, E
}
//otherwise, do things that apply to all models, including A, B, C, D, E
}
Somehow I feel that eventually I will end up with a switch statement for multiple models and conventional wisdom says it is not the way to go. That I am to use polymorphism instead.
Well, great, but how? Do I perhaps just extend my product class like
class ProductA extends Product
{
//my specific A model stuff here
}
If I do this though I will essentially move my If/then/else to the main code. i.e.
if ($this->modelNumber == 'A') $product = new ProductA(); //A product else $product = new Product(); //general B, C, D, Eand THAT will become the switch statement eventually. So polymorphism does not solve anything for me here. How do I then write / restructure my class, if at all ? Edited by dennis-fedco, 30 May 2014 - 10:51 AM. hi My first language is not english so i hope you bear it i am new to php am am making my shopping Cart as my web engineering course i have made everything i all want to know how to i show similar products when a user click on any product details it open new page and shows a detail of that page i want to show similar products list below to details so can any tell me how to do it plzz kindly see the pic in atttachment i have posted snap shop of my page i put similar product statically i want to show it dynamically from tha data base kindly answer please regards |
|||||||