broj1

Use `UPDATE ... WHERE ...` syntax. If you want more detailed help post the code you already have and be as specific as possible with your question. Read [this](http://www.daniweb.com/web-development/php/threads/435023/read-this-before-posting-a-question).

Put this temporary debug code on line 2: die($_GET['orderBy']); It should print the sort condition and stop the script. Check it whether is OK or post it here. Just a thought: maybe you should add a script name to your links: <a href="<?php echo __FILE__; ?>?orderBy=date">Type:</a>

This code is first compressed used zlib library and then base64 encoded, probably to obfuscate the original code, or just to simplify transport. There is no encryption key involved. The snippet above is just a reverse of this. The variable and function names are probably also obfuscated in a way …

Your question is not very clear about what exactly is the problem. Is the text html? To display html use [htmlspecialchars](http://php.net/manual/en/function.htmlspecialchars.php) function which will safely display problematic characters (such as < and >). If you have different character sets use [mb_encode_numericentity](http://www.php.net/manual/en/function.mb-encode-numericentity.php) function instead. If the text is plain text your …

What are the date values that yield unwanted results?

Line 13: <?php echo $op;?> should probably create the html for options for the categories dropdown. But I can't find where $op is defined. Have you checked the generated code for the categoties dropdown?

And consider this: to access a mysql database you use a php database extension such as [mysql](http://php.net/manual/en/book.mysql.php), [mysqli](http://php.net/manual/en/book.mysqli.php) or [PDO](http://www.php.net/manual/en/book.pdo.php). If you are starting to learn please do not use the oldest mysql extension since it is being phased out. It is OK if you use newer mysqli extension but …

Thanx for this tip. However note that $_SERVER['HTTP_REFERER'] is [not always 100% reliable](http://php.net/manual/en/reserved.variables.server.php).

First check whether the data in the table is OK (maybe you have multiple same inserts). The query in the getv.php seems to be missing the name field, since you refer to it in the while loop: $query = mysql_query("SELECT image, name FROM upload WHERE `category` = '$category'");

Are you sure the query returns 1? Test it with some code like: if($status == 1) { die('Status is obviously 1'); // header('location: index.php?user='.$user.''); } else { die('Status is actually ' . print_r($status, 1)); }

Unfortunately it is not enough just change mysql_* commands to mysqli_*. There are minor differences. For example mysql_query takes first parameter the query and optional second the link while mysqli_query takes the first parameter link (must be present) and second the query. I suggest you check the syntax of each …

Put this temporary debug code on line 14. die("UPDATE tblproduct SET status='inactive' WHERE prod_id='".$prod_id."';"); It will display the query and stop the script. Now copy the query in phpmyadmin and test it.

You should use POST method for that: <form method="post" action="process.php"> <input type="password" name="pass"> <input type="submit" name="submit" value="Submit password"> </form> And this is an example of a process.php <?php // check if password is set and matches criteria if(isset($_POST['pass']) && $_POST['pass'] != '') { // escape the value to avoid most …

The isset() function returns TRUE or FALSE. You probably wanted it this way: if(isset($_GET['_rp']) && $_GET['_rp'] == 1) ... elseif(isset($_GET['_rp']) && $_GET['_rp'] == 2) ...

If you resize your window width below about 970 px the horizontal scrollbar appears. This is usually set using min-width css property on container div element.

If you are learning to use ajax it might be right time to look at jquery also. jquery has nice [support for ajax](http://api.jquery.com/jQuery.ajax/) and will save you from using xmlhttp object directly making sure you cover all browsers and have the code right. Of course, all above about safe querying …

On each click of a button the form gets submitted with only one value. You'd be better off putting checkboxes next to each image (and only one submit button) and then check the array of checked ckeckboxes to produce the IN condition. Just an idea.

Posting the existing code might help solving the problem.

I would expect in html formated mail <br> tag would produce a line break. This can't be the case in your message ($msg) since you are stripping all the tags. Maybe you should do it this way: $msg = strip_tags( $_GET['msg'], '<br>' ); provided that $_GET['msg'] already contains html breaks …

Another one is [jQplot](http://www.jqplot.com/), open source and free for commercial use. I quite liked it. Simple and effective bar chart can also be accomplished just by using tables or divs and a bit of css. I have done it once in a small project and it looked quite cute.

A simple tutorial: http://www.tutorialspoint.com/php/php_get_post.htm Noce explanation on W3schools: http://www.w3schools.com/tags/ref_httpmethods.asp A technical specification as a part of of the HTTP protocol: http://www.w3.org/Protocols/rfc2616/rfc2616-sec9.html And all this leads to: http://en.wikipedia.org/wiki/Representational_state_transfer#About and http://www.ibm.com/developerworks/webservices/library/ws-restful/ In simplified terms: use GET to retrieve data from the server, use POST to send data to the server, when you …

Upon successful insertion you might want to initialize $_POST with this code on line 43 (provided that you do not need the values anymore): $_POST = array(); Then the correct check would be: if(isset($_POST) && !empty($_POST)) The check you use in your code (`if($_POST != ''`)) is incorrect - $_POST …

One approach would be to read the contents of the table in a giant string, hash that string and store the hash. Later you can repeat the procedure and compare the computed hash with the stored hash. But there are few considerations: - the string that you read rows into, …

The $`_POST` array doesn't contain a `name` element. The reason is in that the name input field has not been submitted yet. Include a check such as: <?php if(isset($_POST['name']) && !empty($_POST['name'])) { $name1=$_POST['name']; echo "<br> Your name is $name1 . Thanks for using our system."; } ?> Even better would …

Shuldn't it be: header('location: ../admin.php'); // 1 folder up header('location: ../../admin.php'); // 2 folders up But HTTP 1.1 requires an absolute URI for the Location field so I am not sure if the above is OK to be used. Anyone knows more about that?

What API do you use?

Do you have any code yet?

An older post but it might help: http://www.daniweb.com/web-development/php/threads/124300/how-to-php-export-to-excel

I hope your query returns also prices for each of the retailers (it is not evident from the sql statement since you are using `SELECT *`). So in the while loop you can calculate running sum for all the prices. Once the while loop is finished the running sums will …

This is strange. It works fine for me. Can you put this code on the very beginning of the lgin.php: die(print_r($_POST, 1)); This will display contents of the $_POST array and stop the script.

It could be that $_GET['id'] does not exist. To make sure it exists, do a check: if(isset($_GET['id'])) { $id = intval($_GET['id']); } else { // do something to handle the error } It would help much if you posted the exact error message (error message text including variable names, line …

EvolutionFallen's approach has one advantage. The result already contains the data for the user in question so if you need it you do not have to shoot another query. The `*` in the query should be replaced with the fields you really need. Atli's approach is slightly more optimized but …

The way I would approach this is exactly what you suggested - a good old traditional tree structure saved in a relational database (which mysql is). Relational databases are good at processing this kind of data, all the rest depends on the way the site would be used. If a …

What will be the purpose of the site?

It says that $wpdb is not an object so you can not address a method of it. Has $wpdb been initialized as a database object somewhere?

Use three different names for submit buttons. Then in the processing part of the code check which submit button has been pressed: if(isset($_POST['submit_delete'])) { //code for deleting } elseif(isset($_POST['submit_add']) { // code for adding } elseif(isset($_POST['submit_update']) { // code for updating }

Do you have any errors? If yes, post them.

The likely cause of the error is missing POST data. You are nicely doing a check on the beginning: if (isset($_POST['username']) && isset($_POST['password']) && isset($_POST['email'])) but you forgot the starting curly bracket after the statement: if (isset($_POST['username']) && isset($_POST['password']) && isset($_POST['email'])) { ... You can also use simple debugging techniques …

I used [Datatables](http://datatables.net/) a lot in my previous project and it covered all I needed (sorting, filtering, pagination, ajax, formatting, theming, language customization, sorting by date in many formats, sorting IP addresses etc.). I highly recommend it.

The [PHP manual](http://php.net/manual/en/function.mail.php) will answer most of your questions. This is what it says for mail function: bool mail ( string $to , string $subject , string $message [, string $additional_headers [, string $additional_parameters ]] ) $to - Receiver, or receivers of the mail $subject - Subject of the email …

The key info here is the product ID which is supposed to be stored in $_prod_id. But where do you get the value of $prod_id from (you use it in the query on line 17)?

Good editors support at least syntax coloring / highlighting for popular tools (PHP, Javascript, CSS, SQL, configuration files), indent code, suggest syntax, check parentheses, support various character sets, organize files etc. I use Notepad++ on Windows and KWrite on Linux. IDEs are a step forward by also helping you to …

This is not the whole code. What is before the forst curly bracket? At the above snippet the closing curly bracket is a stray one.

Thanks for the recommendation. I have read many books about PHP but none about team development, which is where I have lack of experience.

You will usually get the selected ID upon submiting the form. The selected value will be stored in either $_GET or $_POST global array, depending on the method, defined in the <form> tag. So in your code you have to check for submission of the form using this pattern: if(isset($_POST['submit'])) …

Also check if all input values exist. You are using these values in queries and if user did not enter all of them you will get strange results. // check if anything was entered (you might apply other checks and validations) if(isset($_POST['firstName']) && !empty($_POST['firstName'])) { // if yes, trim the …

You are missing an anchor text and closing tag for anchor element. Also enclose the string in double quotes to parse the variables. Consenquently you have to escape double quotes that surround html attribute values: echo "<div><a href=\"uploads/$image\">$image</a></div>"; or use single quotes for enclosing html attribute values: echo "<div><a href='uploads/$image'>$image</a></div>";

Your insert query syntax is a bit strange. The basic syntax would be: INSERT INTO tablename (field1, field2,...) VALUES (value1, value2, ...) so in your case $q1 = "INSERT INTO job_employer_info (ename, epass, CompanyName, CompanyCountry, CompanyState, CompanyZip, CompanyCity, CompanyAddress, CompanyPhone, CompanyPhone2, CompanyEmail) VALUES( '$ename', '$epass', '$CompanyName', '$CompanyCountry', '$CompanyState', '$CompanyZip', '$CompanyCity', …

I am not sure if I understood your problem correctly but there are some thoughts: 1. Put the mysql_connect and mysql_select_db outside the loop, somewhere on the beginning; it is preferred to execute this code only once 2. check for the existence of each $array element, since the data comes …