Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

~7K People Reached
Favorite Tags
Member Avatar for bolfescu

Hy i'm having a problem with my php excell, i'm having two rows in mydb, but he export only one row from db, if i will insert the thrd row in db it will show me always two.... this is the code require_once 'Classes/PHPExcel.php'; $objPHPExcel = new PHPExcel(); // Set …

Member Avatar for bolfescu
0
158
Member Avatar for bolfescu

Hy, i'm having a problem with php excell, i have in my db a row that its have a full url, when i export it its not make it HYperlink, i've see the docs on the internet but unft its for only one cell not for entire column this is …

Member Avatar for broj1
0
574
Member Avatar for bolfescu

Hy i'm using php excell to export some data from my db, one of the collum have full path of a image, instead of show me the path it is possible to make a link? like <a href="row[photo]">Link</a> ? i've tryied to search but nothing...i'm using the lasted phpexcell class

Member Avatar for broj1
0
383
Member Avatar for bolfescu

<?PHP include('config.php'); function cleanData(&$str) { $str = preg_replace("/\t/", "\\t", $str); $str = preg_replace("/\r?\n/", "\\n", $str); if(strstr($str, '"')) $str = '"' . str_replace('"', '""', $str) . '"'; } // filename for download $filename = "Piante_" . date('Ymd') . ".xls"; header("Content-Disposition: attachment; filename=\"$filename\""); header("Content-Type: application/vnd.ms-excel"); $flag = false; $result = mysql_query("SELECT * …

Member Avatar for bolfescu
0
578
Member Avatar for bolfescu

