Menjanje tipa podatka i cena motora (Changing the data type and motobikes prices)

Da bi promenila cene koje su automatski bile na 99.99, koje ce nam trebati za primer u sledecem clanku, promenila sam tip podatka i duzinu/vrednosti.

Korak 1 - promena tipa podatka i duzine/vrednosti.

1.  Otvorite phpmyadmin tako sto cete pokrenuti XAMPP. Kliknite na Admin u liniji MySQL-a ili ukucajte u address bar http://localhost/phpmyadmin

2. Izaberite bazu podataka volimmotore. Kliknite na tabelu motori.

3. Kliknite na karticu Structure. 

4. U liniji cene kliknite na Change, i za tip podatka umesto float izaberite int. Za duzinu/vrednosti, umesto 4,2 stavite 5.  Klik na dugme Save.  Ili neki drugi broj zavisi za sta ste napravili bazu podataka, tj. onoliko koliko vase cene imaju cifara.

Korak 2 - menjanje cena

1.  Izaberite bazu podataka volimmotore. Kliknite na tabelu motori.

2. Kliknite na Edit i u redu cena zamenite odgovarajucu cenu. Moze da kliknete na prvo dugme "Go" kao na slici ili da ako su vam izabrana polja Save i Go back to previous page izaberete drugo dugme "Go".

Ovak korak ponovite onoliko puta koliko imate proizvoda.

In order to change the prices that have been automatically at 99.99, which we will need for example in next article, I changed the data type and length/value.

Step 1 - change the data type and length/value.

1. Open phpmyadmin by running XAMPP. Click on the Admin in line MySQL or type in the address bar http://localhost/phpmyadmin

2. Select the database lovebikes. Click table motobikes.

3. Click on the tab Structure.

4. In line price, click Change, and for the data type instead of float select int. For length/values, instead of 4.2 put 5. Click on the Save button. Or put another number depends for what you have created a database, that is, as much as your prices have digits.

Step 2 - changing prices

1. Select a database lovebikes. Click table motobikes.

2. Click on Edit and change with suitable price. You can click the first button "Go" as in the picture or if you have chosen fields and Save and Go back to previous page click second button "Go".

Repeat this step as many times as you have a products.