Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok dito

[salem_saint]

pa help naman mga sir/mam, need kong mag upload ng data from excel baka po may tutorial kau dyan

 

[magicokeys]

Good day mga Sir;

Self study po ako sa web developing ask ko lang kung pano ung code sa php para mag connect ng database at insert query ? Gagawa sana ako ng log in ..

Maraming salamat sa lahat.

Try mo here w3schools -> MySQL Connect

- - - Updated - - -

May binubuo po kasi akong dashboard para sa business namin. PHP based customer dashboard siya, ang tanong ko po if possible po bang gumawa ng dashboard na may SMS feature?

Possible po, try niyo po isearch sa google.com, "PHP with SMS"

- - - Updated - - -

Hello there! Sino po mga freelance web developer dyan? Tanong lang po, magkano po ba ang pagawa ng isang website for business? Thanks po!

- - - Updated - - -

paano ba yan miss?

Ako po pwedeng makatulong sa business niyo, freelance web dev at fulltime IT Specialist.. Thanks Godbless!

 

[chappie006]

mga sir pano icocode sa java
kapag gusto mo makuha ang correct letter and index
example :
PROGRAMS
tapos may input na :computer
correct letter:4
correct index:2,0,1,7

 

[anishgiri]

Laravel beyond CRUD


https://stitcher.io/blog/laravel-beyond-crud

 

[anishgiri]

ways to develop your skills at php

Working with big databases to find the correct balance between ORM usage und native queries.

Working with high traffic APIs (i my case 1000/reqs) to learn writing performant code, using caches, deal with changes, versioning etc.

Working with command (i my case mostly export/import script to migrate dbs etc.) to learn how to wirte good command maybe with interaction or meaningful outputs

Refactor Code, if there is some old shitty code one wants to touch -> refactor it or rebuild it. It helps to get into other peoples code

Wirte Unit Tests to find out when/how they improve and when/how they hinder coding

Work with external APIs (for me AWS, Google) to see how people design APIs

Also get into the tools around PHP to get a better environment and understand the big picture. For it was:

Setup local coding environment with Ansible/Vagant or Docker

Use a proper git flow

Wirte deployment script that automatically build and deploy your changes

Setup Jenksins/Bamboo to automate test, build (composer, assets with gulp, webpack etc. ) and deployment

Setup log monitoring (for me Filebeat + ELK)

Get into Nginx or Apache (caching, compression, security, load balancing)

Wirte health checks for your system

Setup new Domains and Subdomains