hy im using this script but unf cant find the bug related to update the values, its keep telling succesuful update but dsnt update in db...[Click Here](http://www.script-tutorials.com/datatables-data-from-ajax-edit-in-place/)

Member Avatar for bolfescu
0
216
Member Avatar for bolfescu

hy i'm using this code, but after submit it sometimes works sometimes dsnt, why? $max = mysql_query("SELECT MAX(id2) FROM articles",$con); $max3 = mysql_query("SELECT MAX(id) FROM articles",$con); $resultsmax = mysql_fetch_array($max); $resultsmax3 = mysql_fetch_array($max3); $cur_auto_id =$resultsmax['MAX(id2)'] + 1; $cur_auto_id2 =$resultsmax3['MAX(id)'] + 1; ....... $qry= mysql_query("SELECT * FROM category", $con); while($row=mysql_fetch_array($qry)) { echo …

Member Avatar for diafol
0
90
Member Avatar for bolfescu

hy i'm using this search, but unfort not working if i will search by both f.name l.name... this is the code if (Input::has('name')) { $name = Input::get('name'); $name = T_entity_details::where('First_Name','LIKE','%'.$name.'%') ->where('Last_Name','LIKE','%'.$name.'%','or') ->where('Entity_Id','!=',$this->userId) ->get(array('Entity_Id')) ->toArray(); $array1 = []; foreach ($name as $value) { array_push($array1, $value['Entity_Id']); } }else{ $name = T_entity_details::where('Entity_Id','!=',$this->userId) ->get(array('Entity_Id')) …

Member Avatar for bolfescu
0
99
Member Avatar for Sutarusu

Hello everyone. I have setup a website and the common.php is configured but the site seems to not be linking to the database. For example, if I mouse over a link mydomain.com/details.php?id=1 and click the link it takes me to mydomain.com/details.php and says no results found. In the database it …

Member Avatar for Sutarusu
0
186
Member Avatar for bolfescu

hy i'm having problem with this mysql qry, i dont whant to insert in the db if its empty the field, ive tryied with is NULL, but its not working... $qry=mysql_query("INSERT INTO trans_autista (autista, ditta) SELECT * FROM (SELECT '$trans_autista', '$cat') AS tmp WHERE NOT EXISTS ( SELECT autista FROM …

Member Avatar for bolfescu
0
217
Member Avatar for bolfescu

Hy i'm using $_GET function to a variable and after make a query, but when i simply trying to display that variable, is not the full text...is less and then thats why dsnt work the query...how can i fix it ?

Member Avatar for bolfescu
0
87
Member Avatar for bolfescu

i'm having a problem trying to change an old script echo '<td style="text-align:center;vertical-align:middle;">'.$row['CarrelliCC'].'</td>'; i'm showing the result in a loop in a form, i have a problem to create a script that can email to a specific email adress with that result this is the second submit button <input type='submit' …

0
90
Member Avatar for bolfescu

hy, i'm having a big problem, thats because i'm new in this, i have two qrys unfort doesnt work if(isset($_GET['id'])){ $id=$_GET['id']; $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles WHERE id='$id'", $con); $sql = mysql_query("select *,Total17,sum(q5) Total18,sum(aste3) Total19 from articles where category= how ?",$con); if(!$qry){die("Query Failed: ". mysql_error()); } …

Member Avatar for Traevel
0
171
Member Avatar for bolfescu

I have this sqlqry, icarrelli have the value 0 and the q2 value 64(sum) why the result is 64 and not -64? <?php $result = mysql_query("SELECT *,iCarrelli-SUM(q2) as total9 FROM articles,inc"); $row= mysql_fetch_assoc($result); echo "" . $row['total9'] . ""; ?>

Member Avatar for pritaeas
0
91
Member Avatar for bolfescu

hy, unfor its not showing nothing...what it is wrong...? <?php include('config.php'); error_reporting(0); ?> <table border=1> <tr> <td rowspan="3">Ditta</td> <td colspan="6">mandatori riceve</td> <td colspan="6">mandatori consegna</td> <td colspan="6">saldo</td> </tr> <tr> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> </tr> <tr> <td>carrelli con piastra luc.rosso</td> <td>carrelli con piastra luc.nero</td> …

0
76
Member Avatar for bolfescu

Hy i have this table, unfort i dont know how to retrieve the data from sql and to put it one under each one i have all the 18 tablesi whant to do something like this: (id1) 2 3 4 5 6 7 8 ..... (id2) 2 3 4 5 …

Member Avatar for bolfescu
0
148
Member Avatar for bolfescu

Hy ihave this phpcode, how can i paginate this?to make more pages from the sql results... because i have a lots of rows... <?php $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles ORDER by articles.id DESC ", $con); if(!$qry) { die("Query Failed: ". mysql_error()); } /* Fetching data from …

Member Avatar for pritaeas
0
107
Member Avatar for bolfescu

Hy how can insert in this echo function, return confirm ? echo "<input type='submit' name='submit' id='submit' class='btn btn-primary' value=Cancella onclick=window.location='delete_article.php?id=".$row['id']."'; /></p>"; i've already have onclick....

Member Avatar for mattster
0
783
Member Avatar for bolfescu

Hy i have a db with 1 collum(with 20rows) i whant to create a custom table view of this database with the sum at the end of the table but with custom search function, i cand find an script to do this for me? Thanks

Member Avatar for AndrisP
0
193
Member Avatar for bolfescu

hy im using to show this qry $qry = mysql_query("SELECT * ,replace(category, ',', ' ') as category FROM articles ORDER BY ID DESC LIMIT 1"); how can adapt to this qry? $qry=mysql_query("INSERT INTO category(category) VALUES('$cat,$cat3,$cat2')", $con);

Member Avatar for pritaeas
0
146
Member Avatar for bolfescu

Hy i have two tables articles and iniziale, articles have a collum c2,and iniziale have c1 i whant to do like this c1(whic its have one value only)- sum(c2)(entire collum) ive tryied like this but nothing...:( <?php $result = mysql_query("SELECT *,SUM(iCarl)-SUM(CarrelliCC22) as total2 from articles,iniziale"); $row= mysql_fetch_assoc($result); echo "<h4>" . …

Member Avatar for bolfescu
0
194
Member Avatar for bolfescu

Hy io have this php script(if you can call php script) anyway i whant that every result to show it one down the another(mysql grid table) but with that kind of search....i've tryied but unf nothing.... this is the "code" <?php $i = 0; if ($_REQUEST["string"]<>'') { $search_string = " …

Member Avatar for pritaeas
0
195
Member Avatar for bolfescu

Hy i have a problem with printing, im trying to print only the part of invoice but i cant handle it, ive tryied css to hide the others div but still not success, show a blank page after..this is my code thank you... <?php include('config.php'); error_reporting(0); ?> <!DOCTYPE html> <html …

Member Avatar for cereal
0
398
Member Avatar for bolfescu

Hy i have this js code: <script type="text/javascript"> var msg_id; @if(Session::has('message')) {{"msg_id = ".Session::get('message').";"}} <?php Session::forget('message'); ?> @endif $(function(){ jQuery.each( inbox, function( i, val ) { $('#contact_'+val).parent().addClass('inbox'); }); jQuery.each( others, function( i, val ) { $('#contact_'+val).parent().addClass('others'); }); $(".others").addClass('hide'); $("#inbox").removeClass('bg-inverse').addClass('bg-primary'); if(msg_id){ console.log(others); if($.inArray(msg_id.toString(),others)>-1){ $('#others').trigger('click'); } $('#contact_'+msg_id).trigger('click'); }else{ if(inbox_1.length>0){ if(others_1.length>0){ $('#contact_'+inbox_1[0]).trigger('click'); }else{ …

Member Avatar for mattster
0
152
Member Avatar for bolfescu

Hy i have a search that now its works only if write or the first name or the last name, both didnt work....fn+ln....what i need to change?...ive tryied JOIN but nothing... if (Input::has('name')) { $name = Input::get('name'); $name = T_entity_details::where('First_Name','LIKE','%'.$name.'%') ->where('Last_Name','LIKE','%'.$name.'%','OR') ->where('Entity_Id','!=',$this->userId) ->get(array('Entity_Id')) ->toArray(); $array1 = []; foreach ($name as …

Member Avatar for bolfescu
0
194
Member Avatar for bolfescu

Hy now i have this code <div class="row"> <div class="col-xs-12 col-md-6 left"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-primary" href="{{URL::route('displayProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-visual-eye-fill icon"></i>1</a> @else <button type="button" class="btn btn-sm btn-primary view-profile" profile-id="{{$profile->Entity_Id}}"> <i class="icon-visual-eye-fill icon"></i>not</button> @endif </div> <div class="col-xs-12 col-md-6 right"> @if(in_array($profile->Entity_Id,$likes)) <a class="btn btn-sm btn-info" href="{{URL::route('messageProfile',array('profile_id' => $profile->Entity_Id))}}"> <i class="icon-envelope-fill-1 …

Member Avatar for pritaeas
0
116
Member Avatar for bolfescu

Hy i have a part of my html page that is like this <div class="menu-wrapper"> <ul class="menu"> <li><a class="show-2" href="#">1</a></li> <li><a class="" href="#">2</a></li> <li><a class="show-4" href="#" onclick="templatemo_map();">3</a></li> </ul> <!-- /.menu --> <a href="#" class="toggle-menu"><i class="fa fa-bars"></i></a> and the part of js that im intereset /************** Toggle Menu *********************/ $('a.toggle-menu').click(function(){ $(".menu").slideToggle(400); …

Member Avatar for hericles
0
95
Member Avatar for bolfescu

hy i have a php script that its insert my sql db row two values,after i make the request to show that row $row.name. its show like this valueone,valuetwo with , its is possible to show that two values on that row one down to another like valueone, valuetwo ? …

Member Avatar for ryantroop
0
48
Member Avatar for bolfescu
Member Avatar for bolfescu

Hy i have this sql query.. how can i combine with the next one ?... this $sql = "select id,date,category,sum(q1) Total,sum(q2) Total2,sum(q3) Total3,sum(q4) Total4,sum(q5) Total5,sum(q6) Total6 from articles group by category order by id"; with $sql = "SELECT * FROM articles WHERE from_date >= '".mysql_real_escape_string($_REQUEST["from"])."' AND to_date <= '".mysql_real_escape_string($_REQUEST["to"])."'".$search_string.$search_city; as …

Member Avatar for urtrivedi
0
153
Member Avatar for bolfescu

HY I HAVE THIS SQL CODE select id,category,sum(q1) Total from articles group by category order by id AND I WHANT TO INTEGRATE IN MY PHP SCRIPT TO SHOW IT LIKE A TABLE INCLUDING THE TOTAL, HOW CAN I DO THIS ?

Member Avatar for veedeoo
0
63