inventory solution with MySql

Science & Technology Information Technology, Gaming, Machines, Gadgets
1

i’ve been playing around with php/mysql apps and am really impressed. i tried looking for some inventory tracking solution on sourceforge, but they’re all a little too complex for my needs (basically aimed at businesses).

i wanted to find something that’ll let me add fields like

first name/ last name / username / password / Computer Model / CPU / Ram / … etc

using a web interface.

I’ve made my database in mysql (using phpmyadmin), but I guess the web interface has to be coded in php. Doing everything in PHPmyadmin isn’t really the best option. Is there anyway around it?

Do you have any ideas on what I should do/use. The more I play with this, the more I’m interested in learning mysql, and php, but I don’t have the time these days to do that ..

oh, and if anyone was following my previous posts, about surveys and stuff, I finally managed to get everything working. Now, I have a fully functioning webserver/ mail server / surver app / …

2

Re: inventory solution with MySql

I agree, phpmyadmin isn’t the best tool to work with. There’s a very nice alternative, and its free :slight_smile:

MySQL Front:
http://www.mysqlfront.de/

guys or girls
3

Re: inventory solution with MySql

a nice and simple way to enter data from a webpage to mysql db:

Make a table with following 3 fields in mysql:

  1. id [AUTO_INCREMENT]
  2. name
  3. lname

create a php page with following code.

<? 
if($_POST'submit'])
{
   mysql_connect("localhost","root",""); 
   mysql_select_db("zee"); 
   $name = $_POST'name'];
   $lname = $_POST'lname'];
   $result=MYSQL_QUERY("INSERT IGNORE INTO aaa (id,name,lname)".
	  "VALUES ('NULL', '$name', '$lname')"); 
   echo "done.."; 
}
else
{ ?>
<form method="post" action="">
<INPUT TYPE='TEXT' NAME='name' VALUE='' size=60>
<INPUT TYPE='TEXT' NAME='lname' VALUE='' size=60>
<INPUT TYPE="submit" name="submit" value="submit">
</form>
<?
}
?>

u can find useful tutorials of php at http://php.resourceindex.com/

4

Re: inventory solution with MySql

web interface has to be coded in php? Are you talking about phpmyAdmin? I don’t remember doing any coding as such?

5

Re: inventory solution with MySql

There are lots of good tutorials on the net about configuring php and MySql to do what u need to do. Here’s one link:

Other than that there are a few applications that automate creating a php web interface, can’t think of the name right now. Let me know if you’re interested and I can find it for you.

6

Re: inventory solution with MySql

thats what i want / a web interface. found a few on sourceforge, but they didn't really cut it ... i'll check out the links provided ...

thanks everyone ...

7

Re: inventory solution with MySql

Here’s the application that i was talking about earlier. Its called the PHPMaker:
http://www.hkvstore.com/phpmaker/
Very easy to use, worth the $80 if you decide to purchase it.

Pare hojao Mundiyo
8

Re: inventory solution with MySql

i'll check them out .. thanks