Work with SSL Certs (Let's encrypt, own root cert, wildcard certs, ev certs etc.)

Add Hooks to Gitlab, Github or Bitbucket etc.

Use static code analyses and linting

 

[Dawgs]

pa help naman paki explain mga ito..

1. Explain an advantage of using the pgcrypto extension and plpgsql functions instead of PHP
functions for authentication purposes.

2. Explain why it is important to develop all plpgsql functions before writing any PHP scripts for
web application.

3. Explain how plpgsql functions can make it easier to code PHP scripts.

 

[anishgiri]

Na release na ang php 7.4.0. Iyung perfomance benchmark test ay promising.
https://www.php.net/index.php#id2019-11-28-1

Performance benchmark test.
https://www.phoronix.com/scan.php?page=article&item=php-74-benchmarks&num=1

 

[anishgiri]

Good resources for php developers.

https://thephpleague.com/

 

[MIKEJOHN LUCENECIO]

Goodafternoon po sir ask lang po ako kung anoong xampp ang applicable sa laptop ko po, once po nag dl ako ng xampp kaso dipo gumana window 7 po laptop ko. Thankyou in advance po

 

[rhenan143]

Hello po, pano po paganahin si google drive na naka embed sa wordpress di sya gumagana sa safari or any ios na safari pero ibang browser at mobile gumgana.

 

[columnar]

Hello Ma'am/Sir,
Meron sana akong itatanong o i hihingi ng tulong.
Meron po akong ginawang "search page kung saan makikita ko lahat ng mga listahan ng mga Land Owner gamit itong PHP mysql", pagkatapos po ito na po yung itatanong ko o i hihingi ko ng tulong. Papaano o pwede po ba na pagka search ko ng land owner ex: Pedro tapos sa bandang dulo mey button doon na kung saan pagka click ko ay lalabas po yung data nya na ginawa ko sa Excel na iyong mismong excel file na Pedro.xls ay bubukas o mag lalaunch, sa halip na i mamanual ko pa po siyang hanapin at buksan., Pwede po ba iyong gawin sa PHP?

Ganito po yung mukha sa PHP Search Page.

Land Owner: Area Sqm: Tax Dex No.: LINK:
Pedro 3.0000 11-0001-00032 OPEN

pahabol: papano po kaya gawan ng hyper link ang buton na OPEN para ma buksan o mailaunch yung Pedro.xls?

salamat po.

 

[cloud211]

Php user po.. Guys patulong nmn.. 2 weeks ko ng inaaral,, d ko pa rin maayos.. d kc nababasa ung laman ng Excel File kapag naUpload.. pero kapag sa local using Xampp eh pwd nmn.. ung database nanggagaling sa Domain.. Cpanel ang gamit... . d ko na alam ang gagawin... lapit na final Defense... patulong nmn po.. pls..

 

[papara1017]

Re: Mga Tanong tungkol sa PHP, CSS, jquery, HTML at MySQL pasok D2

Boss penge po ako code for converting HTML/PHP page to PDF. Please po

 

[raymundpogi]

Php user po.. Guys patulong nmn.. 2 weeks ko ng inaaral,, d ko pa rin maayos.. d kc nababasa ung laman ng Excel File kapag naUpload.. pero kapag sa local using Xampp eh pwd nmn.. ung database nanggagaling sa Domain.. Cpanel ang gamit... . d ko na alam ang gagawin... lapit na final Defense... patulong nmn po.. pls..

Not familiar with Spout so kakacheck ko lang ng docu kanina lang.

Anong version ng Spout ang gamit mo? Kasi kung 3.x na, nagbago na yung syntax nila.

Read Reader changes here: https://github.com/box/spout/blob/master/UPGRADE-3.0.md#reader-changes

Here's a working & modified version of your code.

<?php
// [COLOR="#FF0000"]use Box\Spout\Reader\ReaderFactory;[/COLOR]
use Box\Spout\Reader\Common\Creator\ReaderEntityFactory;

require_once './spout-3.1.0/src/Spout/Autoloader/autoload.php';

if(!empty($_FILES['excelfile']['name'])){
	$pathinfo = pathinfo($_FILES['excelfile']['name']);

	if(($pathinfo['extension'] == 'xlsx' || $pathinfo['extension'] == 'xls')
		&& $_FILES['excelfile']['size'] > 0)
	{
		$file = $_FILES['excelfile']['tmp_name'];

		// [COLOR="#FF0000"]$reader = ReaderFactory::create(Type::XLSX);[/COLOR]
		$reader = ReaderEntityFactory::createXLSXReader();
		$reader->open($file);

		foreach ($reader->getSheetIterator() as $sheet) {
		    foreach ($sheet->getRowIterator() as $row) {
		        // do stuff with the row
		        $cells = $row->getCells();
		    }
		}

		$reader->close();
	}
}

?>
<!DOCTYPE html>
<html>
<head>
	<title></title>
</head>
<body>
	<form method="POST" enctype="multipart/form-data">
		<input type="file" name="excelfile" accept=".xlsx,.xls"/>
		<button type="submit">Submit</button>
	</form>
</body>
</html>

P.S. Napadaan lang lels

--------------------------------

Update: Ahhh! Working na pala sa local. Kung inupload mo sa live, baka sa config ng server mo like naka-off yung file_uploads directive

Sa php.ini, dapat ganto siya

file_uploads = On

 

[cloud211]

Sir sobrang salamat sa effort mo sir.. bale nahanap ko na ung problem sir.. case sensitive pla ung mga nadeclare.. haist.. thanks parin po..special thanks to TS.. Godbless everyone.. sna marami pa matulungan..

 

[byakuran0425]

gagana ba yun lumang code sa bagong version?.. matagal na kasi ako hndi gmgamit.. 2.5 version sqlyog p ata yon haha..

 

[Rochel01101986]

Mga Sir, sino po marunong sa HTML Responsive Theme e-commerce? Parati kasi all ngkakaerror missing liquid after mgupload ng theme. Baka pwede nyo ako tulungan dito ako kumukuha ng HTML themes https://templated.co thank you po in advance.

 

[Nichie23]

View attachment 379180

Mga boss pano po ba gawin dyan pra hindi na mag pop up yan mga boss. hindi kasi ako makapag insert ng column sa table ng dbase ko kasi kelagan nya pa i save yung query.

salamat sa mga sasagot boss. need ko lang kasi

 

[kimaruza]

Mga Mam/Sir,

Tanong ko lang kasi kung ano ba mga demand ngayon satin sa web development kasi nag aaral ako ngayon and wala akong idea kung ano nangyayari sa IT industry sa pinas, before sana ako maka graduate mag aaral ako ng mga mostly demand na skills ngayon. Goal ko po kasi maging Full-stack developer and may roadmap na ko kung ano mga aaralin ko pero need ko lang din ng idea kung ano ganap sa real life work ng mga IT.

 

[scammer087]

Patulong po ako , bago lang po ako sa laravel. meron ako na download na sourcefile sa github. after login ganto yung error nya. View attachment 379837