Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //dynamic design(TextBox)
- function TekstBox($text, $boxR, $boxG, $boxB, $boxO, $textcollor,$textsize, $textalgin, $boxborder, $position)
- {
- $row=array();
- $nc = 0;
- $novired = "";
- $newline = 0;
- for($a=0;$a<=substr_count($text, "</br>"); $a++)
- {
- $row[$a]=0;
- }
- $br = "";
- for($r=0; $r <= substr_count($text, "</br>"); $r++)
- {
- for($i=$newline;$i<=strlen($text);$i++)
- {
- //</br>
- if($i <= strlen($text)-6)
- {
- $br = "";
- $br = $text[$i].$text[$i+1].$text[$i+2].$text[$i+3].$text[$i+4];
- }
- $newline ++;
- if($br == "</br>")
- {
- break;
- }
- else
- {
- $row[$r] ++;
- }
- }
- }
- str_replace("`", "</br>", $text);
- $brow = $row[0];
- for($r=0; $r <= substr_count($text, "</br>"); $r++)
- {
- if($row[$r] > $brow)
- {
- $brow = $row[$r];
- }
- }
- $px = ($brow*$textsize)/2;
- $pxx = $px."px";
- //padding-left:20px;padding-right:20px; bottom: 20px;
- echo "<div style=' text-align: $textalgin; font-size: $textsize; width: $pxx; background-color: rgba($boxR, $boxG, $boxB, $boxO); border: $boxborder; font-weight: bold; color: $textcollor; float: $position; '>
- $text
- </div>";
- }
- //load buttons with array and links in form , also dynamic
- function Ucitaj()//Load() on Bosnian
- {
- $Polja = array(
- array('Prodaja', 'Duplikati', 'Izvjestaji', 'Postavke'),
- array('submit','submit','submit', 'submit')
- );
- for($i=0;$i<sizeof($Polja[0]);$i++)
- {
- echo "<form method = 'GET' action = '".$Polja[0][$i].".php'>";
- echo "<input type = 'submit' name ='".$Polja[0][$i]."' value = '".$Polja[0][$i]."'/> </br>";
- echo "</form>";
- }
- }
- //more something with databse
- /*
- require_once "func.php";
- session_start();
- $sacuvaj = array();
- Postavke();
- echo $_SESSION[1];
- */
- $add = 0;
- $servername = "localhost";
- $username = "root";
- $password = "1234";
- $database = "fakture";
- $conn = mysqli_connect($servername, $username, $password);
- $sacuvaj = array();
- $Polja = array(
- array('FirmaID','Firma', 'Vlasnik','Suvlasnik' ,'P_Stopa', 'Sacuvaj'),//name
- array('number', 'text', 'text', 'text', 'number', 'submit'),//type
- array('FirmaID', 'FirmaNaziv', 'FirmaVlasnik', 'FirmaSuvlasnik','2', 'Sacuvaj'),//value
- array('FirmaID', 'FirmaNaziv', 'FirmaVlasnik', 'FirmaSuvlasnik','FirmaPDV', 'Sacuvaj ')//MySQL
- );
- $b=0;
- echo "<form method = 'POST' action = 'Postavke.php'>";
- for($i=0;$i<sizeof($Polja[0]);$i++)//pravljenje forme html
- {
- echo $Polja[0][$i].": ";
- echo "<input type = '".$Polja[1][$i]."' name ='".$Polja[0][$i]."' value = '".$Polja[2][$i]."'/> </br>";
- //echo $Polja[2][$i].",".$Polja[0][$i].",".$Polja[1][$i];//check
- }
- echo "</form>";
- for($i=0;$i<sizeof($Polja[0]);$i++)
- {
- //$Polja[2][$i] = "0";//Ucitavanje iz baze
- }
- //napraviti da se sprema sa MySQL
- $valuesstring="";
- $mysqlvariables="";
- for($i=0;$i<sizeof($Polja[0]);$i++)
- {
- if($Polja[1][$i] == 'submit')//Provjera za submit
- {
- if(isset($_POST[$Polja[0][$i]]))
- {
- for($b=0;$b<sizeof($Polja[0]);$b++)
- {
- echo $Polja[0][$b].': '. $_POST[$Polja[0][$b]]. "</br>";//Prikazivanje iz polja
- if($b == 0)
- {
- if($Polja[1][$b] == 'text')
- {
- $mysqlvariables .= $Polja[3][$b];
- $valuesstring .= "'".$_POST[$Polja[0][$b]]."'";
- }
- else if($Polja[1][$b] == 'number')
- {
- $mysqlvariables .= $Polja[3][$b];
- $valuesstring .= $_POST[$Polja[0][$b]];
- }
- }
- else
- {
- if($Polja[1][$b] == 'text')
- {
- $mysqlvariables .= ','.$Polja[3][$b];
- $valuesstring .= ","."'".$_POST[$Polja[0][$b]]."'";
- }
- else if($Polja[1][$b] == 'number')
- {
- $mysqlvariables .= ','.$Polja[3][$b];
- $valuesstring .= ",".$_POST[$Polja[0][$b]];
- }
- }
- }
- }
- }
- }
- /*TESTING MySQL
- echo "INSERT INTO fakture.firmapodaci(".$mysqlvariables.")";
- echo "</br>";
- echo "VALUES ($".$valuesstring.")";
- */
- $additem =mysqli_query($conn, "INSERT INTO fakture.firmapodaci($mysqlvariables)
- VALUES ($valuesstring)");
- echo "</br>";
- echo $conn->error; //SHowing errors
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement