how to fetch cricket scorecard to mysql database automatically for customization. i m planning to develop a game based on cricket. actually i am using php mysql database for it. i want complete cricket scorecard to mysql database automatically for customization. I m using snoopy class for content fetching from live scorecard site, however, there seems to be some techinical limitation in snoopy. It fetches the scorecard from given website but I want to save data in database and snoopy picks up the data character wise, however, the payer names keep changing I want to fetch player name, how he …

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
+0 forum 8

Hi fellas, I hope my first message here comes across more helpful than bothering. I’ve recently launched a WordPress backup plugin - WPvivid Backup/Restore. It contains pretty all basic features that you’ll need to backup/restore you site and is fairly easy to use. And most important, it’s completely free(free update and support). I made it because I realized that there’s still a growing need for the easier and more affordable backup solutions in WordPress community, we hope our plugin can give people a hand. Please check it out at WordPress’ plugin repository: https://wordpress.org/plugins/wpvivid-backuprestore/ Any feedback will be greatly appreciated. Joe

Member Avatar
+0 forum 0

I have a script that populates a form from MySQL database table row for editing. I'm performing MySQL SELECT and UPDATE via PDO. After editing a particular table row and clicking on the submit button, the table row doesn't update. The following is "modify-course.php": <?php // configuration require("../includes/config.php"); // query admin table to retrieve current admin's profile //select a particular admin by id // query users table to retrieve current admin's profile if (array_key_exists('aid', $_GET)) { // select a particular admin by id $stmt = $pdo->prepare("SELECT * FROM admin WHERE aid=?"); $stmt->execute([$_GET["aid"]]); $admin = $stmt->fetch(); # get admin data if …

Member Avatar
Member Avatar
+0 forum 3

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

The facts: We are talking about a small company (5 persons) with many clients that making real money (we don't) . We provide our own software that has unique features against the e-commerce completion. The problem: the first glimpse of the problem arose around 2012 and made clear around 2014 with web sockets. Some clients didn't want a simple chat with their client but instead a full live eShop where they could negotiate the prices of a product or even start a discussion with a visitor. The solution would be implementing web sockets in to our framework and that worked …

Member Avatar
Member Avatar
+1 forum 7

Hi, When I was trying to create the IT Request Form and testing it out, I got some problems during the testing. The home page (index.blade.php) ended up getting an error called "Undefined offset: 1", maybe due to the table database problem. ![0TyCAu.png](/attachments/large/4/8730ed8f11be3f5ed672376eee11d83f.png) The checkboxes in the Request Form (requestForm.blade.php) should not be all checked, instead the user has to select a checkbox option. ![0Tyvyx.png](/attachments/large/4/338e30d7d03b784fd3c723e1bf5d80fb.png) Is there a way to fix the form? My IT Request Form project: https://drive.google.com/file/d/1Vpif_1Cxm-Kkw-4_5ZKYt-Tjd1IWJB9_/view?usp=sharing *Please note that the data I entered when testing is fictional (not real).

Member Avatar
+0 forum 0

Hi, I do need help with the PDF2Text, as this is my first time doing that function in the practice web PHP project created from Laravel. When I remove the PDF2Text.php controller, the error message controller is not found. When I restore the same file, the error message says class already exists. How to fix that? My PHP project: https://drive.google.com/file/d/14ZrBbrzD_xG0LlCltb8Ktv-gynHKXuRG/view?usp=sharing

Member Avatar
+0 forum 0

Hi All, I am building an eCommerce website and I really new to PHP and MYSQL but loving the challenge. On my website I have 9 different categories of products with each page having about 8 items to sell. Rather than duplicating the code from each .php/.html file into a new file and change the SQL query, is it possible to write a script that says when the user clicks on category1 in the navigation bar, show all the products in category1? Hope this makes sense. Thanks in advanced.

Member Avatar
Member Avatar
+1 forum 4

Hi All, So I an creating an online store just to play around with code and learn from it. I am building a store and on the confirmation page, I am trying to update the QTY of items in a cart by using the '-' or '+' buttons. However I am having no luck at all. Here is my code: <?php foreach ($_SESSION["cart_item"] as $item){ $item_price = $item["quantity"]*$item["price"]; ?> <tr> <td><img src="<?php echo $item["image"]; ?>" class="cart-item-image" /><?php echo $item["name"]; ?></td> <td><?php echo $item["code"]; ?></td> <td style="text-align:center;"> <table class ="cart-info"> <tbody> <tr> <form method='post'> <td> <button class="btn-increment-decrement" id="add" onClick="decrement_quantity(<?php echo $_SESSION['quantity']-- …

Member Avatar
Member Avatar
+0 forum 1

The year 2019 has brought new hopes with its arrivals. People around the world are looking for new web development trends the year is going to bring with it. People who are running their website online is looking forward to the emerging trends to adapt the best possible changes and discard any unsuitable or unnecessary. As trends keep changing in term of sustainability, functionality, web design and development. ## Top Web Development Trends To Follow ## * Bold and better colours * Single page websites * The growth in mobile web designs * AI and chat boats * Static website …

Member Avatar
Member Avatar
-1 forum 1

I have a website that lists pdf files for downloading, with links to each file. What I want to do now is design a search page that will look in the folder that contains these docs and search for docs that match a partial name. I have created search pages for MySQL before - do I have to create a table with file names and links and then do a search of MySQL? TIA, jej1216

Member Avatar
Member Avatar
+0 forum 10

Hi All, I am trying to create some search functionaltiy for my website, but for some reason when I search any word, even if its not in my database it will display all the results from a particular column. Here is my code <?php error_reporting( ~E_DEPRECATED & ~E_NOTICE ); define('DBHOST', 'localhost'); define('DBUSER', 'root'); define('DBPASS', 'mypass123'); define('DBNAME', 'topgrub'); $conn = mysqli_connect(DBHOST,DBUSER,DBPASS); $dbcon = mysqli_select_db($conn,DBNAME); if ( !$conn ) { die("Connection failed : " . mysqli_error()); } if ( !$dbcon ) { die("Database Connection failed : " . mysqli_error()); } ?> <?php if(isset($_POST['search'])){ $q = $_POST['q']; $query = mysqli_query($conn,"SELECT * FROM `products` …

Member Avatar
Member Avatar
+0 forum 4

Hi, Me and my colleague are trying to fix an error when we are testing to upload the file to the storage in our PHP test project. The error is called: **FatalThrowableError (E_ERROR): Call to a member function getRealPath() on null** ![0CtiPf.png](/attachments/large/4/a9bee726794f71d1f2c22c42f3f93093.png) We are using Laravel to create a new project. Can help what code has the problem and how to fix it? Here is the project zip file: https://1drv.ms/u/s!AqKGcmac7PpVgdUraHfDoXoZ2zpXFA

Member Avatar
+0 forum 0

I recently have created a Markdown Plugin for WordPress. It has been tested some my friends, but not many people know it yet. https://github.com/terrylinooo/githuber-md I just need some suggestions to improve it, my some questions like: What features do you need if you are using Markdown to write articles? Do you think this plugin is useful to you or not, how can I imporve it? Thanks a million.

Member Avatar
+0 forum 0

Hi All, As part of a university project I need to create a website that sells cosmetic products. The customer will need to go through the motions of selecting the items, placing them into a basket and going through the checkout process. However I wouldnt need to use a card merchant to process the transaction. customers would also need to sign up and create an online account. I have created simple websites before, with HTML and CSS, but thats it. What development langauges would I need to know other than the two above? I assume PHP and Javascript will be …

Member Avatar
Member Avatar
+1 forum 4

I'm working on the application where I want to calculate the total late hours of an employee from a set of records between the employee timing shift? Example Of Employee Time Shift Shift Start: 01:00:00 Shift End: 09:00:00 Php Code // example 1 error_reporting('0'); $time1 = "01:00:00"; $time2 = "09:00:00"; date_default_timezone_set('Asia/Karachi'); echo "Time difference: ".get_time_difference($time1, $time2)." hours<br/>"; function get_time_difference($time1, $time2) { $date = date('h:i:s a', time()); $time1 = strtotime("1/1/1980 $time1"); $time2 = strtotime("1/1/1980 $time2"); $totalshifttime = ($time2 -$time1) / 3600; $totallate= $totalshifttime - $date ; return $totallate; }? Let's support if ABC employee clock in at 2 pm then should …

Member Avatar
Member Avatar
+0 forum 1

I am working on a anouncement system. the announcements are displayed everywhere in the website, every anouncement has a acknowledge button, basicaly to mark it as seen. what i have: Table: announcements: annId, annTitle, annContent, annDatetime Table: annComplete: annCompletedId, annId, userId, annCompleteDatetime I first pull all the announcements from the table `$result = mysqli_query($link, "SELECT * FROM announcements"); if (mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_assoc($result)) { ` durring the while portion I go to the annComplete: `$check = mysqli_query($link, "SELECT * FROM annComplete WHERE `userId` = "$userId" AND `annId` = '".$row['annId']."'"); if(mysqli_num_rows($check) == 0){` in here I check if …

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

Hello i am getting an error on a CASE WHEN THEN syntax on my mySql SELECT DISTINCT u.uid,c.c_id,u.name,u.profile_pic,u.username,u.email,c.time FROM conversation c, users u, conversation_reply r CASE WHEN c.user_one = '99' THEN c.user_two = u.uid WHEN c.user_two = '99' THEN c.user_one= u.uid END AND ( c.user_one ='99' OR c.user_two ='99' ) AND u.status='1' AND c.c_id=r.c_id_fk AND u.uid<>'1'ORDER BY c.time DESC LIMIT 15 #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CASE WHEN c.user_one = '99' THEN c.user_two = u.uid WHEN c.user_t' at …

Member Avatar
Member Avatar
+0 forum 4

Hi i am trying to view my blog or post in detail description at that time my browser title shows %page_title%, But it has to show my blog or post title in that place. please help me to solve this issue. **My permalink settings as below** /%category%/%postname%/ **Note:** i have attached a screen below for reference. ![blog_title_LI.jpg](/attachments/large/3/27c5c942f9f63247e0b06405f4108a36.jpg) Word

Member Avatar
Member Avatar
+0 forum 1

What are general considerations when choosing an open source library

Member Avatar
Member Avatar
+0 forum 1

Hello php community, Could you help me in my research? I just cannot find what I am looking for. I am working on a website with PHP and MySQL. I am trying to get a filter option on my website to fetch the information from database. Here are the filter options: -All -Team 1 -Team 2 -Team 3 -Team 4 I'm trying to impliment a filter, by pressing it, show specific data from database in my html table. If yuou know of a website/tutorial that can help me please let me know. Thanks Alex

Member Avatar
Member Avatar
+0 forum 1

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

Hello there, > colud you please tell me that how can i generate html into csv, actually it display all tr and td into csv file, here i have share my code <?php /*include("wp-config.php"); include("wp-app.php"); include("wp-active.php"); include("wp-settings.php");*/ //include("index.php"); include("wp-load.php"); include("wp-includes/template-loader.php"); header ("Expires: Mon, 12 Aug 1988 23:30:00 GMT"); header ("Last-Modified: " . gmdate("D,d M Y H:i:s") . " GMT"); header ("Pragma: no-cache"); header ("Content-type: text/csv; charset=UTF-8"); header ("Content-Disposition: attachment; filename=report.csv"); header ("Content-Description: Generated Report" ); /* wordpress $wpdb->hide_errors(); @set_time_limit(0); @ob_clean(); header( 'Content-Type: text/csv; charset=UTF-8' ); header( 'Content-Disposition: attachment; filename=woocommerce-product-export.csv' ); header( 'Pragma: no-cache' ); header( 'Expires: 0' ); $fp = …

Member Avatar
Member Avatar
+0 forum 8

Laravel App checks redis database for data pushed by 3rd Party. Laravel Scheduler runs artisan command `php artisan check:redis` every 10 mins. I am expecting about 20k records to be checked every hour at peak times. Please also suggest me if my whole approach as a whole is flawed. 1. Scheduler runs check:redis command every 10 mins 2. check:redis command should dispatch job to be queued 3. Queue will later process jobs and create rows as required. Below is handle() method from `App\Console\Commands\CheckRedis` public function handle() { while(Redis::llen('schema_queue')){ dispatch(new CheckRedisJob($redis->rpop('schema_queue'))) } } and this is `App\Jobs\CheckRedisJob` public function handle() { …

Member Avatar
+0 forum 0

Hey everyone, I'm working on one project of mine and for that I need legit credit card details for testing purpose. Can I develop any small tool or script which can help me out everytime to generate unique credit card details. This way, I can test my billing or payment section easily. Any help would be appreciated.

Member Avatar
Member Avatar
+0 forum 7

Hi, i want to include images in email,i write the following script which unfortunatly not working,please any one help me resloved my issue `$to = "example@gmail.com"; $subject = "new account created"; $body = "New account has been created <img border=’0' src=’http://www.example.com/myimages/track.php?MID=1111&SID=2222' width=’1' height=’1'> " ; $headers = "MIME-Version: 1.0" . "\r\n"; $headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n"; $headers .= "From: admin@gmail.com"; $neww=mail($to,$subject,$body,$headers); `

Member Avatar
Member Avatar
+0 forum 11

Hello, This is PHP. Help me understand this code: if($selectDB == true){ $query = "INSERT INTO recruitment (ID, nama, jenis_kelamin, tanggal_lahir, nohp, email, alamat, provinsi, kota, zip, status_nikah, jumlah_tanggungan, agama, file_attachment, cover_letter) VALUES (NULL, '$nama', '$jenis_kelamin', '$tanggal_lahir', '$nohp', '$email', '$alamat', '$provinsi', '$kota', '$zip', '$status_nikah','$jumlah_tanggungan','$agama','$file_attachment', '$cover_letter');"; // "INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) // VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');"; $simpan = mysqli_query($connect, $query); echo "save - ".$simpan; if(!$simpan){ echo 'failed'; }else{ echo 'success'; } } I wonder why $simpan = '' ? 1simpan - failed? What did I do wrong?

Member Avatar
+0 forum 0

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 3

The End.