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 …

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 …

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

<?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 * …

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/)

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 …

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')) …

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 …

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 ?

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' …

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()); } …

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'] . ""; ?>

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> …

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 …

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 …

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....

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

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);

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>" . …

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 = " …

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 …

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{ …

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 …

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 …

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); …

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 ? …

123

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 …

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 ?

hy i have this collums and what i'm trying to do is to 1.make a search form that can show me the total of the values table q1(the sum) for example that i whant to chose a category wich it have same name at collum but different id, this is …

hy i have question i have this code and i whant to print it one by one not all the page the script is <?php $qry=mysql_query("SELECT * FROM articles order by articles.id DESC ", $con); if(!$qry) { die("Query Failed: ". mysql_error()); } /* Fetching data from the field "title" */ …