Jump to content

resting

Members
  • Posts

    23
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

resting's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. oh erm..i'm just using svn to help me sync between my laptop and pc using a thumbdrive. i never looked into how to setup a svn server for multi users to use. and the designer does not even know how to use svn so ya...
  2. I think this is quite a common question? How do I send POST data from one script to another? I'm doing this login page which POST with form to a processing script. And if the authentication fails at the processing script, it should POST back an error message to the login page.
  3. i'm using Rapid PHP 2010 now. cool. its just like PHP Designer but loads a lot faster. no code folding but well, i'm loving the code explorer, and fast loading. never try the debug though.
  4. i am using subversion. but the web designer isn't. basically he just send me the layout he did and i'll do all the merging and stuffs with the backend. whenever he changes the layout, i'll have to figure out what he changed. a folder comparison will show what files he changed. and a file merger will make my job of merging them a lot easier.
  5. As above? Its kinda irritating when the designer keeps changes things. I think a comparison between folders and files will help a lot. Any free ones out there?
  6. This is the result if i used 1' or '1' = '1 The escaped query passed and still found 2 records (which is all i entered for the database). I paste the exact escaped query into mysql query browser. strange thing is it didn't manage to find any rows.
  7. for your first problem, if you just want to display 2 fields, change your query to this: $result = mysql_query('SELECT * FROM jobs LIMIT 2', $con); for your second problem, a simple way to do it is this: echo "<a href='" . $_SERVER['PHP_SELF'] . "?id=" . $id . "&action=delete'">Delete</a> This link is supposed to be generated dynamically where the $id value correspond to the row you want deleted. if your current page is link.php and the $id is 1, then when parsed it will become: <a href='link.php?id=1&action=delete'>Delete</a> Your link.php will have to contain this code to process the delete if($_GET['action'] === 'delete'){ $query = 'DELETE FROM table WHERE id = $_GET['id']; $result = mysql_query($query); } I'm not sure if its secure if done this way though.
  8. I seem to remember I'd read somewhere that we should escape all user input to prevent SQL injections. I did a test, but found no difference to it. The query $query ="SELECT * FROM login WHERE username = '$username' AND password = '$password'" ; Top portion shows the unescaped results. Bottom the escaped results. Both queries returned results. Any example to show what good can mysql_real_escape_string do?
  9. How do we store chinese characters in mysql?
  10. you might want to try searching for customer relationship management for php. thats all i know at my level
  11. i guess this is more to javascripting. good news is, you may find what you need http://www.dynamicdrive.com/
  12. not sure if i get you right. your 1st problem is more about the presentation of the page? if thats the case you just modify the <td> tags in your script to suit your liking. as for your second problem, you mean you want to delete a row from the database table? in that case use DELETE FROM tablename WHERE condition. you can search google for mysql delete for more information.
  13. yes it'll be a database system. a cms actually. i think the link will help thanks. but i always welcome more sources
  14. http://www.aptana.com/ studio is a free php ide with debugger. Eclipse ide is free too. but these 2 are imo slow to load. phpED is fast but comes with a cost. phpDesigner looks nice but is slow too.
  15. As above. Any articles or examples to show the setup needed?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.