So here's a little background to help with what I'm trying to accomplish (be mindful I'm also fairly new to MySQL): I'm creating a dynamically built navigation for a website using PHP and MySQLi. I've created a class called *Database* where I've got helper functions, such as connect() for connecting to the database, and the like. Then I have another class called *Navigation* which extends *Database*, and there I'm creating helper functions to do specific things for the database that holds my navigation links, such as selecting and inserting and so on. Now, the following code works flawlessly when working …

Member Avatar
Member Avatar
+0 forum 9

Hi, I want to replace ticks in text with other text. This method usually works, but when adding three dots, I get php warning ltrim(): Invalid '..'-range, no character to the right of '..' or invalid range needs to be incrementing. I don't know where to look for error, except deleting dots. Here is the code: $code = "some text before block ´´´´code block1´´´´ text after block ´´´´code block2...´´´´"; // I want ticks to be replaced to this: <pre><code> code block1 </code></pre> $pattern = "´´´´"; // we are using ticks $countCodeBlock = substr_count($code, $pattern); // count how many times pattern …

Member Avatar
Member Avatar
+0 forum 4

Hello, Recently I am using phpexcel and afer many tries I wasn't able to find out how to make a document with a image in its header. Here is a simplified code that I am using. Can someone helps me with this issue?! <?php require_once 'PHPExcel.php'; $objPHPExcel = new PHPExcel(); $objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing(); $objDrawing->setPath('header.jpg'); $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_HEADER_RIGHT); $objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader("&C&G"); $objPHPExcel->setActiveSheetIndex(0)->setCellValueExplicit('A1', 'CODICE PRATICA'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); $objWriter->save('test.xlsx'); ?>

Member Avatar
Member Avatar
+0 forum 4

Got Client with need of **"online print shop"** Client is providing paper printing (like business cards, flyers), printing on cloths, office stationary, logo embroidery on any type of clothing. Client provided some examples. **Links** * [rockdesign](https://www.rockdesign.com/) * [moo](https://www.moo.com/ca/) * [readyprint](https://www.readyprint.ca/) * [vistaprint](https://www.vistaprint.ca/) * [printshop](https://printshop.ca/) * [printvenue](https://www.printvenue.com/) **Where do I start?** Which platform should I choose? 1. CorePHP 2. Wordpress 3. WooCommerce 4. Magento 5. Prestashop 6. WordPress Is there any plugin or script that should I go for???

Member Avatar
Member Avatar
+1 forum 13

Write a PHP code to: 1- Create a 2-dimensional array, with a random number of rows and columns. 2- Fill the array with random numbers. 3- Send the array to a function that returns the number of the highest frequency in the array. Who can help me to solve it?

Member Avatar
Member Avatar
+0 forum 4

inside mysql db which is table employe in coloumn *id_employee*, some data have a leading zero, etc : **id_employee : 0378192918 empy_name : Daniweb** i need to get id_employee for delete employe in my aplication, then i using ajax method like this : if(id) { alert(id); $("#deleteBtn").unbind('click').bind('click',function(){ $.ajax({ url: 'pegawai/delpeg.php', type:'post', data: {emp_id : id}, datatype: 'json', success:function(response) { return value is **378192918**, the first number **0** not showing in alert box. why ? then how to get entire value id_employe from db ?

Member Avatar
Member Avatar
+0 forum 8

hi, i have installed XAMPP, but i would like to run my localhost from another computer..

Member Avatar
Member Avatar
+3 forum 14

Hi, I have a problem with retrieving uploaded images from a database. It appears to upload fine, but when i try to display the image i get loads of binary jargon? I have tried looking everywhere for a solution, but unable to, any help would be greatly appreciated. The code for uploading is [code] include ("database.php"); if(isset($_POST['Submit'])) { if(isset($_FILES['image'])) { /* Upload file from anywhere and put in a set temp dir */ $image = file_get_contents($_FILES['image']['tmp_name']); $image = mysql_real_escape_string($image); $handle = fopen($image, 'rb'); // read binary $contents = fread ($handle, filesize ($image)); //$contents = addslashes($contents); fclose ($handle); $description = $_POST['description']; …

Member Avatar
Member Avatar
+0 forum 13

Hello, So I have buttons on my site connected to a PHP code that updates the column "status" in "users" table with a value based on what button you press. This is the PHP script for that: <?php include('functions.php'); $servername = "localhost"; $username = "root"; $password = ""; $dbname = "emildeveloping"; // Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } $id = $_SESSION['user']['id']; if (isset($_POST['108'])) { $sql = "UPDATE users SET status = '10-8' WHERE id='".$id."'"; } if (isset($_POST['107'])) { $sql = "UPDATE users SET status = '10-7' …

Member Avatar
+0 forum 0

I'm somewhat new to coding websites. I'm trying to have a code where it pulls multiple images from a single database and displays it in a grid, not a table. At the top of my page I have a normal connection to the database. (very sorry about not having a code snippet, I'm new to daniweb and keep having errors when trying to use code snippets.) <div id="grid" class="grid-container"> <?php while ($row = mysqli_fetch_array($query)) echo '<div class="grid-item"> <p>'.$row['images'].'</p> <p>'.$row['project'].'</p> <p>'.$row['summary'].'</p> </div>'; ?> </div>

Member Avatar
Member Avatar
+0 forum 1

Hello i have a mysql statement and i want to add more parameters to get different results. SELECT DISTINCT M.message,F.friend_one,F.friend_two, F.role,U.uid,U.username FROM users U,friends F, messages M WHERE ( U.status='1' AND F.friend_one = '88') OR (F.friend_two='88' ) AND F.role='friend' 88 is the users id so i want to show M.message from friends of 88 but not 88 itself hints: when one is becoming friend with other friend_one is 88 -for example- and friend_two another user id or vice versa M table has id of user as a column of course

Member Avatar
Member Avatar
+0 forum 4

I realize that this question has been asked many times, but I've yet to find a flatfile version. I'm looking for a way to achieve this: **Scenario:** A person submits their email address via a form. The email is then stored in flatfile database (.txt) The person then gets an auto-reply email with a link to confirm their email address. Upon confirming after clicking the link, their email address is saved to a new file confirmed_emails.txt for example. Is this possible without the use of a SQL/similar datase, and how can I achieve this? Note: SQL or other database option, …

Member Avatar
Member Avatar
+0 forum 11

I have a form that uploads a news article with it's picture and then stores all the info correctly. I am using codeigniter with Active Record and would like to know how to display the image with the post it was uploaded with. here is my upload script: public function create(){ $data = array('error' => ''); $config = array( 'upload_path' => './uploads', 'allowed_types' => 'gif|jpg|png', 'max_size' => '204800', 'max_width' => '1920', 'max_height' => '1080', 'encrypt_name' => true ); $this->load->library('upload', $config); if(!$this->upload->do_upload()) { $error = array('error' => $this->upload->display_errors()); $data['title'] = 'Create a news item'; $data['main_content'] = 'news/create'; $this->load->view('templates/template', $data, $error); } …

Member Avatar
Member Avatar
+0 forum 4

$query = "INSERT INTO 'user-profiles' ('name', 'avatar', 'description', 'votes', 'pay_methods', 'location', 'user_id') VALUES ('sadj', 'qwesad', 'sadqwdqw', '0','sadsad', 'sadasdsad''4')"; $resultprof = $this -> conn -> query($query); votes and user_id are INT columns, and user_id is a foreign key. Making this insert on mySQL directly it works perfectly, but on my PHP the "success" is false....

Member Avatar
Member Avatar
+0 forum 5

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with. I am trying to make a page with an HTML form that will update my MYSQL database. You can view my pages online here: [URL="http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php"]http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php[/URL] I need help with the "Edit" section, if you look online. Here is the code for my Edit page: [CODE=PHP] <?php $hostname = "localhost";//host name $dbname = "baileyjumper_imd203";//database name $username = "baileyjumper_imd";//username you use to login to php my admin $password = "chris4ever";//password you use to login //CONNECTION OBJECT //This Keeps the Connection to the Databade …

Member Avatar
Member Avatar
+0 forum 20

whats the coding of combo box in php????????? can any one tell meplzzzzzz

Member Avatar
Member Avatar
-1 forum 15

Hello good people, I am having an issue with including subreports, lists and table datasets in the main report using jasper reports since i want to include two separate sql queries in my report. I am using the same connection to my database for both the main report and the other dataset. The problem is that when i preview the report using the iReport designer it shows everything i want to see, but when i use the php-jasper library in my php script to call the .jrxml file and output a pdf it does not show the sub-report, lists or …

Member Avatar
Member Avatar
+3 forum 3

if its possible please give me instructions Thank you in advance

Member Avatar
Member Avatar
+0 forum 7

I have a table called download_manager .It has two columns filename and downloads .What I want to do is to get file name and its download count and display them inside ul element. I am able to get file names but I cant display the download count I'm getting undefined index error.This is my code <?php $handle = opendir($directory) or die('Error'); $files = array(); while ($file = readdir($handle)) { if ($file[0] == '.') { continue; } $files[] = $file; } sort($files, SORT_STRING); $query = 'select * from download_manager'; $data = mysqli_query($link, $query); $fileInfo[] = array(); if (mysqli_num_rows($data)) { while ($singleFile …

Member Avatar
Member Avatar
+0 forum 2

I would like to fill in the empty spaces of a csv column and its in one column using phpexcel I have added a demo for your viewing: The flow check B2 is its not empty go the next B3 if B3 is empty take value from B2. Here is demo: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <table width="200" border="1"> <tr> <td>Apple</td> </tr> <tr> <td>&nbsp;</td> </tr> <tr> <td>&nbsp;</td> </tr> <tr> <td>Banna</td> </tr> <tr> <td>&nbsp;</td> </tr> </table> <p>&nbsp;</p> <p>The final outcome</p> <table width="200" border="1"> <tr> <td>Apple</td> </tr> …

Member Avatar
Member Avatar
+0 forum 4

Without going into each of the products pages and setting sidebar to appear on left, how can I code it into the woocomerce product single page using php? http://www.mabridalplus.com/?product_cat=bridal-wear

Member Avatar
Member Avatar
+0 forum 4

I have a unix timestamp for each cooment in my database. I want to output the user date and time depending on their location, or timezone. How do I do that properly?

Member Avatar
Member Avatar
+0 forum 3

hi, I am stuck trying to figure out how to build a table to display agents names, (that I already have, mysql table etc...) but now I need to add columns dynamicaly. I need to add (programs in witch agents are enroled, and a status of the program ( in-progress, not-done, etc). The part that I can figure out is where would I save the status of the agent in the program. I have enroled-agents table: (id, name, email) displays a basic mysql-php-html table; then I have programs table: (id, name, description, avaiable-status) When i place them together, where how …

Member Avatar
Member Avatar
+0 forum 4

I have a database of pictures, and votes. The pictures database has up_votes and down_votes culomns. I want to create a system using MySQL to get hot and trending pictures just like 9Gag. How can I do that?

Member Avatar
Member Avatar
+0 forum 13

I have a table called `volume_issue` that looks like this: +----+-------------------------------------------------------+-----------------+-----------+---------------------+ | id | url | journal_title | issn | volume_issue | +----+-------------------------------------------------------+-----------------+-----------+---------------------+ | 1 | https://www.ajol.info/index.php/asan/issue/view/17048 | Africa Sanguine | 1560-8646 | Vol 19, No 2 (2018) | | 2 | https://www.ajol.info/index.php/asan/issue/view/16693 | Africa Sanguine | 1560-8646 | Vol 19, No 1 (2017) | +----+-------------------------------------------------------+-----------------+-----------+---------------------+ I am trying to extract all records associated with the urls listed in the variable url and insert them in a table known as `citations`. The code i am using to do this lookw like this: <?php $query1 = "SELECT * FROM volume_issue where …

Member Avatar
Member Avatar
+0 forum 10

Hello everyone. I have a string that looks like this (Mango, fruits, and), (Maize, cereals, and), (Mango juice, beverages, and) I would like to convert the above string using php to something similar to this: (Mango[fruits]) AND (Maize[cereals]) AND (Mango juice[beverages]) How can i achieve this in php. I have looked at PHP string replace, substr functions but cannot figure out how to use them to solve my problem. Thanking you in advance

Member Avatar
Member Avatar
+0 forum 27

I have a function that I need help with. The purpose of the function is to sort an array of objects by field. This function was using the PHP function create_function which is now deprecated in PHP 7.2. I've been trying to rewrite the function, but the results return null. Any help in figuring out what's wrong is greatly appreciated. function _list_sort(&$objects, $on, $order = 'ASC') { usort($objects, function(&$a,&$b) use($on, $order) { return ($order === 'DESC') ? strcmp($a[$on],$b[$on]) : strcmp($a[$on],$b[$on]); }); }

Member Avatar
Member Avatar
+0 forum 1

I have css animation for preloader. I need help to update content smoothly without redirecting page, using following functions $(window).on("popstate", function() { }); window.history.pushState({path: ""},"",""); Update link & content of next page after preloader progressbar animation ends `webkitTransitionEnd ` without redirecting to page. Need help to complete following functions function changeUrl() { } function updateContent() { } ## Html/CSS/Js code (jsfiddle links) ## [after adding 'loading' class to body tag](https://jsfiddle.net/cnv1drx8/1/) ([Full Window](https://fiddle.jshell.net/cnv1drx8/1/show/)) [after removing 'loading' class from body tag](https://jsfiddle.net/v3arfeum/1/) ([Full Window](https://fiddle.jshell.net/v3arfeum/1/show/))

Member Avatar
Member Avatar
+0 forum 3

Hello, I am looking for a new IDE. I am currently using netbeans to develop a website in php/mysql. I like a lot of things about netbeans, but I don't like that it doesn't come with built in compilers/debuggers. You have to manually go and add/link them on a language-by-language basis. This isn't too bad in theory, but sometimes it doesn't work like it should, which can cause a huge headache. I had a hell of a time getting a debugger to work for php. I am now adding javascript/jquery to the website, and discovered that the debugger I already …

Member Avatar
Member Avatar
+0 forum 3

Hi, I am a legacay (cobol) developer and wants to learn how to build websites. For this I decided to do a little project for myself. The site would be a places/travel tracker kind. It would show a certain map (ex, London, Taiwan, Greenland). Then you can click on a city on the map which will show pictures/videos/comments of you in that city. Map changes color for the city you have visited or maybe a pin. I have search the web and mostly there are world tracker. I would want a country based one. So my questions are: 1.) What …

Member Avatar
Member Avatar
+1 forum 4

The End.